Ubuntu上安装与配置MySQL‌

‌Ubuntu上安装与配置MySQL‌

安装MySQL‌：

更新系统：

sudo apt-get update

安装MySQL服务器：

sudo apt-get install mysql-server mysql-client

设置MySQL root用户密码

启动与关闭MySQL服务‌：

启动：sudo service mysql start
关闭：sudo service mysql stop
重启：sudo service mysql restart

配置MySQL以支持中文‌：

编辑配置文件：

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

添加：character_set_server=utf8
修改：bind-address = 0.0.0.0

远程连接授权‌：

登录MySQL：

mysql -u root -p

创建用户并授权‌：‌
使用CREATE USER语句创建用户，‌如

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

使用GRANT语句授权，‌如

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;

刷新权限‌：‌执

FLUSH PRIVILEGES;

来刷新权限，‌使更改生效。‌

bjdsh@ubuntu:~$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.0.39-0ubuntu0.24.04.2 (Ubuntu)

Copyright (c) 2000, 2024, 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> create database mg_db default charset=utf8;
Query OK, 1 row affected, 1 warning (0.03 sec)

mysql> CREATE USER 'bjdsh'@'%' IDENTIFIED BY '123123';
Query OK, 0 rows affected (0.03 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'bjdsh'@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.02 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql>