Koozali.org: home of the SME Server
Legacy Forums => General Discussion (Legacy) => Topic started by: Shawn C. on May 09, 2001, 05:31:48 PM
-
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
-
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
-
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