Join the community today
Become a Member

MariaDB acess denied mysql

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by hardousse, Aug 9, 2016.

  1. hardousse

    hardousse Active Member

    169
    35
    28
    Dec 15, 2015
    Sweden
    Ratings:
    +57
    Local Time:
    1:32 PM
    1.11.*
    10.1*
    i get this error
    MySQL said: Access denied for user 'root'@'localhost' (using password: YES) i can not connect to database the password is correct database running. any help

     
  2. eva2000

    eva2000 Administrator Staff Member

    54,909
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,811
    Local Time:
    9:32 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Centmin Mod installs set the mysql root user password at initial install and is also available in /root/.my.cnf. You can change mysql root password via FAQ item 35 instructions too.
     
  3. hardousse

    hardousse Active Member

    169
    35
    28
    Dec 15, 2015
    Sweden
    Ratings:
    +57
    Local Time:
    1:32 PM
    1.11.*
    10.1*
    i update the passwor dbut nothing chnage and when i debuge i get this
    Code:
    -- Unit session-13.scope has begun starting up.
    Aug 08 18:40:01 srv1.orbatatech.com CROND[5657]: (root) CMD (/usr/lib64/sa/sa1 1 1)
    Aug 08 18:40:20 srv1.orbatatech.com kernel: Firewall: *TCP_IN Blocked* IN=eth0 OUT= MAC=f2:3c:91:e2:8b:95:50:87:89:40:a1:c1:08:00 SRC=182.180.124.242 DST=139.x.x.x LEN=44 TOS=0x08 PRE
    Aug 08 18:40:25 srv1.orbatatech.com systemd[1]: mariadb.service start operation timed out. Terminating.
    Aug 08 18:41:07 srv1.orbatatech.com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
    Aug 08 18:41:07 srv1.orbatatech.com systemd[1]: Failed to start MariaDB database server.
    -- Subject: Unit mariadb.service has failed
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit mariadb.service has failed.
    --
    -- The result is failed.
    Aug 08 18:41:07 srv1.orbatatech.com systemd[1]: Unit mariadb.service entered failed state.
    Aug 08 18:41:07 srv1.orbatatech.com systemd[1]: mariadb.service failed.
    Aug 08 18:41:07 srv1.orbatatech.com polkitd[3215]: Unregistered Authentication Agent for unix-process:5392:118033 (system bus name :1.39, object path /org/freedesktop/PolicyKit1/Authentica
    ESCOD
    -- Subject: Unit session-12.scope has begun start-up
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    --
    -- Unit session-12.scope has begun starting up.
    Aug 08 18:40:01 srv1.orbatatech.com systemd[1]: Started Session 13 of user root.
    -- Subject: Unit session-13.scope has finished start-up
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    i think its attack in mariadb server,honesty its the third time i get this with linode and specially with Frankfurt datacenter
     
  4. hardousse

    hardousse Active Member

    169
    35
    28
    Dec 15, 2015
    Sweden
    Ratings:
    +57
    Local Time:
    1:32 PM
    1.11.*
    10.1*
    Code:
    - The result is failed.
    Aug 08 18:41:07 srv1.orbatatech.com systemd[1]: Unit mariadb.service entered failed state.
    Aug 08 18:41:07 srv1.orbatatech.com systemd[1]: mariadb.service failed.
    Aug 08 18:41:07 srv1.orbatatech.com polkitd[3215]: Unregistered Authentication Agent for unix-process:5392:118033 (system bus name :1.39, object path /org/freedesktop/PolicyKit1/Authentica
     
  5. eva2000

    eva2000 Administrator Staff Member

    54,909
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,811
    Local Time:
    9:32 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  6. hardousse

    hardousse Active Member

    169
    35
    28
    Dec 15, 2015
    Sweden
    Ratings:
    +57
    Local Time:
    1:32 PM
    1.11.*
    10.1*
    fixed.
    thank you for your help @eva2000 its was problem of process i kill it and restart and all ok.
     
  7. eva2000

    eva2000 Administrator Staff Member

    54,909
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,811
    Local Time:
    9:32 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Glad to hear :)