Ubuntu 安装 MySQL

最新推荐文章于 2024-09-19 19:11:44 发布

沉迷学习w

最新推荐文章于 2024-09-19 19:11:44 发布

阅读量186

点赞数

分类专栏： Linux 相关文章标签： mysql ubuntu 数据库

本文链接：https://blog.csdn.net/daiyoko/article/details/120209921

版权

Linux 相关专栏收录该内容

20 篇文章 1 订阅

订阅专栏

本文档详细介绍了如何在Linux系统中安装MySQL服务器，并通过安全安装脚本进行配置。接着，创建了名为'invent_dba'的新用户，赋予其对'invent'数据库的全部权限。新用户成功登录并展示数据库列表，确保了权限设置生效。

摘要由CSDN通过智能技术生成

安装 MySQL

sudo apt update
sudo apt upgrade
sudo apt install mysql-server

装完后，预设 root 没有 password
要用 sudo mysql 登陆
注: 经过 auth_socket 验证

然后，先做一些基本配置

sudo mysql_secure_installation

然后，建立数据库和新用户

sudo mysql
create user 'invent_dba'@'%' identified by 'invent_dba_password';
create database invent;
grant all on invent.* to 'invent_dba'@'%';
select user, host from user;

mysql> select user, host from user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| invent_dba       | %         |
| debian-sys-maint | localhost |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+
6 rows in set (0.00 sec)

flush privileges;

然后，新用户登陆一下试试

$ mysql -u invent_dba -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.0.26-0ubuntu0.20.04.2 (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 |
| invent             |
+--------------------+
2 rows in set (0.00 sec)