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
Already checked/tried: 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.