Resetting the Root Password on Windows Systems
วันที่ 24  กรกฎาคม   2552   ผู้เขียน นฤเบศ เชื้อบ้านเกาะ
  1. Log on to your system as Administrator.

  2. Stop the MySQL server if it is running. For a server that is running as a Windows service, go to the Services manager:

    Start Menu -> Control Panel -> Administrative Tools -> Services
    

    Then find the MySQL service in the list, and stop it.

    If your server is not running as a service, you may need to use the Task Manager to force it to stop.

  3. Create a text file and place the following statements in it. Replace the password with the password that you want to use.

    UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
    FLUSH PRIVILEGES;
    
  4. Save the file. For this example, the file will be named C:mysql-init.txt.

  5. Open a console window to get to the command prompt:

    Start Menu -> Run -> cmd
    
  6. Start the MySQL server with the special --init-file option:

    C:> mysqld-nt --init-file=C:mysql-init.txt
    

    If you installed MySQL to a location other than C:mysql, adjust the command accordingly.

  7. After the server has started successfully, delete C:mysql-init.txt.

  8. Stop the MySQL server, then restart it in normal mode again. If you run the server as a service, start it from the Windows Services window. If you start the server manually, use whatever command you normally use.

    ที่มา  http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html

จำนวนผู้เข้าชม 1602

ศูนย์คอมพิวเตอร์ โรงพยาบาลมหาราชนครศรีธรรมราช 198 ถ.ราชดำเนิน ต.ในเมือง จังหวัดนครศรีธรรมราช 075-340250-2107
webmaster Naruebet Chuebankoh