Cant login to MYSQL

i cant login to phpmyadmin i got “mysqli::real_connect(): (HY000/1698): Access denied for user ‘root’@‘localhost’” i use the default password located here vim /usr/local/hestia/conf/mysql.conf

any help?

Hi @flaihus,

phpmyadmin doesn’t allow root user to connect. If you want to connect using a “root” user, create a new one and use it to connect.

From command line, as root, use below commands:

Note: Replace newroot by your new root user and some_password by your preferred password.

mysql -uroot
mysql> CREATE USER 'newroot'@'localhost' IDENTIFIED BY 'some_password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'newroot'@'localhost' WITH GRANT OPTION;
mysql> QUIT;

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.