MySQL 如何在phpmyadmin中添加用户
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/32097208/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to add user in phpmyadmin
提问by tayyab ahmed
I want to know how to add user in phpmyadmin , I have done some research but didnot find the proper answer. I am unable to find the privilege section in phpmyadmin so that i can add a username and password . I am working on hosting and i cant see the privilege section in my phpmyadmin main's page.
我想知道如何在 phpmyadmin 中添加用户,我做了一些研究,但没有找到正确的答案。我无法在 phpmyadmin 中找到权限部分,因此我可以添加用户名和密码。我正在托管,但在我的 phpmyadmin 主页中看不到权限部分。
Sorry for the inconvenience my english is weak
很抱歉给您带来不便,我的英语很弱
采纳答案by Parth
回答by Digital Chris
From https://wiki.phpmyadmin.net/pma/user_management:
从https://wiki.phpmyadmin.net/pma/user_management:
To create a new user, click the Add a new user link near the bottom of the Privileges page (you must be a "superuser", e.g., user "root").
要创建新用户,请单击“权限”页面底部附近的“添加新用户”链接(您必须是“超级用户”,例如用户“root”)。
(emphasis mine)
(强调我的)
回答by Y.Lu
I was successful in adding user using the "User accounts" tab in the main view (as posted by Kadaiser). All privileges are global. It does not provide a way to grant privileges on any specific database. Also, one must specify the host name of the user for database connection to work (i.e. so and so@% presented connection problems).
我成功地使用主视图中的“用户帐户”选项卡添加了用户(由 Kadaiser 发布)。所有权限都是全局的。它不提供授予任何特定数据库权限的方法。此外,必须指定用户的主机名才能使数据库连接正常工作(即某某@% 出现连接问题)。
回答by Kadaiser
phpMyAdmin does handle user management, The fourth tab in the main view, "User accounts". In there, you have the section, "New", there you can add new users.
phpMyAdmin 确实处理用户管理,主视图中的第四个选项卡,“用户帐户”。在那里,您有“新建”部分,您可以在那里添加新用户。