1、sudo apt install mysql-server mysql-client
2、查看初始账号密码:sudo cat /etc/mysql/debian.cnf
3、操作mysql:
启动mysql:
方式一:sudo /etc/init.d/mysql start
方式二:sudo service mysql start
停止mysql:
方式一:sudo /etc/init.d/mysql stop
方式二:sudo service mysql stop
重启mysql:
方式一:sudo/etc/init.d/mysql restart
方式二:sudo service mysql restart
4、如果需要修改密码或者远程连接需要做以下操作
去mysqld.cnf中注释掉:限制只能本地连接
#bind-address = 127.0.0.1
#mysqlx-bind-address = 127.0.0.1
mysql -u*** -p***
use mysql;
# %表示允许所有地址连接
update user set host="%" where user ="root";
# 密码方式连接
ALTER user "root"@"%" IDENTIFIED WITH mysql_native_password BY "12345";
flush privileges;
quit;
mysql -uroot -p123456