Here is how to use phpMyAdmin to create a database.
I am using WordPress as an example but most scripts like Joomla require similar database information and setting up a database is much the same.
Just substitute your own names and passwords to suit your particular Joomla script.Let me know if anything is not clear for you.
Required information being asked to create by a script.
- Code: Select all
define('DB_NAME', 'wordpress'); // The name of the database
define('DB_USER', 'wp'); // Your database username
define('DB_PASSWORD', 'pw'); // ...and password
define('DB_HOST', 'localhost') // The database host
If we use this info above as an example then we create a database "
wordpress", a user "
wp" with a password "
pw" on host "
localhost" with
all privileges like this:
Go into phpMyAdmin from the XAMPP welcome Page
http://localhost or type
http://localhost/phpmyadmin in your browser.
Create Database In phpMyAdminIn the text box "Create New Database" type
wordpressclick on
CreateIn the left hand frame find the Home icon near the top and left - click on it.
You will return to the first screen we just typed "wordpress" in.
In the left frame you should see "
wordpress (0)".
The wordpress database is now created.
Create A Database UserClick on
PrivilegesClick on
Add a new UserFill in the blanks
User name:
wpHost: Select
Local from the drop box
Password:
pwRe-type:
pwClick on
Go (bottom right)
Click on the Home icon in the left frame again.
This will put you back to the home page again.
We now have a user
wp with a password
pwNow we have to give the user
wp privileges to our
wordpress database.
Give A User Database PrivilegesClick on
PrivilegesIn the list, find your
wp user and click on the
Edit Privileges pencil icon at far right of the name.
Find the box "
Database-specific privileges".
Select the
wordpress database in the drop box
Add privileges on the following database:In the next screen that is displayed after selecting the
wordpress database
Click on
Database-specific privileges
( Check All )Click on
GoClick on the Home icon in the left frame once again to return you to the phpMyAdmin home page.
We now have a database on
localhost called
wordpress with a user
wp who has a password of
pw with
all privileges to use that database.
To Check All Is CorrectClick on the database
wordpress (0) in the left frame.
Click on the
Privileges button in the top menu.
Check that you have the following in the
Users having access to "wordpress" table.
- Code: Select all
User Host Type Privileges Grant
wp localhost database-specific ALL PRIVILEGES Yes
Thats it and you are set to go and complete your Wordpress installation.
Give Joomla the details of the database you just created when asked and it should try and connect to the database and give you the nod if it can.
You can use the above method to create any database with any username with any password for any script you want in the future, so keep a copy of this procedure.
Good luck!