The following method was described as a safe way to execute mysql queries.
Category: MySQL
5 Easy Steps to Reset a MySQL “root” Password
1. Stop the mysqld daemon process. 2. Start the mysqld daemon process with the –skip-grant-tables option. 3. Start the mysql client with the -u root option. 4. Execute the UPDATE mysql.user SET Password=PASSWORD(‘password’) WHERE User=’root’; 5. Execute the FLUSH PRIVILEGES; command. These steps reset the password for the “root” account to “password”. To change the… Continue reading 5 Easy Steps to Reset a MySQL “root” Password