blocks|key|851445|text|转到http://localhost/phpmyadmin并单击Privileges选项卡。有一个“添加新用户”链接。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|851446|📷|atomic|851447|​|851448|entityMap|0|LINK|mutability|MUTABLE|url|http://localhost/phpmyadmin|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/4e7b7d9cb71f6b80abcf9819dbbacf6b.png|imageAlt^0|2|R|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@$A|11|B|12|1|13]]|C|$]]|$1|G|3|H|5|6|7|14|8|@]|9|@]|C|$]]|$1|I|3|-4|5|6|7|15|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]|Q|$5|R|M|S|C|$T|U|V|-4]]]]

Go to <a href="http://localhost/phpmyadmin" rel="noreferrer">http://localhost/phpmyadmin</a> and click on the Privileges tab. There is a "Add a new user" link.
<img src="https://i.stack.imgur.com/vyHAb.png" alt="alt text">

blocks|key|851793|text|​|type|unstyled|depth|inlineStyleRanges|entityRanges|data|851794|📷|atomic|offset|length|851795|851796|按enter键，因为没有密码。输入以下命令：|851797|mysql>+SET+PASSWORD+for+'root'@'localhost'+=+password('enteryourpassword');
mysql>+SET+PASSWORD+for+'root'@'127.0.0.1'+=+password('enteryourpassword');
mysql>+SET+PASSWORD+for+'root'@'::1'+=+password('enteryourpassword');|code-block|syntax|javascript|851798|就是这样，为了简单起见，我将密码保持不变。如果您想要检查用户的表，以查看信息是否已更新，只需输入如下所示的其他命令。这是检查您是否确实为所有主机输入了相同密码的好方法。|851799|851800|851801|851802|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/4df7fe3018df32b97ee3cb05423157f6.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/38e6187cf7e6d2abfece0abd04135d43.png^0|0|0|1|0|0|0|0|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|15|8|@]|9|@$E|16|F|17|1|18]]|A|$]]|$1|G|3|4|5|6|7|19|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1A|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|1B|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|1C|8|@]|9|@]|A|$]]|$1|Q|3|4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|R|3|C|5|D|7|1E|8|@]|9|@$E|1F|F|1G|1|1H]]|A|$]]|$1|S|3|4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|U|$V|$5|W|X|Y|A|$Z|10|11|-4]]|12|$5|W|X|Y|A|$Z|13|11|-4]]]]

<img src="https://i.stack.imgur.com/HHZdC.png" height="500">

Hit enter as there is no password. Enter the following commands:

<pre><code>mysql&gt; SET PASSWORD for 'root'@'localhost' = password('enteryourpassword');
mysql&gt; SET PASSWORD for 'root'@'127.0.0.1' = password('enteryourpassword');
mysql&gt; SET PASSWORD for 'root'@'::1' = password('enteryourpassword');
</code></pre>

That’s it, I keep the passwords the same to keep things simple. If you want to check the user’s table to see that the info has been updated just enter the additional commands as shown below. This is a good option to check that you have indeed entered the same password for all hosts.

<img src="https://i.stack.imgur.com/OZRDo.png" height="500">

blocks|key|1065960|text|您可以使用MySQL创建用户，如下所示：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1065961|CREATE+USER+'username'@'servername'+IDENTIFIED+BY+'password';|code-block|syntax|javascript|1065962|如果您想对特定的数据库执行此操作，只需在MySQL中编写|1065963|GRANT+ALL+PRIVILEGES+ON+database_name.*
TO+'username'@'servername'
IDENTIFIED+BY+'password';|1065964|请注意，这都是一句话，也请注意，您需要更改：|1065965|database_name+//+your+database+name
username++++++//+any+name+you+want+to+use+as+username
servername++++//+the+name+of+your+server,+for+example:+localhost
password++++++//+any+text+you+want+to+use+as+user+password|1065966|entityMap^0|5|5|0|0|K|5|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|11|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|12|8|@]|D|@]|E|$]]|$1|Q|3|R|5|H|7|13|8|@]|D|@]|E|$I|J]]|$1|S|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|T|$]]

You can create a user using <code>MySQL</code> like this:

<pre><code>CREATE USER 'username'@'servername' IDENTIFIED BY 'password';
</code></pre>

and if you want to do that for a specific database, simply you can write in the <code>MySQL</code>:

<pre><code>GRANT ALL PRIVILEGES ON database_name.*
TO 'username'@'servername'
IDENTIFIED BY 'password';
</code></pre>

Note that it's all one sentence, also note that you need to change:

<pre><code>database_name // your database name
username // any name you want to use as username
servername // the name of your server, for example: localhost
password // any text you want to use as user password
</code></pre>

blocks|key|851636|text|只需登录http://localhost/phpmyadmin/即可|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|851637|使用用户名:root|851638|密码：|851639|密码为空。然后选择users+account.And，然后选择add+user+account。|851640|entityMap|0|LINK|mutability|MUTABLE|url|http://localhost/phpmyadmin/^0|4|S|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]]]

