MySQL Installation/Configuration

From Rhomicom Wiki
Jump to navigation Jump to search

Useful Commands

 killall mysqld mysqld_safe
 ps aux | grep mysqld
 killall -9 mysqld mysqld_safe
 sudo systemctl stop mysqld

Reset Root

 sudo mysqld_safe --skip-grant-tables &
 mysql -u root
 show databases; 
 use mysql;
 update user set authentication_string=PASSWORD("mypassword") where User='root';
 flush privileges;
 sudo systemctl stop mysqld
 sudo systemctl start mysqld


 #In normal linux shell
 mysqldump -u root -p aposo_site1 > aposo_site1_bkp2.sql