If you’re installing WordPress manually, then you will need to know how to create a database with your host. The tutorial below assumes that your host uses cPanel and has phpMyAdmin installed.
Log into your website’s admin panel (cPanel) and click on the MySQL Databases icon.
When the MySQL overview page loads, scroll down to the section labeled Add a Database and type the desired name of your database in the box below, then click on the Add Db button (some hosts may have the button labeled Create Database). If the database was created successfully, you’ll receive a confirmation message, click on the Go back link to return to the MySQL overview page.
Scroll down to the area labeled Add a Database User and type the desired username for the new database user and a password, then click on the Create User button. If all went well, you’ll be presented with a confirmation message, click on the Go back link to return to the MySQL overview page.
In order for your scripts to access your new database, you’ll need to give a user permission to access it. To do this, scroll down to the area marked Grant Access to a Database User (or Add Users to Your Databases depending on your host) and from the User drop down menu, select the user you want to associate with your database and then select the database from the Database drop down menu. Click on the Add User to Db button. If all went well, you’ll be greeted with a confirmation message, click on the Go back link.
From the MySQL overview page, verify that the user was added to the database with the proper permissions. If so, then you’re all set, now must make a note of the database name, the username, and the user’s password for later reference.
thanks. your tutorial helped me create my first mysql database. it is actually so easy.
# March 3rd, 2008
Thank you VERY MUCH. I am a beginning blogger flopping around and this tutorial was beautifully simple.
# May 27th, 2009