Difference between revisions of "MySQL Installation/Configuration"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
sudo mysqld_safe --skip-grant-tables & | sudo mysqld_safe --skip-grant-tables & | ||
mysql -u root | mysql -u root | ||
| + | show databases; | ||
use mysql; | use mysql; | ||
| Line 17: | Line 18: | ||
sudo systemctl stop mysqld | sudo systemctl stop mysqld | ||
sudo systemctl start mysqld | sudo systemctl start mysqld | ||
| + | |||
| + | ==Backup == | ||
| + | #In normal linux shell | ||
| + | mysqldump -u root -p aposo_site1 > aposo_site1_bkp2.sql | ||
Latest revision as of 12:59, 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 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