Reset mysql root password

How to reset mysql root password

by
MySQL Cluster

it is quiet easy to reset mysql root password, here are the steps SSH as root to your machine Turn off the mysqld daemon if running RedHat/Fedora users can do so by executing:  service mysqld stop Run safe_mysqld by executing:        safe_mysqld –skip-grant-tables (this will run allow you to connect without a password) 4. … Read more

Reset mysql root password

by
mysql reset password

Steps to reset the mysql root password Step # 1 : Stop mysql service # /etc/init.d/mysql stop Step # 2: Start to MySQL server w/o password: # mysqld_safe –skip-grant-tables Step # 3: Connect to mysql server using mysql client: # mysql -u root Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL … Read more