Recognition

Posts

2 Posts
  • Published Answer

    "Cannot log in to the MySQL server" without code using phpMyAdmin on CentOS7

    The result of that command looks like this: tcp6 0 0 :::33060 :::* LISTEN 3690/mysqld tcp6 0 0 :::3306 …
    By NielsKersic
  • Published Question

    "Cannot log in to the MySQL server" without code using phpMyAdmin on CentOS7

    I've set up a new CentOS 7 server with Apache, MySQL and phpMyAdmin using Digital Ocean's guides. However, when I try to log in to phpMyAdmin via the browser, I get the message "Cannot log in to the MySQL server" with...
    Accepted Answer: Assuming MySQL 8. ALTER USER root IDENTIFIED WITH mysql_native_password BY 'PASSWORD'; Reason: Some applications are having trouble with <^>caching _sha2 _password<^> method. Above sets the credentials to use the...
    4 By NielsKersic MySQL Databases CentOS