CODEWITHSUNDEEP
phpmysql
Jacob Windsor
Jacob Windsor

Reputation: 6980

Mysql access denied

Okay so heres the situation. I have just had to move servers due to budget cuts so the new server is a webfusion VPS. I am now getting an access denied error on all mysql queries. This is the specific error:

Access denied for user 'www-data'@'localhost' (using password: NO)

I do not know what is causing this. I have a database with the mysql username and password stored in a different php file. The username shown in the error is not the same as the actual ussername and I am using a password. It is my understanding that you can put your own php.ini file in the webfusions root and that will work. Is there something I have missed? I have been running on coffee today so that could be why. The mysql database is on the same server btw.

Upvotes: 0

Views: 204

Answers (2)

Josh Pennington
Josh Pennington

Reputation: 6408

It could be a couple of things. I guess let's start with what is correct.

Your MySQL server address is correct and your webserver is able to connect to it. This should be a given since your webserver and MySQL server appear to be on the same machine.

The username you are using is www-data. That is the first thing I would check. Make sure that is the proper username.

Now check your password. It looks like you are trying to not have to use a password. Chances are that is incorrect (and if it is correct, you really should think about changing that).

Other than that, there is not much else that could be going wrong there. Are you intending to connect to the MySQL server that is on the same machine as your website?

Upvotes: 1

user188654
user188654

Reputation:

Did you create the appropriate MySQL users after you migrated the database? Grant tables and user privileges are usually not transferred while doing a DB migration (unless you are using some specific tools like the ones provided by Percona etc.)

Upvotes: 0

Related Questions