PHP Warning: mysql_connect(): Access denied for user 'www'@'localhost'

boloo · 01-15-2013, 05:18 AM

Hello All,

I am having serious problem with this error. We had old SME server, needed to move to new server., old server also has intranet site for local application, in php and mysql. So I used the affa , outline in http://wiki.contribs.org/Moving_SME_to_new_Hardware . After rising the backup server to production server, when I go to intranet, I am getting mysql_connect() error. I dont have password for mysql, I can log in to mysql without password from command line. the strange thing was , I backup mysql databases and restored to one of the test machine and copied all the folders and files from /home/e-smith/files/ibays , it worked, not sure what is happening here. Please help.

acid_kewpie · 01-15-2013, 05:36 AM

well fundametnally it's a pretty simple error. there is somethign wrong with the credentials you're using, either the app is using them wrong, or they are not correct / don't exist in the database. So if you're restored the DB, look in the dump for the appropriate GRANT entries and such like.

Code:

mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON <database>.* TO '<user>'@'localhost'
    ->     WITH GRANT OPTION;

boloo · 01-15-2013, 06:22 AM

Thanks man,
I am trying to create the user
CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass'; exactly as it is , and getting ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USER 'monty'@'localhost' IDENTIFIED BY 'some_pass'' at line 1 . What I am getting when I go to local site is, "Warning: your browser was not able to connect to the database-server. Please try to reload the page by clicking on reload. " . The thing I dont understand is exactly the same dbs and php code , supposed to be identical copy using affa as well. I am pulling my hair out..

acid_kewpie · 01-15-2013, 06:28 AM

well you've not said that you've actually LOOKED at the db setup to see if the user should be able to log in or not.

boloo · 01-15-2013, 06:43 AM

Hi Chris,

I just set the root user with password, and set it in the php files variable. no more of connection error in log, but not displaying anything either. So checking the log at the moment,

boloo · 01-15-2013, 06:50 AM

It seemed to be wokring now, I am suprised that same code same databases and same users not working. Thank you very much your help man, that saved my life

acid_kewpie · 01-15-2013, 07:01 AM

root??? I hope this is not a public facing site, or you're going to regret that.

boloo · 01-15-2013, 07:06 AM

yep, I know , it is only for internal, but still not the bright idea, but for right now , i just need to prove the concept.

chrism01 · 01-15-2013, 05:45 PM

This script shows the current grants/users on a db; you'll need the mysql root user's passwd

Code:

mysql -u root -p${1} --batch --skip-column-names -e "SELECT user, host FROM user" mysql | sed 's,\t,"@",g;s,^,show grants for ",g;s,$,";,g;' | mysql -u root -p${1} --batch --skip-column-names | sed 's,$,;,g'

HTH

Wim Sturkenboom · 01-16-2013, 02:41 AM

MySql changed the password hashing somewhere along the line (version 4.1 or so). So old authentications no longer work on newer versions; I think it is possible to configure MySql to use the old hashing but 'm not 100% sure.

That's a possible cause. You can check the passwords in the MySql user database for their length; and the new 'format' password starts with '*' while the old ones don't.