MySQL Tips

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');