MySQL Installation/Configuration

From Rhomicom Wiki
Revision as of 12:59, 11 March 2021 by Admin (talk | contribs) (→‎Reset Root)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;
 quit
 sudo systemctl stop mysqld
 sudo systemctl start mysqld

Backup

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