ubuntu18.04 安装mysql

$ sudo dpkg -l | grep mysql

$ sudo apt install mysql-server

$ netstat -tap | grep mysql
$ dpkg -l | grep mysql

$ systemctl status mysql

$ sudo cat /etc/mysql/debian.cnf

$ mysql -u debian-sys-maint -p

>> use mysql;
>> update mysql.user set authentication_string=password(‘your_new_pasword‘) where user=‘root‘ and Host =‘localhost‘;
>> update user set plugin="mysql_native_password";
>> flush privileges;

$ sudo service mysql restart

$ mysql -uroot -p

$ sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf

>> grant all on *.* to root@‘%‘ identified by ‘connect_pasword‘ with grant option;

>> flush privileges;