MySQL root password

Hello,

Is the MySQL root password saved somewhere during installation or should I just reset it the usual way by starting MySQL without loading the grant tables or enabling networking?

Thanks in advance,
George

Hello !

cat /etc/cyberpanel/mysqlPassword

Regards

1 Like

Awesome, thanks!

This worked great for locating the root password, but how would I verify what the username is? I thought the default was - admin - but I am unable to login to PhpMyAdmin using admin and the root password.

When I enter the following command after logging into MySQL via SSH …

SELECT User FROM mysql.user;

I get the user table, but see there are four entries for root, why would there be four users name root?

For me result is

MariaDB [(none)]> SELECT User FROM mysql.user;
+------------+
| User       |
+------------+
| cyberpanel |
| pdns       |
| root       |
+------------+

On plain install.

1 Like

I have changed mysql password, however, after changing I can’t create a new database. Is there any way to thoroughly overcome this problem?

This guide explains where to update the MySQL password, in case you feel the need to change your password β†’ Some Don'ts After Installing CyberPanel! β€” CyberPanel - WebHosting Control Panel for OpenLiteSpeed