Just login into <a href="http://localhost/phpmyadmin/" rel="nofollow noreferrer">http://localhost/phpmyadmin/</a>

with username:root

password: 

with blank password.
And then choose users account.And then choose add user account.

blocks|key|851401|text|Here+is+the+MySQL+documentation+on+creating+new+user+accounts.|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|851402|简而言之，您可以通过运行CREATE+USER语句来创建用户：|style|CODE|851403|CREATE+USER+"<username>"+IDENTIFIED+BY+"<password>";|code-block|syntax|javascript|851404|一旦创建了用户，您就可以授予他使用GRANT+statement执行操作的权限。|851405|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.1/en/adding-users.html|1|http://dev.mysql.com/doc/refman/5.1/en/create-user.html|2|http://dev.mysql.com/doc/refman/5.1/en/grant.html^0|0|1Q|0|0|C|B|C|B|1|0|0|H|5|H|F|2|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@$A|11|B|12|1|13]]|C|$]]|$1|D|3|E|5|6|7|14|8|@$A|15|B|16|F|G]]|9|@$A|17|B|18|1|19]]|C|$]]|$1|H|3|I|5|J|7|1A|8|@]|9|@]|C|$K|L]]|$1|M|3|N|5|6|7|1B|8|@$A|1C|B|1D|F|G]]|9|@$A|1E|B|1F|1|1G]]|C|$]]|$1|O|3|-4|5|6|7|1H|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]|W|$5|R|S|T|C|$U|X]]|Y|$5|R|S|T|C|$U|Z]]]]

<a href="http://dev.mysql.com/doc/refman/5.1/en/adding-users.html" rel="nofollow">Here is the MySQL documentation on creating new user accounts.</a>

In short, you create a user by running a <a href="http://dev.mysql.com/doc/refman/5.1/en/create-user.html" rel="nofollow"><code>CREATE USER</code></a> statement:

<pre><code>CREATE USER "&lt;username&gt;" IDENTIFIED BY "&lt;password&gt;";
</code></pre>

Once the user is created, you give him access to do things by using the <a href="http://dev.mysql.com/doc/refman/5.1/en/grant.html" rel="nofollow"><code>GRANT</code> statement</a>.

blocks|key|851508|text|使用http://localhost/sqlbuddy+-->+users接口。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|851509|您可以在本地主机主页的Your+Aliases部分找到它。|851510|entityMap^0|2|Z|0|B|C|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

Use <code>http://localhost/sqlbuddy --&gt; users</code> interface.

You can find it at the localhost main page at <code>Your Aliases</code> section.

blocks|key|851580|text|转到phpmyadmin并单击左侧栏中已经创建的数据库。然后，您可以在顶部看到一个特权选项。在那里，您可以添加新用户。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|851581|如果您还没有任何数据库，请转到phpmyadmin并选择databases，只需在字段中提供数据库名称并按go即可创建一个数据库。|851582|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Go to phpmyadmin and click on the database you have already created form the left side bar. Then you can see a privilege option at the top.. There you can add a new user.. 

If you are not having any database yet go to phpmyadmin and select databases and create a database by simply giving database name in the filed and press go.

blocks|key|851935|text|Darkcoder的解决方案是唯一一个让它为我工作的方案。(WAMP服务器2.5，包括mysql+5.6.17。%2B客户端为Workbench+6.3)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|851936|为了让任何其他用户(不是默认根用户)能够在Workbench中看到模式，我必须为每个其他用户创建3次。|851937|Once+for+host+=+%25
Once+for+host+=+localhost
Once+for+host+=+::1|code-block|syntax|javascript|851938|此外，我注意到，为了使授予的权限真正有效(全局的和每个数据库的权限)，我必须确保所有3种不同的user%2Bhost组合的所有权限完全相同。|851939|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Darkcoder's solution is the only one that made it work for me. (WAMP server 2.5, which includes mysql 5.6.17. + client is Workbench 6.3)
In order for any additional user (other than the default root) to be able to see the schemas in Workbench, I had to create 3 times each additional user.
<pre><code>Once for host = %
Once for host = localhost
Once for host = ::1
</code></pre>
Also, I noticed that in order for the granted privileges to really work (global and per database ones), I had to make sure all privileges were exactly the same for all the 3 different user+host combinations.

blocks|key|1066358|text|我试图用用户名"admin“登录，它允许我登录，但没有任何特权，我不知道这一点。然后我尝试使用用户名"root"，然后我有了权限，所以我将权限更改为其他用户。这两个用户名都不使用密码，因此我将其保留为空。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1066359|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I was trying to log in with the username &quot;admin&quot; and it let me got in, but without any privileges and I did not know that. Then I tried with the username &quot;root&quot;, and then I had privileges so I changed the privileges to the other users. Both usernames do not use passwords, so I leave them blank.

I have wamp installed , I want to know how to create username and password in mysql.

wamp server mysql user id and password

我已经安装了wamp，我想知道如何在mysql中创建用户名和密码。

问wamp服务器mysql用户id和密码
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问wamp服务器mysql用户id和密码EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问wamp服务器mysql用户id和密码
EN