August 27, 2014

Set MySQL to safe mode for root password change

1) /etc/init.d/mysql stop 2) mysqld_safe –skip-grant-tables & 3) mysql -u root 4) Setup new MySQL root user password use mysql; update user set password=PASSWORD(“NEW-ROOT-PASSWORD”) where User=’root’; […]