Difference between revisions of "MySQL Installation/Configuration"
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
killall -9 mysqld mysqld_safe | killall -9 mysqld mysqld_safe | ||
sudo systemctl stop mysqld | 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 | ||
Revision as of 12:52, 11 March 2021
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