mysql日常运维操作

如何让root支持远程访问

# 检查用户是否存在
    SELECT user, host FROM mysql.user WHERE user = 'root';

# mysql5.7系列，允许root用户远程登陆
    # %  表示所有ip地址
    grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;
    FLUSH PRIVILEGES;

# mysql8.0系列，允许root用户远程登陆
    CREATE USER 'root'@'%' IDENTIFIED BY 'password';
    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
    FLUSH PRIVILEGES;