Difference between revisions of "OS-Linux-Service-Mysql"
Jump to navigation
Jump to search
(Convert markup from PmWiki to MediaWiki) |
m (Krb moved page OS-Linux-ServiceMysql to OS-Linux-Service-Mysql: Category name should have been separated from page name by dash.) |
(No difference)
| |
Latest revision as of 04:04, 6 February 2018
- See Also
- OS-Linux
Contents
General Information
Server Details
- Port
- 3306
Client Details
- name
- mysql
Troubleshooting Hints
- 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)?- 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
