ubuntu 18.04安装mysql

1.升级apt-get

apt-get update
sudo apt-get update

2.查看是否安装mysql

netstat -tap|grep mysql

3.安装mysql

apt-get install mysql-server
apt-get install mysql-client
apt-get install libmysqlclient-dev

5.修改bind-address

vim /etc/mysql/mysql.conf.d/mysqld.cnf

找到bind-address = 127.0.0.1，行首加#注释
6.输入mysql查看是否安装成功，正常会进入
7.修改编码格式
1）输入mysql后输入status，发现有两列编码是latin1
2）修改编码

cd /etc/mysql/mysql.conf.d
vim mysqld.cnf

在basesetting下添加character-set-server=utf8

重新启动服务器，之后进入mysql再次输入status发现编码已更改
7.设置初始密码

update mysql.user set authentication_string=password('root')where user='root' ;
flush privileges;
update user set plugin='mysql_native_password' where user='root';
flush privileges;--将auth_sock改为mysql_native_password
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
flush privileges;

8.服务器开放端口后，即可通过密码远程连接