escape
Forum Replies Created
-
Forum: Installing WordPress
In reply to: WordPress database error: [No Database Selected]I had the same problem after copying the whole environment from one server to another. I found my solution here:
http://ww.wp.xz.cn/support/topic/36462
Thanks Righton!hey, johnnycannuk, have you tried the old_password option? Your situation really calls for this, I guess. With earlier versions of MySQL there was another way to handle passwords. It only takes one statement in MySQL to change to old_password mode. See my earlier post just before your last 2 posts.
The same error kept me trying out everything for hours. Finally found out that there was a compatibility issue with password hashing between php and mysql. According to some newsgroups it’s not very clear which version combinations of php and mysql cause the password problem.
Try this. Login to mysql as root and set your mysql-password with the OLD_PASSWORD option like this:
SET PASSWORD FOR 'databaseuser'@'localhost' = OLD_PASSWORD('databasepassword');In case you didn’t know how to create a database and a user beforehand, you can use these 2 commands within mysql first after loging in as root:
CREATE DATABASE databasename;.* TO 'databaseuser'@'localhost';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON databasenameIt worked for me and I hope it will for you.
Good luck & peace!