| MySQL Access Denied [message #439563] |
Mon, 15 November 2010 13:02  |
 |
Zion
Messages: 2722
Registered: April 2006
Karma: 1
|
General (2 Stars) |
|
|
Greetings Renegade Community.
I'm looking for someone who is highly knowledgeble with MySQL to help figure out a problem that i've been having ever since i obtained MySQL.
Every time i run though the configurator, it gets to 'Applying Security Settings' and fails with the error code:
"(1045) Access Denied to root@localhost (using password: YES)"
For the life of me, i cannot figure out why... I've tried removing all trace of MySQL and reinstalling, only to give the same error. No firewall is running on the system, and port (3306) has been triggered, ranged and forwarded to the local ip.
According to Google searches, i'm told to use the command:
"GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'password';"
However no where does it say how to execute that command. I've tried executing it through mysql.exe, and it just throws the default help file back at me, and though mysqladmin.exe, it says "Unknown Command: GRANT".
I'm at a loss here, can anyone please help?
|
|
|
|
|
|
|
|
| Re: MySQL Access Denied [message #439578 is a reply to message #439563] |
Mon, 15 November 2010 15:47  |
|
Zion
Messages: 2722
Registered: April 2006
Karma: 1
|
General (2 Stars) |
|
|
The database will be used for storage not related or accessed by php, so php is not an issue here.
The GRANT command was what was returned by google...
I will try removing the database file and see what happens.
------------------------------------------
I deleted the database directory, and ran the installer again. The config completed itself, and popped up, however when i try to login to create a database, it still gives the Access Denied error... Looks like it's no luck.
[Updated on: Mon, 15 November 2010 21:33] Report message to a moderator |
|
|
|
|
|
|
|
| Re: MySQL Access Denied [message #439619 is a reply to message #439563] |
Tue, 16 November 2010 08:44 |
 |
Omar007
Messages: 1711
Registered: December 2007
Location: Amsterdam
Karma: 0
|
General (1 Star) |
|
|
PHPMyAdmin is a MySQL management system. I always use this when I use MySQL 
You are login in using this right?
The it'll prompt you for a pass which you will enter.
I'm assuming you remember your pass and have caps -lock off ;P
[Updated on: Tue, 16 November 2010 08:46] Report message to a moderator |
|
|
|
| Re: MySQL Access Denied [message #439620 is a reply to message #439563] |
Tue, 16 November 2010 08:52 |
|
Zion
Messages: 2722
Registered: April 2006
Karma: 1
|
General (2 Stars) |
|
|
mysql --user=root --password=root mypassword
Retruns the error, Access Denied for 'root'@'localhost'
-------------------------------------
I've just tried the comand you gave, and it worked with a bunch of commands, and now the program trying to use the database seems to be working too...
Not sure what i was doing wrong with the above command i was giving it... Very bizarre indeed, but it's sorted now, thanks guise. :3
[Updated on: Tue, 16 November 2010 09:08] Report message to a moderator |
|
|
|
|
|
|
|
Search
Help
Members
Register
Login
Home
Look into phpMyAdmin (assuming you're using PHP) for help in that area.
