2 Replies - 1587 Views - Last Post: 28 July 2012 - 06:02 PM

#1 mccabec123  Icon User is offline

  • D.I.C Head

Reputation: 18
  • View blog
  • Posts: 233
  • Joined: 03-March 11

Problem initialising MySQL Daemon

Posted 28 July 2012 - 09:01 AM

Hey guys, I'm having an issue starting my MySQL daemon after rebooting my dedi, I have no clue why it's suddenly doing this, I'm running PHPMyAdmin from the server and also issuing certain commands through the CLI for MySQL, but after rebooting I'm getting this error everytime I try to start the instance of the daemon:

[root@ks23085 ~]# service mysqld start
Redirecting to /bin/systemctl  start mysqld.service
[root@ks23085 ~]# systemctl mysqld start
Unknown operation mysqld
[root@ks23085 ~]# systemctl start mysqld
Failed to issue method call: Unit name mysqld is not valid.
[root@ks23085 ~]# systemctl start mysqld.service
[root@ks23085 ~]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/path/to/mysql.sock' (2)



It's completely bizarre as it was working perfectly before I rebooted it, I didn't update it or change the install, the only thing that I did do was install postfix, but I don't see why that would cause any issues with MySQL :S

I really need a hand on this one, I've tried several solutions from google with no results whatsoever. Thanks in advance guys.

This post has been edited by mccabec123: 28 July 2012 - 09:02 AM


Is This A Good Question/Topic? 0
  • +

Replies To: Problem initialising MySQL Daemon

#2 Lemur  Icon User is offline

  • Pragmatism over Dogma
  • member icon


Reputation: 1368
  • View blog
  • Posts: 3,453
  • Joined: 28-November 09

Re: Problem initialising MySQL Daemon

Posted 28 July 2012 - 04:25 PM

Try:

whereis mysql
whereis mysql-server

---

Look up init.d and how to add daemons to it, and that should get you up and on your way. It sounds like the changes didn't persist through reboot to that, so a flag would have to be added for mysqld.
Was This Post Helpful? 0
  • +
  • -

#3 no2pencil  Icon User is offline

  • Toubabo Koomi
  • member icon

Reputation: 5314
  • View blog
  • Posts: 27,220
  • Joined: 10-May 07

Re: Problem initialising MySQL Daemon

Posted 28 July 2012 - 06:02 PM

View PostLemur, on 28 July 2012 - 07:25 PM, said:

Try:

whereis mysql
whereis mysql-server

I've always used
which mysqld

You can also validate that mysql is or isn't running by checking for the process id :

ps aux | grep -i mysql
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1