nicolasramy/MySQL.md

Remove

To remove everything related to MySQL, you have to follow this procedure

sudo -i service mysql stop killall -KILL mysql mysqld_safe mysqld apt-get --yes purge mysql-server mysql-client apt-get --yes autoremove --purge apt-get autoclean deluser --remove-home mysql delgroup mysql rm -rf /etc/apparmor.d/abstractions/mysql /etc/apparmor.d/cache/usr.sbin.mysqld /etc/mysql /var/lib/mysql /var/log/mysql* /var/log/upstart/mysql.log* /var/run/mysqld updatedb exit

Change root password

Stop MySQL Server

service mysql stop

Start Mysql uin safe mode without Grant Privileges

mysqld_safe --skip-grant-tables

For MySQL 5.7.6+

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

For MySQL 5.7.5 and lesser

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');