Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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

  • #2
    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! :-)

    Comment


    • #3
      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

      Comment


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


        Code:
        <connector host="..." login="..." password=".." prefix_separator="_"/>
        Then restart MySQL governor.

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

        Comment

        Working...
        X