I have a CentOS 6.6, on the system there was a working Mysql and a mysql server already installed and a running mysqld service, but I needed a fresh install, so I did the whole removal through yum, and removal of the old Mysql residue files (double checked for remaining files).
[root@sputnik mysql]# yum install mysql mysql-server
Installation completes successfully without errors.
Starting Mysql service on a few different ways:
[root@sputnik mysql]# service mysqld start MySQL Daemon failed to start. Starting mysqld: [FAILED] [root@sputnik mysql]# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [root@sputnik mysql]# mysqld_safe 150127 11:44:39 mysqld_safe Logging to '/var/lib/mysql/sputnik.fadata.eu.err'. 150127 11:44:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150127 11:44:44 mysqld_safe mysqld from pid file /var/lib/mysql/sputnik.fadata.eu.pid ended
/var/lib/mysql/mysql.sock this file doesn't exist anywhere in the system, and through research I found that it is generated during mysqld service starting but the service refuses to start because it is missing?
/var/lib/mysql/sputnik.fadata.eu log file contains:
150127 11:36:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150127 11:36:07 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys' /usr/libexec/mysqld: Unknown error 1146 150127 11:36:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 150127 11:36:07 InnoDB: Initializing buffer pool, size = 8.0M 150127 11:36:07 InnoDB: Completed initialization of buffer pool 150127 11:36:07 InnoDB: Started; log sequence number 0 44233 150127 11:36:07 [ERROR] Aborting
/var/log/mysqld.log contains nothing,
/var/run/mysqld is an empty directory
- I have tried mysql secure installationand complete reinstallation a few times,
- Tried to manually insert an errmsg.sys file,
- Tried to install initial tables and databases manually. The Mysql user exists and it is the owner and has the necessary privileges over it's files,
- Tried to start mysql service and mysqld service through init.d and all other ways, no service containing mysql or mysqld is running.
Basically I tried everything I found on the forums, so the problem is I need to install and set mysql service to run. These are the details and errors I have. If I need to post more details please let me know.