安装5.7.17后远程
1. 首先环境变量中配置mysql的bin目录
2. cmd账号密码启动输入一下命令:
mysql -u root -p
use mysql;
GRANT ALL PRIVILEGES ON dk.* TO ‘myuser‘@‘%‘ IDENTIFIED BY ‘123456‘ WITH GRANT OPTION;
update user set host = ‘%‘ where user = ‘root‘;
FLUSH PRIVILEGES;
3.datagrip进行连接数据库中需要设置时区:
set global time_zone = ‘+8:00‘;