**
打开终端
**
输入密码切换到root身份
sudo -i
更新apt源
apt-get update
安装mysql
apt-get install mysql-server
检查mysql的状态
systemctl status mysql.service
mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2021-12-20 18:15:45 CST; 38s ago
Process: 255962 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 255970 (mysqld)
Status: "Server is operational"
Tasks: 38 (limit: 4588)
Memory: 352.8M
CPU: 2.455s
CGroup: /system.slice/mysql.service
└─255970 /usr/sbin/mysqld
12月 20 18:15:43 lhdpc systemd[1]: Starting MySQL Community Server...
12月 20 18:15:45 lhdpc systemd[1]: Started MySQL Community Server.
状态已是运行中
说明:安装完成后mysql的配置文件位于:
/etc/mysql/mysql.conf.d/mysqld.cnf
mysql初始化
mysql_secure_installation
会有一系列的问题回答:
VALIDATE PASSWORD COMPONENT can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD component?
Press y|Y for Yes, any other key for No: n
是否做密码的强度校验?选n,生产环境中建议设置一个高强度的密码
Please set the password for root here.
New password:
Re-enter new password:
在此处输入两次mysql的root账号密码
Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y
Success.
此处输入Y,用来删除匿名用户
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : N
... skipping.
是否禁止root账号远程连接,选n,允许远程连接
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : n
是否删除test数据库,选n,不删,留着
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y
Success.
是否重新加载权限表,选Y,加载
测试效果:用刚才设置的root密码登录
mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.27-0ubuntu0.21.10.1 (Ubuntu)
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
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> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)