access to mysql server denied

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
thania
Forum Newbie
Posts: 11
Joined: Sun Mar 12, 2006 9:19 pm

access to mysql server denied

Post by thania »

i am using the software package EasyPHP 1.7 installed on my computer to use the MySQL and Apache server, as well as the PHPMyAdmin to manage my database. The problem now is that I cannot connect to the MySQL server which I have received the error message:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

Error

MySQL said:


#2003 - Can't connect to MySQL server on 'localhost' (10061)
I have checked and rechecked for several times the host, username, and password for it in which the host is set to 'localhost', the username is 'root' and no password is specified.

what is actually the problem and what can i do to solve this problem??
Any help is really appreciated and thank you very much.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

First tip, don't use your root account. Then, make sure you set a good password for whatever administrator account you set up. But never use root.

Next, do a google search for MySQL error code 2003. See if you can get a little more information as to why it is not letting you in.

Lastly, respond back to this forum with your findings. Make sure you post your current MySQL server version, your Apache httpd version and which version of PHP you are using. Also, let us know if you have made any recent updates to your server software.
jrd
Forum Commoner
Posts: 53
Joined: Tue Mar 14, 2006 1:30 am

Post by jrd »

Is it running locally on your system and are you using WAMP?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

jrd wrote:Is it running locally on your system and are you using WAMP?
thania wrote:i am using the software package EasyPHP 1.7 installed on my computer
jrd
Forum Commoner
Posts: 53
Joined: Tue Mar 14, 2006 1:30 am

Post by jrd »

feyd wrote:
jrd wrote:Is it running locally on your system and are you using WAMP?
thania wrote:i am using the software package EasyPHP 1.7 installed on my computer
Sorry feyd, my mind was fizzled, for some reason i got mistaken, thought it was some package like a cms or sumthin. I remember now, it's something like WAMP.

Actually thania, try re-installing the package, or look at your firewall that the port 3306 isn't blocked?
thania
Forum Newbie
Posts: 11
Joined: Sun Mar 12, 2006 9:19 pm

got solved

Post by thania »

thank u for the replies =)

i have googled the error code and problem but not so much information i got. overall, they are about what the error exactly means. The Apache version in the package I installed on my computer is 1.3.33, PHP version is 4.3.10, PHPMyAdmin is 2.6.1 while the MySQL version is 4.1.9...i did not do any upgrading to the software installed..

what i did to get the problem solved is by re-installing the software package again and again. And lastly, the MySQL server can be up again..

Thank u again for the respon. I appreciate it very much..thank u..=)
Post Reply