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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-31 21:13:52  来源:igfitidea点击:

How to add user in phpmyadmin

mysqlphpmyadmin

提问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

phpMyAdmin does not handle user management, rather it passes the username and password on to MySQL. createmysql User.

phpMyAdmin 不处理用户管理,而是将用户名和密码传递给 MySQL。创建mysql 用户。

and If you mean, users controlling their own database, go here.

如果您的意思是用户控制自己的数据库,请转到此处

回答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 Lucia

Select the database on the left, then:

选择左侧的数据库,然后:

enter image description here

在此处输入图片说明

回答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 确实处理用户管理,主视图中的第四个选项卡,“用户帐户”。在那里,您有“新建”部分,您可以在那里添加新用户。