distal-attribute
distal-attribute
distal-attribute
distal-attribute

Access denied for user root@localhost

User, date Message
Written by Amps
7 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
7 years ago
5045 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]
skip-grant-tables=1



Don't forget to remove the entry from your my.ini afterwards because that's extremely insecure.
Written by Amps
7 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
7 years ago
5045 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
or
c:\path\to\mysql\bin\mysqld.exe --standalone

on the commandline or whatever.
Written by Cheddars
7 years ago
1 posts since Sun, 20 Jan 08

Amps wrote: I'm getting the error

Could not establish connection! Details:

SQL Error: Access denied for user 'root'@'localhost'
Cody


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
7 years ago
5045 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
7 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
7 years ago
5045 posts since Fri, 07 Apr 06
Help on what exactly? Didn't the postings above help you somehow?
Written by slpmet
7 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
7 years ago
5045 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
7 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
7 years ago
5045 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
7 years ago
5045 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
4 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 workhappydont say it doesnt work because on my pc works thx :D
Written by srikwit
1 year 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
1 year ago
599 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
1 year 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
1 year ago
599 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
1 year 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.