Debian 10 安装MySQL 8.0
添加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。
~# apt update
~# apt install mysql-server
在安装过程中,将要求您为MySQL设置数据库根用户密码,建议输入安全且强度高的密码,输入两遍后确认。
了解MySQL使用的基于SHA256的密码方法的新身份验证系统,然后单击“确定”。
设置MySQL密码验证
~# 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>
本作品采用 知识共享署名-相同方式共享 4.0 国际许可协议 进行许可。
评论已关闭