Members

Note: You can use your Sitellite.org account here and vice versa.

Username

Password

Remember Login

Forgot your password?

Not a member? Click here to register

Create Database

Home Page | All Pages | Recently Revised | Authors | Feeds |

To create a new MySQL database for your Sitellite installation, use the following steps:

1. From the command prompt, log in as the root MySQL user

mysql -p -u root
(enter password when prompted)

2. Create the database

mysql> create database DBNAME;

Be sure to replace DBNAME with a database name of your choosing.

3. Create a new user that has permission to access your new database

mysql> grant all on DBNAME.* to USER@localhost identified by 'PASS';

Be sure to replace DBNAME, USER, and PASS with real names of your choosing. The DBNAME must be the same as the one you used in step 2.

4. Flush the MySQL privilege table, so that new connections are aware of your new user

mysql> flush privileges;

That's all there is to it.

Alternately, you can use a tool such as phpmyadmin or your web hosting control panel to do this for you.

Note: You may not have permission on your host to create a database yourself. In such cases, you will need to request that your hosting provider create the database for you and supply you with the database access information (ie. the database hostname, database name, username, and password).

Created on May 22, 2005 11:06 AM by admin

Linked from: My S Q L