Hello.


You should start mysqld-nt with --skip-grant-tables option and

manually update the user table. Connect to server using mysql

command line client. Execute the following statements:



  use mysql;

  update user set Grant_priv='Y' where user='root' and host='localhost';



Restart the server as usually. See also:

  http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html



   

   

   >I'm working on Windows XP Professional and I'm using EasyPHP1-7 with Apache

>1.3.27, PHP 4.3.3, PHPmyAdmin 2.5.3, MySql 4.0.15.

>1 - I must start up Easy PHP with [EMAIL PROTECTED] If I try to work with

>other users by the user parameter in config.inc.php, PHPmyAdmin doesn't

>work.

>2 - I switch off the Grant option to the ROOT user with EasyPHP and now I

>can't reset ON the Grant option to ROOT user even if I use the procedure

>(Stop mysql services and enter mysqld-nt command and so on, in fact the

>mysqld works but not mysqld-nt..) or by the GRANT SQL command.

>

>Could you explain to me how can I do it?

>

Thank you

"Philippe Cabet" <[EMAIL PROTECTED]> wrote:



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to