Cant login to MYSQL

[flaihus]

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?

[sahsanu]

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> FLUSH PRIVILEGES;
mysql> QUIT;