What does your host use cpanel if so you create database from Database wizard icon not on phpmyadmin.
phpmyadmin is program to manage your database.
Moderator
t-p
(@t-p)
An error connecting to your database is common, but it isn’t necessarily a problem with wordpress itself.
-First, double check your wp-config.php file settings for the database name, database username and database password. This is where most errors occur.
-Then check that you don’t need to change the database host from “localhost” to something else.
-Check you have actually created a database with the same database name as is in your wp-config.php file.
-Last, but not least, if all that information is correct your database probably has a problem with it and you may need to contact your web hosting.
There are also many threads on this topic on these forums: http://wordpress.org/search/Error+establishing+a+database+connection?forums=1
Thread Starter
jfmxl
(@jfmxl)
No cpanel.
The wpadmin user I’ve created is a database user, no?
Or are you telling me that I have to create a system user wpadmin in order to run wordpress?
Thread Starter
jfmxl
(@jfmxl)
I’ve checked all the obvious things you’ve mentioned.
I’ve deleted the db/user pair and recreated as wordpress/wordpress
mysql -u wpordpress -p
gives
ERROR 1045 (28000): Access denied for user ‘wordpress’@’localhost’ (using password: YES)
Maybe it’s phpmyadmin’s sql?
What sql do you use to create the db/user pair?
Thanks.
Moderator
t-p
(@t-p)
-Last, but not least, if all that information is correct your database probably has a problem with it and you may need to contact your web hosting.
have you contacted your hosting provider?
Thread Starter
jfmxl
(@jfmxl)
I fixed it. I just used an existing user account with appropriate permissions to populate the database. Something was wrong with the user account being created by phpmyadmin… the user I had created had no global permissions, but full permissions over the relevant database. Perhaps that was the problem? Whatever, as they say. It works now.
http;//www.robinlea.com/wordpress
I do notice a place for a picture in the user profile… but no way to upload an actual picture to fill it? Is that right?
Thanks for all your help.
