Deepin 安装Mariadb,设置密码以及处理忘记密码

安装mariadb

sudo aptitude install mariadb-server mariadb-client

设置密码

sudo mysql
use mysql;
update user set password=password('123456') where user='root';
flush privileges;
exit;

重置密码

#在shell 窗口1中执行以下命令
sudo service mysql stop
sudo mysqld_safe --user=mysql --skip-grant-tables --skip-networking
#显示以下信息
#mysqld_safe Logging to syslog.
#mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
#打开新的shell 窗口2,执行以下命令，即上面设置密码的命令
sudo mysql
use mysql;
update user set password=password('123456') where user='root';
flush privileges;
exit;