瀏覽單個文章
isnowcloud
Regular Member
 

加入日期: Feb 2015
文章: 65
[請教]mysql可否讓一個user搭配不同密碼存取個別的database

例如下面這樣
三個database(test1/test2/test3)都授權給同一個用戶account在localhost下使用,只是個別授權的認證密碼不同
請問這樣會不會有什麼其他問題?

mysql>GRANT ALL PRIVILEGES ON test1.* TO account@localhost IDENTIFIED BY "password1";
mysql>GRANT ALL PRIVILEGES ON test2.* TO account@localhost IDENTIFIED BY "password2";
mysql>GRANT ALL PRIVILEGES ON test3.* TO account@localhost IDENTIFIED BY "password3";
     
      
舊 2015-07-19, 05:27 PM #1
回應時引用此文章
isnowcloud離線中