1.mysql 启动服务提示输入密码

解决MySQL启动输密问题

最新推荐文章于 2023-01-16 14:26:59 发布

转载最新推荐文章于 2023-01-16 14:26:59 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/black-/p/8980594.html

文章标签：

#数据库

本文记录了在启动MySQL服务过程中遇到连续提示输入密码的问题及其解决方案。通过分析发现该问题是由于MySQL安装时自动创建的Linux用户导致，最终通过使用passwd命令清空该用户的密码解决了问题。

1.解决mysql启动服务过程中一直提示输密码，分析是mysql安装时自动建立的linux user，运行passwd -d mysql后解决，在此记录

root@ubuntu:/etc/init.d# service mysql start
 * A MySQL Server is already started
root@ubuntu:/etc/init.d# service mysql restart
 * Stopping MySQL Community Server 5.7.18
.....
 * MySQL Community Server 5.7.18 is stopped
 * Re-starting MySQL Community Server 5.7.18
[sudo] password for mysql:
Sorry, try again.
[sudo] password for mysql:
Sorry, try again.
[sudo] password for mysql:
Sorry, try again.
sudo: 3 incorrect password attempts
[sudo] password for mysql:
Sorry, try again.
[sudo] password for mysql:
Sorry, try again.
[sudo] password for mysql:
Sorry, try again.
sudo: 3 incorrect password attempts
..
 * MySQL Community Server 5.7.18 is started

转载于:https://www.cnblogs.com/black-/p/8980594.html