Ubuntu安装Mysql

#安装mysql服务
sudo apt-get install mysql-server
#安装客户端
sudo apt install mysql-client
#安装完之后查看初始密码,应该是两个账号，随便一个都可以
sudo cat /etc/mysql/debian.cnf

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = jIre0fNDmcOKXOTi
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = jIre0fNDmcOKXOTi
socket   = /var/run/mysqld/mysqld.sock

#登录数据库
 mysql -udebian-sys-maint -pjIre0fNDmcOKXOTi
#修改root密码
use mysql;
update mysql.user set authentication_string=password('root') where user='root' and Host ='localhost';
#然后执行
update user set plugin="mysql_native_password"; 
flush privileges;
quit;
#使用root登录测试（成功）
mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.32-0ubuntu0.18.04.1 (Ubuntu)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

#登录成功后修改配置 实现远程登录
修改mysql配置文件
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
将大约在43行的 bind-address = 127.0.0.1注释掉
现在我们可以使用远程连接了
接下来我们更改mysql的编码，解决中文乱码问题
sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf
在[mysqld]下面的lc-messages-dir = /usr/share/mysql 语句后添加 character-set-server=utf8 语句