Search code examples
mysqlprivilegesmysql-error-1045

Mysql "access denied for user" error?

I have just added a new database and imported alot of backed up data to it because of a malfunction in the previous database.

I use php and have my own Ubuntu server.

I use phpmyadmin, and have set all privileges to the user.

I am positive the password, username and host are correct.

But I still get this "Access denied for user 'user'@'localhost' to database 'skuffen2'"

What should I do?

Do I need to set permissions somehow on the server?

Please guide me I am in deep need of help right now...

Thanks

Solution

  • login to mysql using root user, use mysql; select * from db where user where user_name=xxx; and check other table as well, most of the privileges settings are there, or just simply flush privileges;