You don't have a database user with a password and privileges to access your wordpress database and is the reason the install is flopping
Find and click on Privileges
Click on Add a new User
Enter the following (it can be changed by you later if you wish)
User name: wp
Host: localhost (To save typing select Local from the drop box)
(you can Generate a password and enter it here if you wish but for now I would keep it simple and use this example)
Click on Go bottom right of the page
You should be back at the Privileges page with a heading of:
User 'wp'@'localhost' : Edit Privileges
Find the section heading Database-specific privileges
From the drop menu select your database wordpress
The Privileges heading should now change to:
User 'wp'@'localhost' - Database wordpress : Edit Privileges
Find Database-specific privileges ( Check All / Uncheck All )
Click on Check All
Click on Go bottom right
You will now see at the top of the page an Information entry:
You have updated the privileges for 'wp'@'localhost'.
In the left menu frame click on the Home icon.
Locate and click on Privileges again to check that all is created as expected.
You should now see an entry for
Global Privileges USAGE
Now you proceed to your item 7. and enter the credentials of your wp user in the wp-config.php.
- Code: Select all
// ** MySQL settings ** //
define('DB_NAME', 'wordpress'); // The name of the database
define('DB_USER', 'wp'); // Your MySQL username
define('DB_PASSWORD', 'pw'); // ...and password (or what ever you used)
define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value
As I said previously it is not best practice to use your root access for scripts, this is a security risk and is reserved for you, the MySQL server administrator.
Using the above procedure you now know how easy it is to follow and to:
Create the database wordpress and create a user wp and give that user a password of pw with all privileges for the WordPress database using phpMyAdmin
This procedure applies also to any and all databases you create in phpMyAdmin.
With the above addition, now try and install WordPress from the beginning and see how it goes.
You can change the database user password by clicking on the Edit icon end of the row to the wp user under Privileges item and then re-editing the wp-config.php to reflect your changes.
I hope you can follow the above and it allows you to get WordPress up and running - now let the fun begin
Take a look at the new DeskTopXampp launch control for XAMPP
and XAMPPlite (DTX.exe) posted by ridgewood:
http://community.apachefriends.org/f/viewtopi ... 967#103967
Available at Ridgewood's new DTX web site http://zedfiles.com/DTX/
Also available here: http://nat32.com/dtx/
I highly recommend DTX.