Topic: mySQL connections

[Shawn C.]

mySQL wont allow me to connect after I used this command line that gave permission to 'root@localhost' for NukePhp:
------------
mysql> grant all on nuke.* to root@localhost identified by'password here' ; '
-----------
mySQL then allowed the connection for using phpNuke, but upon trying to reconnect to either phpMyAdmin or using  command line prompts, I am no longer allowed to use mySQL.
--ERROR 1045 PERMISSION DENIED FOR ROOT@LOCALHOST USING PASSWORD (YES)--
-----------
I want to restore the mySQL settings even if it means dropping the phpNuke for now but ???

Anyone??

-sc

[Dan Brown]

RTFM.  Seriously.  MySQL has a very thorough manual, and it will explain exactly what you did, and how to fix it.

For discussion of the access privileges, see http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html

For a MySQL tutorial, see http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html

For discussion of how to fix what you broke, see http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Resetting_permissions

[Shawn C.]

Yes the manual...I have had it open now for a little while and will continue to indulge in it's secrets..
thanks
-scDan Brown wrote:
>
> RTFM.  Seriously.  MySQL has a very thorough manual, and it
> will explain exactly what you did, and how to fix it.
>
> For discussion of the access privileges, see
> http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html
>
> For a MySQL tutorial, see
> http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html
>
> For discussion of how to fix what you broke, see
> http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Resetting_permissions