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
 use mysql;
 update user set authentication_string=PASSWORD("mypassword") where User='root';
 flush privileges;
 quit
 sudo systemctl stop mysqld
 sudo systemctl start mysqld