issues
search
hrh47
/
blog
0
stars
0
forks
source link
如果開放某個 database 的權限給某個使用者?
#2
Open
hrh47
opened
5 years ago
hrh47
commented
5 years ago
GRANT ALL PRIVILEGES ON database.table TO 'user'@'localhost';
某個 database 底下的所有 table:
GRANT ALL PRIVILEGES ON database.* TO 'user'@'localhost';
所有 database 下的所有 table:
GRANT ALL PRIVILEGES ON
.
TO 'user'@'localhost';
hrh47
commented
5 years ago
https://kyup.com/tutorials/create-new-user-grant-permissions-mysql/