blocks|key|713432|text|您可以使用--skip-grant-tables运行服务器，然后以超级用户身份(或使用sudo)在不使用密码的情况下登录，从而重置超级用户密码：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|713433|#+service+mysql+stop
#+mysqld_safe+--skip-grant-tables+&
$+mysql+-u+root|code-block|syntax|javascript|713434|mysql>+use+mysql;
mysql>+update+user+set+authentication_string=PASSWORD("YOUR-NEW-ROOT-PASSWORD")+where+User='root';
mysql>+flush+privileges;
mysql>+quit|713435|#+service+mysql+stop
#+service+mysql+start
$+mysql+-u+root+-p|713436|现在，您应该能够以root用户身份使用新密码登录。|713437|也可以在重置密码的用户的/home/$USER/.mysql_history或/root/.mysql_history中找到重置密码的查询，但上面的方法始终有效。|713438|注意:在MySQL+5.7之前，该列称为password而不是authentication_string。将上面的行替换为|713439|mysql>+update+user+set+password=PASSWORD("YOUR-NEW-ROOT-PASSWORD")+where+User='root';|713440|entityMap^0|5|J|0|0|0|0|0|C|Q|13|K|0|K|8|V|L|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|11|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|H|7|12|8|@]|D|@]|E|$I|J]]|$1|M|3|N|5|H|7|13|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|14|8|@]|D|@]|E|$]]|$1|Q|3|R|5|6|7|15|8|@$9|16|A|17|B|C]|$9|18|A|19|B|C]]|D|@]|E|$]]|$1|S|3|T|5|6|7|1A|8|@$9|1B|A|1C|B|C]|$9|1D|A|1E|B|C]]|D|@]|E|$]]|$1|U|3|V|5|H|7|1F|8|@]|D|@]|E|$I|J]]|$1|W|3|-4|5|6|7|1G|8|@]|D|@]|E|$]]]|X|$]]

You can reset the root password by running the server with <code>--skip-grant-tables</code> and logging in without a password by running the following as root (or with sudo):

<pre class="lang-none prettyprint-override"><code># service mysql stop
# mysqld_safe --skip-grant-tables &amp;
$ mysql -u root
</code></pre>

<pre class="lang-sql prettyprint-override"><code>mysql&gt; use mysql;
mysql&gt; update user set authentication_string=PASSWORD("YOUR-NEW-ROOT-PASSWORD") where User='root';
mysql&gt; flush privileges;
mysql&gt; quit
</code></pre>

<pre class="lang-none prettyprint-override"><code># service mysql stop
# service mysql start
$ mysql -u root -p
</code></pre>

Now you should be able to login as root with your new password.

It is also possible to find the query that reset the password in <code>/home/$USER/.mysql_history</code> or <code>/root/.mysql_history</code> of the user who reset the password, but the above will always work.

Note: prior to MySQL 5.7 the column was called <code>password</code> instead of <code>authentication_string</code>. Replace the line above with

<pre class="lang-sql prettyprint-override"><code>mysql&gt; update user set password=PASSWORD("YOUR-NEW-ROOT-PASSWORD") where User='root';
</code></pre>

blocks|key|713548|text|我意识到这是一个旧的线程，但我想我应该用我的结果更新它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|713549|亚历克斯，听起来你是通过元软件包‘MySQL+-mysql’来安装服务器的。这将通过引用安装最新的包(在我的示例中为mysql-server-5.5)。我和您一样，在设置时没有像我预期的那样提示输入MySQL密码。我想有两个答案：|713550|解决方案#1:按全名安装MySQL：|713551|$+sudo+apt-get+install+mysql-server-5.5|code-block|syntax|javascript|713552|或|713553|解决方案#2:重新配置包...|713554|$+sudo+dpkg-reconfigure+mysql-server-5.5|713555|您必须指定完整的程序包名称。使用元包'mysql-server‘并没有得到我想要的结果。我希望这对某些人有帮助:)|713556|参考：https://help.ubuntu.com/12.04/serverguide/mysql.html|offset|length|713557|entityMap|0|LINK|mutability|MUTABLE|url|https://help.ubuntu.com/12.04/serverguide/mysql.html^0|0|0|0|0|0|0|0|0|3|1G|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|16|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|17|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|18|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|19|8|@]|9|@]|A|$]]|$1|O|3|P|5|H|7|1A|8|@]|9|@]|A|$I|J]]|$1|Q|3|R|5|6|7|1B|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1C|8|@]|9|@$U|1D|V|1E|1|1F]]|A|$]]|$1|W|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]]]

