blocks|key|466533|text|您可能希望尝试使用完整的login命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|466534|mysql+-h+host+-u+root+-p+|code-block|syntax|javascript|466535|其中主机为127.0.0.1。|offset|length|style|CODE|466536|这样做只是为了确保合作的存在。|466537|使用mysql+-u+root+-p允许我进行大量的数据库搜索，但由于路径设置的原因，我拒绝创建任何数据库。|466538|entityMap^0|0|0|5|9|0|0|2|G|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@$I|V|J|W|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|Y|8|@$I|Z|J|10|K|L]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|R|$]]

You might want to try the full login command:

<pre><code>mysql -h host -u root -p 
</code></pre>

where host would be <code>127.0.0.1</code>. 

Do this just to make sure cooperation exists.

Using <code>mysql -u root -p</code> allows me to do a a lot of database searching, but refuses any database creation due to a path setting.

blocks|key|682571|text|您可能需要为MySQL数据库设置根帐户：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|682572|在终端类型中：|682573|mysqladmin+-u+root+password+'root+password+goes+here'|code-block|syntax|javascript|682574|然后调用MySQL客户端：|682575|mysql+-h+localhost+-u+root+-p|682576|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

You may need to set up a root account for your MySQL database:

In the terminal type:

<pre><code>mysqladmin -u root password 'root password goes here'
</code></pre>

And then to invoke the MySQL client:

<pre><code>mysql -h localhost -u root -p
</code></pre>

blocks|key|682654|text|首先，如果您不熟悉命令行，可以尝试在you浏览器中使用phpmyadmin。这将确保您实际创建了一个mysql数据库和一个用户名。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|682655|以下是从命令行(Bash)进行连接的方式：|682656|mysql+-h+hostname+-u+username+-p+database_name|code-block|syntax|javascript|682657|例如：|682658|fabio@crunchbang+~+$+mysql+-h+127.0.0.1+-u+fabio+-p+fabiodb|682659|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

First, if you are unfamiliar with the command line, try using phpmyadmin from your webbrowser. This will make sure you actually have a mysql database created and a username.

This is how you connect from the command line (bash):

<pre><code>mysql -h hostname -u username -p database_name
</code></pre>

For example:

<pre><code>fabio@crunchbang ~ $ mysql -h 127.0.0.1 -u fabio -p fabiodb
</code></pre>

blocks|key|466704|text|我是被另一个问题带到这里的。每当我尝试登录时，我都会收到这条消息，因为我没有正确地进行身份验证，而是以匿名用户身份登录。我的问题的解决方案是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|466705|要查看您是哪个用户以及您拥有哪些权限，请执行以下操作：|466706|select+user(),+current_user();|code-block|syntax|javascript|466707|要删除讨厌的匿名用户：|466708|drop+user+''@'localhost';|466709|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I was brought here by a different problem.
Whenever I tried to login, i got that message because instead of authenticating correctly I logged in as anonymous user. The solution to my problem was:

To see which user you are, and whose permissions you have:

<pre><code>select user(), current_user();
</code></pre>

To delete the pesky anonymous user:

<pre><code>drop user ''@'localhost';
</code></pre>

