Ubuntu 20 安装Mysql 亲测版（过程详细）！_ubuntu20 安装mysql rpm-优快云博客

本文链接：https://blog.youkuaiyun.com/cg_ssh/article/details/118614002

该博客详细记录了在Ubuntu系统上执行MySQL的安装、升级、安全配置以及远程访问设置的过程。通过`sudo apt-get`命令安装MySQL服务器，并进行了初始化设置，确保了root用户的远程连接能力。此外，还展示了查看数据库、选择数据库、更新用户主机名以及检查字符集等数据库管理操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ufo@UPC:~$ sudo apt-get update

ufo@UPC:~$ sudo apt-get upgrade

ufo@UPC:~$ sudo apt-get install mysql-server

ufo@UPC:~$ sudo mysql_secure_installation

ufo@UPC:~$ systemctl status mysql.service

ufo@UPC:~$ sudo mysql -uroot -proot

mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.25-0ubuntu0.20.04.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.01 sec)

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> select host,user,plugin from user;
+-----------+------------------+-----------------------+
| host      | user             | plugin                |
+-----------+------------------+-----------------------+
| localhost | debian-sys-maint | caching_sha2_password |
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session    | caching_sha2_password |
| localhost | mysql.sys        | caching_sha2_password |
| localhost | root             | auth_socket           |
+-----------+------------------+-----------------------+
5 rows in set (0.00 sec)

mysql> update user set host='%' where user='root'; 
Query OK, 1 row affected (0.08 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> show variables like 'character%'; 
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8mb4                    |
| character_set_connection | utf8mb4                    |
| character_set_database   | utf8mb4                    |
| character_set_filesystem | binary                     |
| character_set_results    | utf8mb4                    |
| character_set_server     | utf8mb4                    |
| character_set_system     | utf8mb3                    |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.02 sec)

mysql> quit
Bye