Access denied for user root@localhost
| User, date | Message |
|---|---|
|
Written by Amps
5 years ago Category: Creating a connection 2 posts since Tue, 01 Jan 08 |
I'm getting the error Could not establish connection! Details: SQL Error: Access denied for user 'root'@'localhost' I've tried using a password, as well as not using one. I've used MySQL in the past, but I've uninstalled it, and I started fresh with HeidiSQL. Let me know if you need more info. Thanks. Cody |
|
Written by ansgar
5 years ago 3952 posts since Fri, 07 Apr 06 |
You uninstalled MySQL ? I guess you mean MySQL-Front? The message "access denied" means you have to find the right password for root. A fresh MySQL server normally has an empty password set for this root user. If you changed that password yourself, noone else than you will be able to tell it. Or, you can temporarily configure the server to ignore the authentication tables, so you can connect to it with empty user and password. You will have to add this to your my.ini file: [mysqld] Don't forget to remove the entry from your my.ini afterwards because that's extremely insecure. |
|
Written by Amps
5 years ago 2 posts since Tue, 01 Jan 08 |
Okay, now i'm getting "SQL Error: Can't connect to MySQL server on 127.0.0.1 (10061) |
|
Written by ansgar
5 years ago 3952 posts since Fri, 07 Apr 06 |
Most obviously your mysql server has been stopped in the meantime. Just restart it by doing a net start mysql |
|
Written by Cheddars
5 years ago 1 posts since Sun, 20 Jan 08 |
Amps wrote: I'm getting the error I'm getting the same error message and I can't seem to find the file you need to put the codes in, where woudl they be locatd? |
|
Written by ansgar
5 years ago 3952 posts since Fri, 07 Apr 06 |
Somewhere in your %PATH% environment or in the directory where you have installed MySQL. Try these: C:\Windows C:\ C:\Path\To\MySQL\ |
|
Written by slpmet
5 years ago 3 posts since Sun, 03 Feb 08 |
i got the same problem but i dont know what to do know because the user and password ive got from an program where i can create wow servers so i need some help plz help :( |
|
Written by ansgar
5 years ago 3952 posts since Fri, 07 Apr 06 |
Help on what exactly? Didn't the postings above help you somehow? |
|
Written by slpmet
5 years ago 3 posts since Sun, 03 Feb 08 |
no they didnt its because im using the program manGOS to create an private server to wow and there, there is a text where it says user pass where it cant log in with those |
|
Written by ansgar
5 years ago 3952 posts since Fri, 07 Apr 06 |
And what about the above posting with the skip-grant-tables stuff in your my.ini - did you try that? |
|
Written by slpmet
5 years ago 3 posts since Sun, 03 Feb 08 |
yeah but the differents things i could do those wasnt in my directory do you know how i can get them in?? |
|
Written by ansgar
5 years ago 3952 posts since Fri, 07 Apr 06 |
Sorry I don't get what you mean. Guessing: you didn't find the my.ini file? |
|
Written by ansgar
5 years ago 3952 posts since Fri, 07 Apr 06 |
This thread is getting a bit fruitless as there is no exact description of the problem ... However, here is one general tip for you: Is the MySQL server installed on your local computer? Yes: just follow the above posting about the my.ini . If you do not have a my.ini, just create one in C:\ No: Ask the administrator of the MySQL server to give you a new MySQL account |
|
Written by clifton
3 years ago 1 posts since Wed, 05 May 10 |
<LogonDatabase Hostname = "localhost" Username = "root" Password = "ascent" Name = "logon" Port = "3306" Type = "1"> change your everything what standing there to that only where LogonDatabase is standing or it will not work  dont say it doesnt work because on my pc works thx :D
|
|
Written by srikwit
4 weeks ago 3 posts since Wed, 24 Apr 13 |
I faced the same problem but after I started wampserver and initialized phpMyadmin then switched to heidiSQL the problem was solved. |
|
Written by kalvaro
4 weeks ago 441 posts since Thu, 29 Nov 07 |
This is a three year old thread. phpMyadmin is just a MySQL web client, it's by no means required to log into MySQL Server. |
|
Written by srikwit
4 weeks ago 3 posts since Wed, 24 Apr 13 |
so could you explain what happened that fixed my problem because I can assure you that I did nothing different. |
|
Written by kalvaro
4 weeks ago 441 posts since Thu, 29 Nov 07 |
No, I cannot explain what fixed your problem because I know nothing about it. But I can speculate that you had unflushed privilege changes and when you restarted Wampserver you inadvertently forced MySQL to apply them. Whatever, sending someone who googles here to the unnecessary burden of downloading, installing and configuring PhpMyAdmin (when he might not even have a local web server to install it on) is a misleading advice, even it it worked for you. |
|
Written by srikwit
4 weeks ago 3 posts since Wed, 24 Apr 13 |
Well thank you and I'll let you know if I find an answer. |
|
Please login to leave a reply, or register at first. |