数据库报错2058
本地连接修改方式
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
远程连接修改方式
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
给数据库创建新用户
create user 用户名 identified by '密码';
给用户分配权限
#授予通过网络方式登录的tom用户,对所有库所有表的全部权限,密码设为abc123.
grant all privileges on *.* to tom@'%' identified by 'abc123';
#给tom用户使用本地命令行方式,授予atguigudb这个库下的所有表的插删改查的权限。
grant select,insert,delete,update on atguigudb.* to tom@localhost identified by 'abc123';
如果报错: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'abc123'' at line 1
原因:版本问题,MySQL8.0以上版本并不适用这种命令来开启远程访问权限
grant all privileges on test.* to 'tom'@'%'; 修改权限 all privileges所有权限,按要求替换为固定权限即可
mysql8.0中查看隔离级别的命令:
select @@global.transaction_isolation,@@transaction_isolation;
修改MySQL隔离级别命令:
修改全局隔离级别为读提交:
SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
修改会话隔离级别
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;