blocks|key|24158|text|您可能会对阅读this+question+and+aswers感兴趣。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|24159|默认密码不是空字符串吗？|24160|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/10895163/how-to-find-out-the-mysql-root-password/27998121#27998121^0|7|O|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

You might be interested reading <a href="https://stackoverflow.com/questions/10895163/how-to-find-out-the-mysql-root-password/27998121#27998121">this question and aswers</a>. 

Isn't the default password the empty string ?

blocks|key|25573|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|25574|安装后，运行MySql安全安装：|25575|pi@raspberrypi:~+$+sudo+mysql_secure_installation|code-block|syntax|javascript|25576|系统将询问您一系列与安全相关的配置问题，包括设置root密码。|25577|设置根密码后，您需要以根用户身份登录(或使用sudo)才能登录。这是由于MySql使用基于process+uid的凭据的结果|offset|length|style|CODE|25578|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/28068155/access-denied-for-user-rootlocalhost-using-password-yes-after-new-instal^0|0|0|0|0|M|4|19|B|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|11|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|12|8|@$M|13|N|14|O|P]]|9|@$M|15|N|16|1|17]]|A|$]]|$1|Q|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

Try this:

After installation, run MySql Secure Installation:

<pre><code>pi@raspberrypi:~ $ sudo mysql_secure_installation
</code></pre>

You'll be asked a series of security related configuration questions, including setting the root password.

Once the root password is set, you'll need to be logged in as root (or use <code>sudo</code>) to login. This is a consequence of how MySql uses credentials based on <a href="https://stackoverflow.com/questions/28068155/access-denied-for-user-rootlocalhost-using-password-yes-after-new-instal">process uid</a>

blocks|key|2480210|text|我遇到了同样的问题，导致我无法访问mysql，在运行sudo+apt+install+mysql-server之后，使用mysql_secure_installation的所有答案都不起作用。以下是有效的方法|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2480211|2480212|转到official+mysql+installation+guide并逐行跟踪|ordered-list-item|2480213|您需要从here下载一个.deb文件，该文件配置您要安装的mysql的版本和其他mysql配置都已完成运行sudo+apt-get+update+&&+sudo+apt-get+install+mysql-server这一次，您将被要求输入密码。|2480214|2480215|希望能有所帮助。干杯!|2480216|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/|1|https://dev.mysql.com/downloads/repo/apt/^0|Q|T|1O|P|0|0|2|X|0|0|1H|1K|4|4|1|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|13|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|14|8|@]|D|@$9|15|A|16|1|17]]|E|$]]|$1|J|3|K|5|I|7|18|8|@$9|19|A|1A|B|C]]|D|@$9|1B|A|1C|1|1D]]|E|$]]|$1|L|3|-4|5|6|7|1E|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|1F|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|1G|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]|W|$5|R|S|T|E|$U|X]]]]

I had the same problem which prevented me from being able to access mysql all the answers to use <code>mysql_secure_installation</code> after running <code>sudo apt install mysql-server</code> didn't work. Here's what worked

<ol>
<li>Go to <a href="https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/" rel="nofollow noreferrer">official mysql installation guide</a> and follow line by line</li>
<li>You need to download a .deb file from <a href="https://dev.mysql.com/downloads/repo/apt/" rel="nofollow noreferrer">here</a> that configures which version of mysql you want to install and other configurations</li>
<li>After configurations are all done run <code>sudo apt-get update &amp;&amp; sudo apt-get install mysql-server</code> This time you'd be asked for a password.</li>
</ol>

Hope it helps. Cheers!

blocks|key|24160|text|从mysql官网https://dev.mysql.com/downloads/repo/apt/下载apt仓库|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|24161|选择您的版本并单击下一步，然后选择确定并单击下一步。|24162|现在|24163|sudo+apt-get+update++

sudo+apt-get+install+mysql-server|code-block|syntax|javascript|24164|安装时会要求输入密码。|24165|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/downloads/repo/apt/^0|8|15|0|0|0|0|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|6|7|10|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|12|8|@]|9|@]|C|$K|L]]|$1|M|3|N|5|6|7|13|8|@]|9|@]|C|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]]]

Download apt repository from mysql official site <a href="https://dev.mysql.com/downloads/repo/apt/" rel="nofollow noreferrer">https://dev.mysql.com/downloads/repo/apt/</a>

Select your version and click next and select ok and click next.

now 

<pre><code>sudo apt-get update 

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

while installing it will ask for password.

blocks|key|25600|text|你可以转到：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|25601|在新的sql中，如果安装时密码为空，那么它将基于auth_socket插件。|CODE|25602|正确的方法是使用sudo权限登录my-sql。|25603|$+sudo+mysql+-u+root+-p|code-block|syntax|javascript|25604|然后使用以下命令更新密码：|25605|$+ALTER+USER+'root'@'localhost'+IDENTIFIED+WITH+mysql_native_password+BY+'new-password';|25606|完成此操作后，stop+and+start+mysql服务器。|25607|$++sudo+service+mysql+stop
$++sudo+service+mysql+start|25608|有关完整的详细信息，请参阅this+link。|25609|如果您有任何疑问，请发表评论。|25610|entityMap|0|LINK|mutability|MUTABLE|url|https://www.percona.com/blog/2016/03/16/change-user-password-in-mysql-5-7-with-plugin-auth_socket/^0|5|1|0|O|B|0|8|4|0|0|0|0|7|E|0|0|D|9|0|0|0^^$0|@$1|2|3|4|5|6|7|19|8|@$9|1A|A|1B|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1C|8|@$9|1D|A|1E|B|H]]|D|@]|E|$]]|$1|I|3|J|5|6|7|1F|8|@$9|1G|A|1H|B|H]]|D|@]|E|$]]|$1|K|3|L|5|M|7|1I|8|@]|D|@]|E|$N|O]]|$1|P|3|Q|5|6|7|1J|8|@]|D|@]|E|$]]|$1|R|3|S|5|M|7|1K|8|@]|D|@]|E|$N|O]]|$1|T|3|U|5|6|7|1L|8|@$9|1M|A|1N|B|H]]|D|@]|E|$]]|$1|V|3|W|5|M|7|1O|8|@]|D|@]|E|$N|O]]|$1|X|3|Y|5|6|7|1P|8|@]|D|@$9|1Q|A|1R|1|1S]]|E|$]]|$1|Z|3|10|5|6|7|1T|8|@]|D|@]|E|$]]|$1|11|3|-4|5|6|7|1U|8|@]|D|@]|E|$]]]|12|$13|$5|14|15|16|E|$17|18]]]]