blocks|key|682776|text|@Nickparsa…你有两个问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|682777|1)。应该在bash+(也称为终端)中键入mysql+-uroot+-p，而不是在MySQL命令行中键入。要修复此错误，请键入以下命令|offset|length|style|CODE|682778|exit|code-block|syntax|javascript|682779|在MySQL命令行中。现在，您返回到bash/终端命令行。|682780|2)。你有一个语法错误：|682781|mysql+-uroot+-p;+|682782|-p前面的分号需要去掉。正确的语法是：|682783|mysql+-uroot+-p|682784|在bash命令行中键入正确的语法。如果您设置了密码，请输入密码；否则只需按Enter按钮即可。您应该会得到如下所示的响应：|682785|📷|atomic|682786|​|682787|希望这能有所帮助！|682788|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/1d9a8cb124134bd34a7223d78506ff6a.png|imageAlt^0|0|L|F|0|0|0|0|0|0|0|0|0|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1F|8|@$D|1G|E|1H|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|1I|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|1J|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1K|8|@]|9|@]|A|$]]|$1|Q|3|R|5|J|7|1L|8|@]|9|@]|A|$K|L]]|$1|S|3|T|5|6|7|1M|8|@]|9|@]|A|$]]|$1|U|3|V|5|J|7|1N|8|@]|9|@]|A|$K|L]]|$1|W|3|X|5|6|7|1O|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|10|7|1P|8|@]|9|@$D|1Q|E|1R|1|1S]]|A|$]]|$1|11|3|12|5|6|7|1T|8|@]|9|@]|A|$]]|$1|13|3|14|5|6|7|1U|8|@]|9|@]|A|$]]|$1|15|3|-4|5|6|7|1V|8|@]|9|@]|A|$]]]|16|$17|$5|18|19|1A|A|$1B|1C|1D|-4]]]]

@Nickparsa … you have 2 issues: 

1). <code>mysql -uroot -p</code> 
should be typed in bash (also known as your terminal) not in MySQL command-line. You fix this error by typing 

<pre><code>exit
</code></pre>

in your MySQL command-line. Now you are back in your bash/terminal command-line. 

2). You have a syntax error: 

<pre><code>mysql -uroot -p; 
</code></pre>

the semicolon in front of -p needs to go. The correct syntax is: 

<pre><code>mysql -uroot -p
</code></pre>

type the correct syntax in your bash commandline. Enter a password if you have one set up; else just hit the enter button. You should get a response that is similar to this:
<img src="https://i.stack.imgur.com/wZaxA.png" alt="enter image description here">

Hope this helps!

blocks|key|682818|text|根据上面的回答，我的命令是正确的，我遗漏的是在Workbench上，我们为用户提到了'Limit+Connectivity+from+Host‘，它的默认值是"%25“--把它改成"localhost”，然后它就可以正常连接了！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|682819|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 had the command correct per above answers, what I missed on was on the Workbench, where we mention 'Limit Connectivity from Host' for the user, it defaults to "%" - change this to "localhost" and it connects fine thereafter!

blocks|key|466932|text|将mysql与sudo连接，并为必要的用户提供使用权限。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|466933|sudo+mysql+-u+user;
GRANT+ALL+PRIVILEGES+ON+database_name.*+TO+'user'@'localhost';|code-block|syntax|javascript|466934|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

connect mysql with sudo &amp; gives permission for the necessary user using,
<pre><code>sudo mysql -u user;
GRANT ALL PRIVILEGES ON database_name.* TO 'user'@'localhost';
</code></pre>

I want to begin writing queries in MySQL.

<code>show grants</code> shows:

<pre><code>+--------------------------------------+
| Grants for @localhost |
+--------------------------------------+
| GRANT USAGE ON *.* TO ''@'localhost' |
+--------------------------------------+
</code></pre>

I do not have any user-id but when I want to make a user I don't have privilleges, also I don't know how to make privileges when even I don't have one user!

<pre><code>mysql&gt; CREATE USER 'parsa'@'localhost' IDENTIFIED BY 'parsa';
ERROR 1227 (42000): Access denied; you need (at least one of) the CREATE USER pr
ivilege(s) for this operation
</code></pre>

I tried to sign in as root:

<pre><code>mysql&gt; mysql -u root -p;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'mysql
 -u root -p' at line 1
mysql&gt; mysql -u root -p root;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'mysql
 -u root -p root' at line 1
</code></pre>

ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'db'

身份验证

SQL数据库

数据库

MySQL

我想开始用MySQL编写查询。show grants显示：+--------------------------------------+| Grants for @localhost                |+--------------------------------------+| GRANT USA...

问错误1044 (42000)：用户''@'localhost‘对数据库'db’的访问被拒绝
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问错误1044 (42000)：用户''@'localhost‘对数据库'db’的访问被拒绝EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问错误1044 (42000)：用户''@'localhost‘对数据库'db’的访问被拒绝
EN