Welcome Guest, Not a member yet? Register   Sign In
MySQL access denied - even if the user has all privileges
#1

[eluser]Andreas Krohn[/eluser]
I am in the process of setting up my development environment on a new Macbook and I am stuck with a MySQL problem. For some reason I can not get CodeIgniter to connect to my MySQL database, according to the CI logs the problem is: "Access denied for user 'root'@localhost (using password: YES)".

The root user has complete privileges when I check the MySQL "user" table (and I have done GRANT ALL PRIVILEGES etc), and the password is correct. There is no problem logging in to the MySQL Query Browser etc with the root user on localhost. I do not know if it has anything to do with my CI problem, but for some reason I can not create schemas and tables etc in the Query Browser. Those options are simply disabled.

If anybody has any pointers on what I can try to get past this I would greatly appreciate it, I am getting really frustrated fighting MySQL.

/Andreas


Messages In This Thread
MySQL access denied - even if the user has all privileges - by El Forum - 12-02-2008, 03:03 PM



Theme © iAndrew 2016 - Forum software by © MyBB