MySQL root password

Support and Discussion Database Server
1

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

2

Hello !

cat /etc/cyberpanel/mysqlPassword

Regards

2 Likes
3

Awesome, thanks!

4

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.

5

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?

6

For me result is

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

On plain install.

1 Like
7

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

8

This guide explains where to update the MySQL password, in case you feel the need to change your password → Some Dont's After Installing CyberPanel! - Blog Posts - CyberPanel Community