授予*數(shù)據(jù)庫(kù)上的所有*特權(quán)我創(chuàng)建了數(shù)據(jù)庫(kù)，例如“mydb”。CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_bin;CREATE USER 'myuser'@'%' IDENTIFIED BY PASSWORD '*HASH';GRANT ALL ON mydb.* TO 'myuser'@'%';GRANT ALL ON mydb TO 'myuser'@'%';GRANT CREATE ON mydb TO 'myuser'@'%';FLUSH PRIVILEGES;現(xiàn)在我可以從任何地方登錄到數(shù)據(jù)庫(kù)，但不能創(chuàng)建表。如何授予該數(shù)據(jù)庫(kù)和(將來(lái)的)表的所有權(quán)限。我無(wú)法在‘mydb’數(shù)據(jù)庫(kù)中創(chuàng)建表。我總是得到：CREATE TABLE t (c CHAR(20) CHARACTER SET utf8 COLLATE utf8_bin);ERROR 1142 (42000): CREATE command denied to user 'myuser'@'...' for table 't'
授予*數(shù)據(jù)庫(kù)上的所有*特權(quán)
喵喵時(shí)光機(jī)
2019-07-04 18:30:44
