GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE,
REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'shsadmin'@'%'
IDENTIFIED BY 'f,d,r5080' WITH GRANT OPTION;GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE,
REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'shsadmin'@'localhost'
IDENTIFIED BY 'f,d,r5080' WITH GRANT OPTION;
请问%和localhost的区别
REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'shsadmin'@'%'
IDENTIFIED BY 'f,d,r5080' WITH GRANT OPTION;GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE,
REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'shsadmin'@'localhost'
IDENTIFIED BY 'f,d,r5080' WITH GRANT OPTION;
请问%和localhost的区别
localhost代表只可以本机连接
localhost是%的子集。
%代表所有的IP,LOCALHOST代表本机。
%是指主机地址不在USER表中的。
REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'shsadmin'@'%'
IDENTIFIED BY 'f,d,r5080' WITH GRANT OPTION;
已这种方式创建的数据库用户可以通过任何客户机连接数据库GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE,
REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES,
LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'shsadmin'@'localhost'
IDENTIFIED BY 'f,d,r5080' WITH GRANT OPTION;
而通过这种方式创建的用户,只能通过本机访问数据库所以我还是认为他们之间没有交集 6楼说的不少,但是我没理解