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
Retrieved from "https://wiki.rhomicom.com/index.php?title=MySQL_Installation/Configuration&oldid=196"