- Log into phpMyAdmin as “root”
- Select the Privledges option.
- Select the option to add another user.
- Set the following values:
- For user name, enter a value consistent with the site. I always make the user name the same at the site, for example “myjoomlasite_com”.
- Leave the Host option set to Any Host.
- Assign a password; again I use something with the site name.
- Under the Database for User section, select “Create database with same name and grant all privileges”. In my example, this would create a database called “myjoomlasite_com” and assign the user “myjoomlasite_com” admin rights to it.
- Click Go to execute the query.
- Close out of phpMyAdmin.
Keep in mind, the above settings are strictly what I go by in order to maintain consistency. If you have a scheme which works for you already, you can easily adapt your preferences to the way you set up a MySQL database for Joomla.
