MySQL8远程连接
分类：Database， 发布于 2021-07-21 16:13:25，评论(0)，浏览(998)
一、注释my.ini中的bind
二、添加远程连接用户
CREATE USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY 'test123'; GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' WITH GRANT OPTION; flush privileges;
一、注释my.ini中的bind
二、添加远程连接用户
CREATE USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY 'test123'; GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' WITH GRANT OPTION; flush privileges;
修改mysql数据库user表：
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';