授权用户username使用password从任何主机连接到MySQL Server,并授予所有数据库所有表的全部操作权限
mysql>GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
允许用户username使用password从IP为192.168.1.9的主机连接MySQL Server,并授予所有数据库所有表的全部操作权限
mysql>GRANT ALL PRIVILEGES ON *.* TO 'username'@'192.168.1.9' IDENTIFIED BY 'password' WITH GRANT OPTION;
允许用户username使用password从IP为192.168.1.9的主机连接MySQL Server,并授予dsp数据库下的所有表的全部操作权限
mysql>GRANT ALL PRIVILEGES ON dsp.* TO 'username'@'192.168.1.9' IDENTIFIED BY 'password' WITH GRANT OPTION;
fryzunotf (2023/11/12 19:57:03)
№-id-5563-6320-2326-4598 https://bit.ly/volshebnyy_uchastok_vse_seriy