WampServer
Apache, PHP, MySQL
on Windows
Access denied to mySQL
Posted by:
coeus
(---.dsl.bell.ca)
Date: December 01, 2006 08:55PM
For some reason I can't connect to mysql server, even though this was working before. All of a sudden it just stopped working, yet the server IS running. I know the user name and password (it's root and ""
and I can connect using the mysql console, but I can't connect through phpmyadmin or through any other projects I had that used the db.
This is the error I get when trying to connect:
Error
MySQL said: Documentation
#1045 - Access denied for user 'SYSTEM'@'localhost' (using password: NO)
why is it putting 'SYSTEM' ???
btw, I have the php_mysql module running as well.
Any advice?
Post Edited (12-01-06 20:56)
and I can connect using the mysql console, but I can't connect through phpmyadmin or through any other projects I had that used the db.This is the error I get when trying to connect:
Error
MySQL said: Documentation
#1045 - Access denied for user 'SYSTEM'@'localhost' (using password: NO)
why is it putting 'SYSTEM' ???
btw, I have the php_mysql module running as well.
Any advice?
Post Edited (12-01-06 20:56)
Re: Access denied to mySQL
Posted by:
coeus
(---.dsl.bell.ca)
Date: December 01, 2006 09:30PM
Fix the problem.
It has to do with the "safe mode" setting. Turning on safe mode using the wampserver tool, it turns all safe mode settings on, even sql safe mode, and this is what was causing the problem. So I had to edit the php.ini file and turn sql safe mode off.
It has to do with the "safe mode" setting. Turning on safe mode using the wampserver tool, it turns all safe mode settings on, even sql safe mode, and this is what was causing the problem. So I had to edit the php.ini file and turn sql safe mode off.
Sorry, only registered users may post in this forum.
