ispconfig3 in ubuntu 18.04: mysqli_real_connect(): (HY000/1698): Access denied for user 'root'

Hi,

Installed ispconfig3 in ubuntu 18.04, but there appears to be a problem with the phpmyadmin as root:

Code:

mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'

I can access to the database in command line with 'mysql -u root -p' without a problem, fyi.

I followed @till as appeared in https://www.howtoforge.com/communit...ed-for-user-root-localhost.77178/#post-364462, it didn't change a thing in phpmyadmin, but after the changes, even 'mysql -u root -p' appears to be blocked:

Code:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Any clue? Thanks and cheers,

/z

 

SOLUTION 1:
SOLVED by resetting the 'root' password (for record):

Code:

# mysqld_safe --skip-grant-tables &
# mysqld_safe --skip-grant-tables
# mysql -u root
MariaDB [(none)]> use mysql;
MariaDB [mysql]> update user set password=PASSWORD("YourChosenPassword") where user='root';
MariaDB [mysql]> flush privileges;
MariaDB [mysql]> quit;
# service mysql restart
#mysql -u root -p YourChosenPassword

SOLUTION 2:
Another way to achieve the same by creating a new PHPMyAdmin user (pmauser) with root privileges if you are not locked without root access without making any changes described at https://www.howtoforge.com/communit...ed-for-user-root-localhost.77178/#post-364462:

Code:

# mysql -u root -p
MariaDB [(none)]> CREATE USER 'pmauser'@'%' IDENTIFIED BY 'YourChosenPassword';
MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'pmauser'@'%' WITH GRANT OPTION;
MariaDB [(none)]> flush privileges;
MariaDB [(none)]> quit;

Hope this is helpful for someone who had similar issues in the future.

Cheers,
/z