MySQL常用配置记录MySQL常用操作配置，用户创建、授权、事务隔离级别、远程登录、sql_mode........等

查看事务隔离级别

select @@tx_isolation;  -- mysql5

select @@transaction_isolation; --mysql8

sql_mode

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION


临时配置 sql_mode

set @@global.sql_mode=(select replace(@@global.sql_mode,'ONLY_FULL_GROUP_BY,',''));

set @@global.sql_mode=(select replace(@@global.sql_mode,'NO_ZERO_IN_DATE,NO_ZERO_DATE',''));

mysql5.7+ group by 查询报错 this is incompatible with sql_mode=only_full_group_by

在my.ini配置文件：

[mysqld] 后面修改或加上 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

远程登录

mysql -h ip -u root -p -P 3306

创建用户、授权

blog.csdn.net/weixin_4562…

-- 创建用户

create user 'rlfz'@'%' identified by 'T7H^Hpn2dzJx';

-- 查询用户权限
select * from mysql.user;

-- 授予某用户全部权限

grant all on *.* to 用户名@"%" identified by "密码" with grant option;