Access denied for user 'root'@'localhost' (using password: NO)

[n2rga]

in dbgovernor-error.log going back to last September I see this:

Mon Jun 20 05:38:13 2022] Open govern connection operation
[Mon Jun 20 05:38:13 2022] Try to connect with options from dbgovernor config file
[Mon Jun 20 05:38:13 2022] Try to connect with no password under root
[Mon Jun 20 05:38:13 2022] Access denied for user 'root'@'localhost' (using password: NO)
[Mon Jun 20 05:38:13 2022] Open write connection operation
[Mon Jun 20 05:38:13 2022] Try to connect with options from dbgovernor config file
[Mon Jun 20 05:38:13 2022] Try to connect with no password under root
[Mon Jun 20 05:38:13 2022] Access denied for user 'root'@'localhost' (using password: NO)
[Mon Jun 20 05:38:13 2022] Try to connect with options from dbgovernor config file
[Mon Jun 20 05:38:13 2022] Try to connect with no password under root
[Mon Jun 20 05:38:13 2022] Access denied for user 'root'@'localhost' (using password: NO)
[Mon Jun 20 05:38:13 2022] Governor successfully connected to mysql
[Mon Jun 20 05:38:13 2022] MySQL version correct 10
[Mon Jun 20 05:38:13 2022] MariaDB version 10.4+ FOUND
[Mon Jun 20 05:38:13 2022] Started
[Mon Jun 20 05:38:13 2022] Governor work without LVE (no)
[Mon Jun 20 05:38:13 2022] BAD list init successfully
[Sat Jun 25 05:42:59 2022] Stopped
[Sat Jun 25 06:11:22 2022] Open govern connection operation
[Sat Jun 25 06:11:22 2022] Try to connect with options from dbgovernor config file
[Sat Jun 25 06:11:22 2022] Try to connect with no password under root
[Sat Jun 25 06:11:22 2022] Access denied for user 'root'@'localhost' (using password: NO)
[Sat Jun 25 06:11:22 2022] Open write connection operation
[Sat Jun 25 06:11:22 2022] Try to connect with options from dbgovernor config file
[Sat Jun 25 06:11:22 2022] Try to connect with no password under root
[Sat Jun 25 06:11:22 2022] Access denied for user 'root'@'localhost' (using password: NO)
[Sat Jun 25 06:11:22 2022] Try to connect with options from dbgovernor config file
[Sat Jun 25 06:11:22 2022] Try to connect with no password under root
[Sat Jun 25 06:11:22 2022] Access denied for user 'root'@'localhost' (using password: NO)
[Sat Jun 25 06:11:22 2022] Governor successfully connected to mysql
[Sat Jun 25 06:11:23 2022] MySQL version correct 10
[Sat Jun 25 06:11:23 2022] MariaDB version 10.4+ FOUND
[Sat Jun 25 06:11:23 2022] Started
[Sat Jun 25 06:11:23 2022] Governor work without LVE (no)
[Sat Jun 25 06:11:23 2022] BAD list init successfully

How to fix?

Mitch

[Miguel Varela]

Hey Mitch,

You may want to check the file /etc/container/mysql-governor.xml

That's the file where the database credentials for DB Governor reside.

Do give it a try, feel free to open a ticket with us should you need further help! :-)

[n2rga]

See it what Am I looking for?

<limit current="30" name="slow"/>
</default>
<user mode="ignore" mysql_name="root"/>
<user mode="ignore" mysql_name="mysql"/>
<user mode="ignore" mysql_name="#mysql"/>
<user mode="ignore" mysql_name="#mysql_system#"/>
<user mode="ignore" mysql_name="eximstats"/>
<user mode="ignore" mysql_name="dbgovernor"/>
<user mode="ignore" mysql_name="leechprotect"/>
<user mode="ignore" mysql_name="unauthenticated user"/>
<user mode="ignore" mysql_name="logaholic"/>
<user mode="ignore" mysql_name="cphulkd"/>
<user mode="ignore" mysql_name="pp"/>
<user mode="ignore" mysql_name="DELAYED"/>
<user mode="ignore" mysql_name="admin"/>
<logqueries use="on"/>
<slow_queries log="/var/log/kill.log" run="on"/>
<restrict_mode unlimit="60s" use="limit"/>
<user mode="restrict" name="funtime247">
<limit current="400" long="300" mid="348" name="cpu" short="380"/>
<limit current="998768640" long="589273497" mid="759064166" name="read" short="828977971"/>
<limit current="998768640" long="589273497" mid="759064166" name="write" short="828977971"/>
</user>
</governor>

funtime247 is one of my personal websites

Mitch

[bogdan.sh]

Please try to set a root access credentials in that XML file, like:

<connector host="..." login="..." password=".." prefix_separator="_"/>

Then restart MySQL governor.

More: https://docs.cloudlinux.com/cloudlin...onfiguration-3