Ad Widget

Collapse

connected to mysql server failed

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • speedlight
    Junior Member
    • Nov 2015
    • 1

    #1

    connected to mysql server failed

    I don't started my zabbix server caus my database zabbix don't connected

    Action
    /etc/zabbix/zabbix_server.conf

    grep DB zabbix_server.conf
    ### Option: DBHost
    DBHost=localhost
    ### Option: DBName
    # For SQLite3 path to database file must be provided. DBUser and DBPassword are ignored.
    # Sample SQLite3 DBName:
    # DBName=/var/lib/zabbix/zabbix.sqlite3
    # DBName=
    DBName=zabbix
    ### Option: DBSchema
    # Schema name. Used for IBM DB2.
    # DBSchema=
    ### Option: DBUser
    # DBUser=
    DBUser=zabbix
    ### Option: DBPassword
    # DBPassword=
    ### Option: DBSocket
    # DBSocket=/tmp/mysql.sock
    ### Option: DBPort
    # DBPort=3306
    ### Option: StartDBSyncers
    # Number of pre-forked instances of DB Syncers
    # StartDBSyncers=4


    $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $


    mysql -u root -p

    grant all privileges on zabbix.* to zabbix@localhost identified by 'zabbix';


    tail -50 /var/log/zabbix-server/zabbix_server.log
    [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO)



    Thank you for your help me
Working...