mysql添加用户授予root权限和ssl连接

mysql添加用户，授予root权限

CREATE USER 'lddTest1'@'%' IDENTIFIED BY 'ldd234';

grant all privileges on *.* to 'baihu'@'%' with grant option

flush privileges;

修改用户名

update user set user='test' where user=‘root’;

FLUSH PRIVILEGES;

删除用户

drop user 'test1'@'localhost';

开启mysql 的ssl连接

show variables like '%ssl%';

SELECT ssl_type, user From mysql.user;

开启

ALTER USER 'imooc'@'%' REQUIRE SSL;

FLUSH PRIVILEGES;

解除

update mysql.user set ssl_type='' where user='root';

FLUSH PRIVILEGES;