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>