Ubuntu 20.04, 安装phpmyadmin后出现1698和1045错误的解决方法

    技术2022-07-11  63

    Ubuntu20.04 安装完成lamp后安装完成phpmyadmin, 但无法进入phpmyadmin提示登录页面的解决办法:

    jiong@jiong:~$ sudo nano /etc/apache2/apache2.conf

    加入下面这一行:

    Include /etc/phpmyadmin/apache.conf

    Ctrl+O 写入,Ctrl+X 退出。

    jiong@jiong:~$ sudo systemctl restart apache2

     

    可以进入phpmyadmin提示登录页面, 但是输入密码后不能登录的解决办法:

    (错误提示:mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost')

     

    jiong@jiong:~$ sudo mysql -u root

    mysql> USE mysql;

    Reading table information for completion of table and column names

    You can turn off this feature to get a quicker startup with -A

    Database changed

    mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';

    (后来上面这句又改成了UPDATE user SET plugin='caching_sha2_password' WHERE User='root';)

    Query OK, 1 row affected (0.04 sec)

    Rows matched: 1 Changed: 1 Warnings: 0

     

    mysql> FLUSH PRIVILEGES;

    Query OK, 0 rows affected (0.02 sec)

     

    mysql> exit

    Bye

    jiong@jiong:~$ service mysql restart

     

    还是不能登录phpmyadmin。

    错误提示:mysqli_real_connect(): (HY000/1045): Access denied for user 'jiong'@'localhost' (using password: YES)

    root进入也不行:

    mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)

     

    解决方案:登录phpmyadmin不成功,出现1045错误,是因为安装mysql时没有设定登录mysql的密码(就没有提示设定密码),默认是空密码,导致安装完成phpmyadmin后,用安装phpmyadmin时设定的密码不能登录。修改mysql的root密码的诸多方法,比如:

    UPDATE user SET Password = PASSWORD('123') WHERE user = 'root';

    set password for root@localhost = password('123');

    update user set password=password('123') where user='root' and host='localhost';

    等等都不对路。

    搜索后,网友的一句SET PASSWORD = '123'; 简单粗暴,完美解决问题。

    注:我后来设定的mysql的root密码和安装phpmyadmin时设的密码相同,不同应该也没有关系,没试。

     

     

    Processed: 0.009, SQL: 9