纯小白,安装MYSQL时没有要求输入密码,但是登录时报错:
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO(YES))
提供一个笨拙方法:
<一>:先卸载已安装的MYSQL:
apt-get autoremove --purge mysql-server-版本号
apt-get autoremove mysql-server
apt-get remove mysql-common
dpkg -l |grep ^rc|awk '{print $2}' |sudo xargs dpkg -P
<二>:复制以下代码进行安装:
# Mysql
cat <<EOF |sudo debconf-set-selections
mysql-apt-config mysql-apt-config/select-tools select Enabled
mysql-apt-config mysql-apt-config/repo-distro select debian
mysql-apt-config mysql-apt-config/repo-url string https://repo.mysql.com/apt
mysql-apt-config mysql-apt-config/select-server select mysql-5.7
mysql-apt-config mysql-apt-config/select-product select Ok
mysql-apt-config mysql-apt-config/preview-component select
mysql-apt-config mysql-apt-config/repo-codename select stretch
mysql-apt-config mysql-apt-config/select-preview select Disabled
mysql-apt-config mysql-apt-config/tools-component select mysql-tools
mysql-apt-config mysql-apt-config/unsupported-platform select debian stretch
EOF
wget https://dev.mysql.com/get/mysql-apt-config_0.8.13-1_all.deb && sudo DEBIAN_FRONTEND=noninteractive dpkg -i mysql-apt-config*.deb && sudo apt update && sudo apt install mysql-community-server -y
这段代码安装时要求输入密码,就免去了报错。
另外,再加一个网址,基本操作,里面也提到了没有初始密码的问题,不过我没有验证,因为上面已经设置了密码
https://www.cnblogs.com/D666/p/9165088.html
代码来源:
https://blog.csdn.net/sinat_37064286/article/details/82224562
https://bbs.deepin.org/forum.php?mod=viewthread&tid=180915