It’s Called Web Design

This will create a new database and user through the MySQL console:

1. Download an SSH client (like putty) and log into your server.
2. Enter the MySQL console.

   mysql -u root -p

3. Enter your MySQL root password
4. Create a new database by entering:

   create database your_database_name;

5. Type the following code into the console:

   GRANT ALL PRIVILEGES
   ON your_database_name.*
   TO 'your_user_name'@'localhost'
   IDENTIFIED BY 'your_password'
   WITH GRANT OPTION;
   

Remember, MySQL will let you hit the “enter” key and will not submit your query until you include a semi-colon.

If you already have the database created, then skip the forth step.

This entry was posted on Wednesday, October 1st, 2008 at 8:25 am and is filed under Tutorials. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.