参考 https://www.jb51.net/article/156476.htm https://blog.csdn.net/qq_39667424/article/details/105879549 https://mirrors.cnnic.cn/help/mysql/

安装Mysql

执行apt安装命令

  1. sudo apt-get install mysql-server
  2. sudo apt-get install mysql-client

安装成功
mysql-install.png

一般情况下，mysql命令相关的程序都安装在/bin目录下，进入/bin目录后，输入mysql即可登录mysql
image.png

配置Mysql

默认情况下，mysql管理用户root数据库密码为空，需要设置密码，按一下步骤执行命令

  1. mysql
  2. mysql> select user, plugin from mysql.user;
  3. +------------------+-----------------------+
  4. | user | plugin |
  5. +------------------+-----------------------+
  6. | root | auth_socket |
  7. | mysql.session | mysql_native_password |
  8. | mysql.sys | mysql_native_password |
  9. | debian-sys-maint | mysql_native_password |
  10. +------------------+-----------------------+
  11. 4 rows in set (0.00 sec)
  12. mysql> update mysql.user set authentication_string=PASSWORD('123456'), plugin='mysql_native_password' where user='root';
  13. mysql> flush privileges;
  14. mysql> exit
  15. Bye

远程链接

  1. # 修改配置文件，注释掉bind-address = 127.0.0.1
  2. $ sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
  4. # 保存退出，然后进入mysql服务，执行授权命令：
  5. $ mysql -uroot -p
  7. mysql> grant all on *.* to root@'%' identified by '123456' with grant option;
  8. Query OK, 0 rows affected, 1 warning (0.00 sec)
  10. mysql> flush privileges;
  11. Query OK, 0 rows affected (0.00 sec)
  13. mysql> exit
  14. Bye
  15. $ sudo /etc/init.d/mysql restart