I realize that this is an old thread, but I thought I'd update it with my results.

Alex, it sounds like you installed MySQL server via the meta-package 'mysql-server'. This installs the latest package by reference (in my case, mysql-server-5.5). I, like you, was not prompted for a MySQL password upon setup as I had expected. I suppose there are two answers:

Solution #1: install MySQL by it's full name:

<pre><code>$ sudo apt-get install mysql-server-5.5
</code></pre>

Or

Solution #2: reconfigure the package...

<pre><code>$ sudo dpkg-reconfigure mysql-server-5.5
</code></pre>

You must specific the full package name. Using the meta-package 'mysql-server' did not have the desired result for me. I hope this helps someone :)

Reference: <a href="https://help.ubuntu.com/12.04/serverguide/mysql.html" rel="noreferrer">https://help.ubuntu.com/12.04/serverguide/mysql.html</a>

blocks|key|929595|text|Ubuntu14.04上的MySQL+5.5需要与推荐的here稍有不同的命令。简而言之：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|929596|sudo+/etc/init.d/mysql+stop
sudo+/usr/sbin/mysqld+--skip-grant-tables+--skip-networking+&
mysql+-u+root|code-block|syntax|javascript|929597|然后从MySQL提示符|929598|FLUSH+PRIVILEGES;
SET+PASSWORD+FOR+root@'localhost'+=+PASSWORD('password');
UPDATE+mysql.user+SET+Password=PASSWORD('newpwd')+WHERE+User='root';
FLUSH+PRIVILEGES;|929599|the+cited+source也提供了另一种方法。|929600|entityMap|0|LINK|mutability|MUTABLE|url|https://help.ubuntu.com/community/MysqlPasswordReset|1^0|S|4|0|0|0|0|0|0|G|1|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@$A|Y|B|Z|1|10]]|C|$]]|$1|D|3|E|5|F|7|11|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|12|8|@]|9|@]|C|$]]|$1|K|3|L|5|F|7|13|8|@]|9|@]|C|$G|H]]|$1|M|3|N|5|6|7|14|8|@]|9|@$A|15|B|16|1|17]]|C|$]]|$1|O|3|-4|5|6|7|18|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]|W|$5|R|S|T|C|$U|V]]]]

MySQL 5.5 on Ubuntu 14.04 required slightly different commands as recommended <a href="https://help.ubuntu.com/community/MysqlPasswordReset" rel="noreferrer">here</a>. In a nutshell:

<pre><code>sudo /etc/init.d/mysql stop
sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &amp;
mysql -u root
</code></pre>

And then from the MySQL prompt

<pre><code>FLUSH PRIVILEGES;
SET PASSWORD FOR root@'localhost' = PASSWORD('password');
UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
FLUSH PRIVILEGES;
</code></pre>

And <a href="https://help.ubuntu.com/community/MysqlPasswordReset" rel="noreferrer">the cited source</a> offers an alternate method as well.

blocks|key|929666|text|在MYSQL+5.7下，如果您使用mysql进行开发，只需：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|929667|1.kill+mysql：|929668|$+sudo+service+mysql+stop|code-block|syntax|javascript|929669|2.在--跳过-授权-表模式下启动mysql：|929670|$+sudo+mysqld_safe+--skip-grant-tables+|929671|此外，您可以尝试在“跳过-授权-表”模式下更改用户表，但是我失败了。|929672|所以，这只是一种变通方法。|929673|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

Under MYSQL 5.7, If you are using mysql for development purpose, just : 

1.kill mysql : 

