mysql链接用户添加

mysql本地链接用户添加

$ GRANT ALL PRIVILEGES ON *.* TO 'shopping'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;$ FLUSH PRIVILEGES;

mysql外部链接用户添加

$ GRANT ALL PRIVILEGES ON shopping_db.* TO shopping@"192.168.10.%" IDENTIFIED BY 'password' WITH GRANT OPTION;

$ FLUSH PRIVILEGES;