除了通过 GRANT ALL 实际授予用户权限之外，您还需要向 Plesk 数据库中的 db_users 表添加一条记录。 使用shell查看所有数据库，我发现plesk数据库名为psa。 从 accounts 查找 accountid 并从 data_bases 查找 dbid
INSERT into db_users VALUES('','username','accountid','dbid');
In addition to actually granting the user permissions via GRANT ALL, you'll need to add a record to the db_users table in the Plesk database. Using shell to see all databases, I found the plesk database was named psa. Lookup accountid from accounts and dbid from data_bases
INSERT into db_users VALUES('','username','accountid','dbid');
Update 10 Jan 2014 Plesk 11.5 has such functional from the box:
This may be annoying but it is for better security. Universal Username and Login might be easier to remeber but not secure. If your system admin has done then it is done for reason.
Please usually allows you to create username and databases seperately. So you can use the same username for multiple batabases.
发布评论
评论（3）
除了通过 GRANT ALL 实际授予用户权限之外，您还需要向 Plesk 数据库中的
db_users表添加一条记录。 使用shell查看所有数据库，我发现plesk数据库名为psa。 从accounts查找 accountid 并从data_bases查找 dbidIn addition to actually granting the user permissions via GRANT ALL, you'll need to add a record to the
db_userstable in the Plesk database. Using shell to see all databases, I found the plesk database was namedpsa. Lookup accountid fromaccountsand dbid fromdata_bases2014 年 1 月 10 日更新 Plesk 11.5 具有以下功能：
这可能很烦人，但这是为了更好的安全性。 通用用户名和登录名可能更容易记住，但不安全。 如果您的系统管理员已经这样做了，那么它是有原因的。
请通常允许您单独创建用户名和数据库。 所以你可以对多个batbase使用相同的用户名。
Update 10 Jan 2014 Plesk 11.5 has such functional from the box:
This may be annoying but it is for better security. Universal Username and Login might be easier to remeber but not secure. If your system admin has done then it is done for reason.
Please usually allows you to create username and databases seperately. So you can use the same username for multiple batabases.
使用 GRANT 语法，您可以授予单个 MySQL 用户帐户如果您愿意，可以使用相同的密码访问任意数量的数据库。
如果您想创建一个始终可以访问所有数据库的用户，非常类似于 root 用户，您可以使用如下语法：
不建议在项目之间共享相同的用户名和密码，但您绝对可以这样做。
Using GRANT syntax, you can give a single MySQL user account access to as many databases as you want, with the same password if you'd like.
If you wanted to create a user that always has access to all the databases, very much like the root user, you can use syntax like this:
It's not recommended to share the same username and password across projects, but you can definitely do it.