<pre><code>$ sudo service mysql stop
</code></pre>

2.start mysql under --skip-grant-tables mode: 

<pre><code>$ sudo mysqld_safe --skip-grant-tables 
</code></pre>

and, further, you could try to change the user table under "skip-grant-table" mode, however I failed. 

so, this is just a workaround.

blocks|key|929721|text|嗯，Mysql+5.7.13来重置我所做的一切就是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|929722|停止mysql的$+sudo+service+mysql+stop|offset|length|style|CODE|929723|$+mysqld_safe+--skip-grant-tables+&启动mysql|929724|$+mysql+-u+root|929725|就像正确答案一样。然后我所做的就是做@eebbesen做的事情。|929726|mysql>+SET+PASSWORD+FOR+root@'localhost'+=+PASSWORD('NEW-password-HERE');|929727|希望这对任何人都有帮助:)|929728|entityMap^0|0|8|P|0|0|Z|0|0|F|0|0|0|21|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@$D|V|E|W|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@$D|Y|E|Z|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|10|8|@$D|11|E|12|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|13|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|14|8|@$D|15|E|16|F|G]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|17|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|S|$]]

Hmm Mysql 5.7.13 to reset all I did was:

<code>$ sudo service mysql stop</code> To stop mysql

<code>$ mysqld_safe --skip-grant-tables &amp;</code> Start mysql

<code>$ mysql -u root</code>

Just like the correct answer. Then all I did was do what @eebbesen did.

<code>mysql&gt; SET PASSWORD FOR root@'localhost' = PASSWORD('NEW-password-HERE');</code>

Hope it helps anyone out there :)

blocks|key|713765|text|sudo+mysql+-u+root
ALTER+USER+'root'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'YOUR_PASSWORD_HERE';
FLUSH+PRIVILEGES;

mysql+-u+root+-p+#+and+it+works|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|713766|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>sudo mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YOUR_PASSWORD_HERE';
FLUSH PRIVILEGES;

mysql -u root -p # and it works
</code></pre>

blocks|key|929757|text|有一个简单的解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|929758|MySql+5.7带有匿名用户，因此您需要重新配置MySQL服务器。|929759|您可以使用以下命令执行此操作|929760|尝试查找临时传递：|929761|grep+'temporary+password'+/var/log/mysqld.log|code-block|syntax|javascript|929762|然后：|929763|sudo+mysql_secure_installation|929764|此链接提供了有关mysql+5.7的更多信息|929765|https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html|offset|length|929766|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|0|0|0|0|0|20|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|14|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|15|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|16|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|17|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|18|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|19|8|@]|9|@]|A|$K|L]]|$1|Q|3|R|5|6|7|1A|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1B|8|@]|9|@$U|1C|V|1D|1|1E]]|A|$]]|$1|W|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|T]]]]

There is a simple solution.

MySql 5.7 comes with anonymous user so you need to reconfigure MySQL server.

You can do that with this command

try to find temp pass:

<pre><code>grep 'temporary password' /var/log/mysqld.log
</code></pre>

then:

<pre><code>sudo mysql_secure_installation
</code></pre>

On this link is more info about mysql 5.7

<a href="https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html</a>

blocks|key|713878|text|这实际上非常简单。你不需要经历很多事情。只需在终端中运行以下命令并按照屏幕上的说明进行操作即可。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|713879|sudo+mysql_secure_installation|code-block|syntax|javascript|713880|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|$]]

It is actually very simple. You don't have to go through a lot of stuff.
Just run the following command in terminal and follow on-screen instructions.

<pre><code>sudo mysql_secure_installation
</code></pre>

I just installed MySQL on Ubuntu and the root user can't log in :)

How can I recover or find out my password? Using blank for password does not work.

How do I find out my root MySQL password?

服务器

Ubuntu

MySQL

我刚刚在Ubuntu上安装了MySQL，根用户无法登录:)如何找回或找到我的密码？使用空白作为密码不起作用。

问如何找到我的根MySQL密码？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何找到我的根MySQL密码？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何找到我的根MySQL密码？
EN