OS-Linux-Service-Mysql

See Also 

OS-Linux

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)?

2. 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

Root	Directory Tree	Description
/etc/		Configuration file area
	my.cnf
	mysqlmanager.passwd
/etc/rc.d/init.d/
	mysqld
/etc/sysconfig/
/usr/lib*/mysql/mysql/plugin/
	*.so
/usr/sbin/
	mysqld
/var/lib/mysql/
	mysql.sock
	mysqlmanager.sock
/var/log/mysql/
	mysqld.log
/var/run/mysqld
	mysqld.pid
	mysqlmanager.pid