1.sudo apt-get update
2.sudo apt-get install mysql-server mysql-client
3.mysqladmin --version
可以看到
表示安装成功
或者输入
systemctl status mysql.service
看到
4.mysql -u root -p然后输入安装界面设置的密码
不输入密码登录不行。输入了123456以为系统会帮我默认用这个密码重置,结果还是不行
5.1切换到root用户,猜测密码默认是root,然后真的登录成功了,其实此时还不需要密码。
5.2尝试使用sudo权限操作,输入sudo mysql -u root
可以进入mysql执行窗口 ,然后执行8.3
6启动 mysql:
service mysql start
7.mysqladmin -p -u root version
看到mysqladmin Ver 8.42 Distrib 5.7.22, for Linux on x86_64
Copyright (c) 2000, 2018, 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.
Server version 5.7.22-0ubuntu0.16.04.1
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 28 min 15 sec
此时还不能远程登录
8.先切换库,查看user表数据
select host,user,authentication_string from user;
然后执行
update user set host = '%' where user = 'root';
flush privileges;
还是不行哈,继续尝试办法
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;
mysql服务器本地必须使用密码登录可以登录了,但是还是不能远程登录。
按下述方式修改mysqld.cnf,然后重启mysql
root@VM-8-10-ubuntu:/home/lighthouse# find / -name "mysqld.cnf"
/etc/mysql/mysql.conf.d/mysqld.cnf
root@VM-8-10-ubuntu:/home/lighthouse# vi /etc/mysql/mysql.conf.d/mysqld.cnf
root@VM-8-10-ubuntu:/home/lighthouse# service mysql restart
root@VM-8-10-ubuntu:/home/lighthouse#
然后远程可以登录这个mysql了。