Debian 10 安装MySQL 8.0

By | 2020年12月8日

添加MySQL软件存储库MySQL APT

~# wget https://dev.mysql.com/get/mysql-apt-config_0.8.13-1_all.deb
~# dpkg -i mysql-apt-config_0.8.13-1_all.deb //在软件包安装过程中,将提示您配置MySQL APT存储库,以选择MySQL服务器的版本以及要安装的其他组件。保留默认选项以安装最新版本。完成后,点击Enter或转到OK并点击Enter。
rS8PsO.png
~# apt update
~# apt install mysql-server

在安装过程中,将要求您为MySQL设置数据库根用户密码,建议输入安全且强度高的密码,输入两遍后确认。

rS8My8.png

了解MySQL使用基于SHA256的密码方法的新身份验证系统,然后单击“确定”。

rS8JFs.png

设置MySQL密码验证

rS8US0.png
~# systemctl status mysql //查看MySQL运行状态
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since Thu 2020-12-08 12:56:12 UTC; 3s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 2673 ExecStartPre=/usr/share/mysql-8.0/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 2709 (mysqld)
   Status: "Server is operational"
    Tasks: 39 (limit: 4915)
   Memory: 378.4M
   CGroup: /system.slice/mysql.service
           └─2709 /usr/sbin/mysqld

Dec 08 12:56:12 tecmint systemd[1]: Starting MySQL Community Server...
Dec 08 12:56:12 tecmint systemd[1]: Started MySQL Community Server.

常用systemctl命令

~# systemctl start mysql  //启动
~# systemctl restart mysql //重启
~# systemctl stop mysql //停止
~# systemctl reload mysql //重载

测试访问mysql shell

~# mysql -uroot -p //root访问mysql shell
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5268
Server version: 8.0.22 MySQL Community Server - GPL

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>