Start password reset in mysql Security Mode

1. Stop running MySQL process [Linux] Run killall-TERMmysqld2, start MySQL in safe mode [Linux] Run usrlocalmysqlbinmysqld_safe -- skip-grant-tables [Windows] Run X on the command line: mySQLbinmysqld-nt.exe skip-grant-tables3

1. Stop the running MySQL process [Linux] And run killall-TERM mysqld 2. Start MySQL [Linux] in safe mode to run/usr/local/mysql/bin/mysqld_safe -- skip- grant-tables [Windows] Run X on the command line: /MySQL/bin/mysqld-nt.exe -- skip-grant-tables 3

1. Stop the running MySQL process

[Linux] Run killall-TERM mysqld

2. Start MySQL in Safe Mode

[Linux] Run/usr/local/mysql/bin/mysqld_safe -- skip-grant-tables &

Windows: run X:/MySQL/bin/mysqld-nt.exe -- skip-grant-tables on the command line

3. You will be able to access MySQL without a password.

[Linux] Run/usr/local/mysql/bin/mysql-u root-p to enter

[Windows] Run X:/MySQL/bin/mysql-u root-p to enter

4. Change the password

> Use mysql

> Update user set password = password ("new password") where user = "root ";

> Flush privileges;

Http://www.macophp.com /? ActIon = show & id = 3