mysql8 创建指定用户数据库

普通小程序员

已于 2023-09-12 09:01:31 修改

阅读量168

点赞数

文章标签：数据库 mysql

于 2023-09-12 09:01:05 首次发布

本文链接：https://blog.csdn.net/qq_41611829/article/details/132823304

版权

set global read_only=0;
set global optimizer_switch='derived_merge=off'; 
create user 'jeesite'@'%' identified by 'jeesite';
create database jeesite DEFAULT CHARSET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci';   

grant all privileges on jeesite.* to 'jeesite'@'%' identified by 'jeesite';
上述命令报错，则用GRANT ALL PRIVILEGES ON jeesite.* TO 'jeesite'@'%';


flush privileges;

[root@VM-4-8-centos etc]# vim my.cnf
[mysql]
default-character-set=utf8mb4
[client]
port=3307
socket=/var/lib/mysql/mysql.sock

[mysqld]
#skip-grant-tables
port=3307
#server-id=3306
user=mysql
general_log = 1
general_log_file= /var/log/mysql/mysql.log
socket=/var/lib/mysql/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
log-bin=/usr/local/mysql/data/mysql-bin
innodb_data_home_dir=/usr/local/mysql/data
innodb_log_group_home_dir=/usr/local/mysql/data/
character-set-server=utf8mb4
lower_case_table_names=1
autocommit=1
default_authentication_plugin=mysql_native_password
symbolic-links=0
max_connections=100
max_connect_errors=10
default-storage-engine=INNODB
#sql_mode=SONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
# Disabling symbolic-links is recommended to prevent assorted security risks