sudoaptinstall mysql-server mysql-client
sudocat /etc/mysql/debian.cnf
mysql -u*** -p***
修改 root 账号密码
mysql> use mysql;
mysql> update mysql.user setauthentication_string=password('1234') where user='root' and Host ='localhost';
mysql> update user setplugin="mysql_native_password";
mysql> flush privileges;
设置远程连接
mysql> use mysql;
mysql>select host, user, authentication_string, plugin from user;
mysql> create user 'root'@'%' identified by '1234';
mysql> grant all privileges on *.* to 'root'@'%';
mysql> ALTER USER'root'@'%' IDENTIFIED WITH mysql_native_password BY '1234';
mysql> flush privileges;
mysql> quit;sudovim /etc/mysql/mysql.conf.d/mysqld.cnf
# bind-address = 127.0.0.1sudoservice mysql restart
启动 mysql
sudo /etc/init.d/mysql start
sudoservice mysql start
停止 mysql
sudo /etc/init.d/mysql stop
sudoservice mysql stop
重启 mysql
sudo/etc/init.d/mysql restart
sudoservice mysql restart