Here you go:

In the new my-sql if the password is left empty while installing then it is based on the <code>auth_socket</code> plugin.

The correct way is to login to my-sql with <code>sudo</code> privilege.

<pre><code>$ sudo mysql -u root -p
</code></pre>

And then updating the password using:

<pre><code>$ ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new-password';
</code></pre>

Once this is done <code>stop and start</code> the mysql server.

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

For complete details you can refer to <a href="https://www.percona.com/blog/2016/03/16/change-user-password-in-mysql-5-7-with-plugin-auth_socket/" rel="noreferrer">this link</a>.

Do comment for any doubt.

blocks|key|2480276|text|如果有人在Ubuntu18.04中安装MYSQL时遇到这个问题，请点击。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2480277|Ubuntu+18.04使用套接字进行授权，而不是密码！|2480278|(https://websiteforstudents.com/mariadb-installed-without-password-prompts-for-root-on-ubuntu-17-10-18-04-beta/)|2480279|对我来说，登录就像这样简单：|2480280|sudo++mysql+-u+root++++++|code-block|syntax|javascript|2480281|别忘了sudo|CODE|2480282|我真的希望有一条消息表明Ubuntu在尝试运行mysql时不再使用密码。这在功能上是一个非常大的变化。|2480283|entityMap|0|LINK|mutability|MUTABLE|url|https://websiteforstudents.com/mariadb-installed-without-password-prompts-for-root-on-ubuntu-17-10-18-04-beta/^0|Z|1|0|0|1|32|0|0|0|0|3|4|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@$9|14|A|15|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|16|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|17|8|@]|D|@$9|18|A|19|1|1A]]|E|$]]|$1|J|3|K|5|6|7|1B|8|@]|D|@]|E|$]]|$1|L|3|M|5|N|7|1C|8|@]|D|@]|E|$O|P]]|$1|Q|3|R|5|6|7|1D|8|@$9|1E|A|1F|B|S]]|D|@]|E|$]]|$1|T|3|U|5|6|7|1G|8|@]|D|@]|E|$]]|$1|V|3|-4|5|6|7|1H|8|@]|D|@]|E|$]]]|W|$X|$5|Y|Z|10|E|$11|12]]]]

If someone facing this problem in installing MYSQL in Ubuntu 18.04. 

Ubuntu 18.04 uses sockets for authorization and not passwords!!

(<a href="https://websiteforstudents.com/mariadb-installed-without-password-prompts-for-root-on-ubuntu-17-10-18-04-beta/" rel="noreferrer">https://websiteforstudents.com/mariadb-installed-without-password-prompts-for-root-on-ubuntu-17-10-18-04-beta/</a>)

For me logging in was as simple as:

<pre><code>sudo mysql -u root 
</code></pre>

Don't forget the <code>sudo</code>

I really hope there should have been a message stating that Ubuntu no longer used passwords when attempting to run mysql. this was a really drastic change in functionality.

blocks|key|24363|text|在我的例子中，没有像这里提到的那样工作，下面的工作对我来说是有效的。这里还描述了：https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|24364|将创建超级用户帐户'root'@'localhost。设置超级用户的密码并将其存储在错误日志文件中。要显示密码，请使用以下命令：|24365|shell>+sudo+grep+'temporary+password'+/var/log/mysqld.log|style|CODE|24366|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html^0|15|20|0|0|0|0|1L|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|@$A|X|B|Y|H|I]]|9|@]|C|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]]]

In my case nothing worked as mentioned here, following worked for me.
As described here also:
<a href="https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html</a>

A superuser account 'root'@'localhost is created. A password for the superuser is set and stored in the error log file. To reveal it, use the following command:

<code>shell&gt; sudo grep 'temporary password' /var/log/mysqld.log</code>

blocks|key|24206|text|在我的例子中，mysql+root密码是我的超级用户密码。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|24207|entityMap^0|D|4|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

In my case the mysql <code>root</code> password was my superuser password.

I am installing the package mysql-server on debian (actually Raspbian, the Debian version for raspberry pi). I'm installing it with the following command

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

During the installation I'm not asked to enter a root password. And if I try to connect to mysql with the following command :

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

or 

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

and using the system root password, I got the following error :

<pre><code>ERROR 1698 (28000): Access denied for user 'root'@'localhost'
</code></pre>

I am quite confused since apparently I should be asked to provide a root password during the installation.

What should I do ?

Regards.

Fresh mysql-server installation does not ask for password

日志文件

服务器

Raspbian

Ubuntu

Debian

我正在debian (实际上是Raspbian，适用于raspberry pi的Debian版本)上安装包mysql-server。我使用以下命令安装它sudo apt-get install mysql-server在安装期间，系统不会要求我输入根密码。如果我尝试使用以下命令连接到mysql：mysql -u roo...

问全新mysql-服务器安装不要求输入密码
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问全新mysql-服务器安装不要求输入密码EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问全新mysql-服务器安装不要求输入密码
EN