OS-Linux-Service-Mysql

!! General Information

!!! Server Details

Port : 3306

!!! Client Details

name: mysql

!! Troubleshooting Hints

1. Upon trying to secure the root user with `mysqladmin -u root -h $(hostname) password 'new-password'\\

(as advised when first starting the server):

• • mysqladmin: connect to server at 'duo_10s.kbulgrien.att.net' failed\\

error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111'

• • • Is bind-address set in /etc/my.cnf?
    • Is bind-address in /etc/my.cnf the same as -h $(hostname)?

1. Upon attempting a start of the client with `mysql`:\\

• • ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    • Start the client with `mysql -p`and enter the appropriate password when prompted.
  • ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    • Start the server with `service mysqld start`.

!! Files & Folders

(:table bgcolor="#C0C0C0" cellpadding="0" cellspacing="1" :) (:head bgcolor="#808080":) Root (:head bgcolor="#808080":) Directory Tree          (:head bgcolor="#808080":) Description (:cellnr rowspan="3" :) /etc/ (:cell:) (:cell:) Configuration file area (:cellnr bgcolor="#CFCFCF":) my.cnf (:cell bgcolor="#CFCFCF":) (:cellnr:) mysqlmanager.passwd (:cell:)   (:cellnr bgcolor="#CFCFCF" rowspan="2" :) /etc/rc.d/init.d/ (:cell bgcolor="#CFCFCF":)   (:cell bgcolor="#CFCFCF":)   (:cellnr:) mysqld (:cell:)   (:cellnr bgcolor="#CFCFCF" rowspan="2" :) /etc/sysconfig/ (:cell bgcolor="#CFCFCF":)   (:cell bgcolor="#CFCFCF":)   (:cellnr:) mysqld (:cell:)   (:cellnr bgcolor="#CFCFCF" rowspan="2" :) /usr/lib*/mysql/mysql/plugin/ (:cell bgcolor="#CFCFCF":)   (:cell bgcolor="#CFCFCF":)   (:cellnr:) *.so (:cell:)   (:cellnr bgcolor="#CFCFCF" rowspan="2" :) /usr/sbin/ (:cell bgcolor="#CFCFCF":)   (:cell bgcolor="#CFCFCF":)   (:cellnr:) mysqld (:cell:)   (:cellnr bgcolor="#CFCFCF" rowspan="3" :) /var/lib/mysql/ (:cell bgcolor="#CFCFCF":)   (:cell bgcolor="#CFCFCF":)   (:cellnr:) mysql.sock (:cell:)   (:cellnr bgcolor="#CFCFCF":) mysqlmanager.sock (:cell bgcolor="#CFCFCF":)   (:cellnr rowspan="2" :) /var/log/mysql/ (:cell:)   (:cell:)   (:cellnr bgcolor="#CFCFCF":) mysqld.log (:cell bgcolor="#CFCFCF":)   (:cellnr rowspan="3" :) /var/run/mysqld (:cell:)   (:cell:)   (:cellnr bgcolor="#CFCFCF":) mysqld.pid (:cell bgcolor="#CFCFCF":)   (:cellnr:) mysqlmanager.pid (:cell:)   (:tableend:)