Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012

    Unanswered: can't KILL MYSQL 's pid or use mysql stop

    I can't kill mysqld using its PID (process id which I get in sudo bash using and and I can't login with --skip-grant-tables
    What's happened?

    in order to try and get it to stop so I can set a new password.
    So I can't get in at all...

    wait a minute

  2. #2
    Join Date
    May 2012

    i did mysqld stop and that worked but-

    but now its giving me socket problems.

    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

    there is nothing there!

    no mysqld.sock file or anything in that DIR...


  3. #3
    Join Date
    Sep 2009
    San Sebastian, Spain
    Check the file /etc/my.cnf or /etc/mysql/my.cnf which contains the MySQL server configuration including the socket connection. Also make sure that there is no ~/.my.cnf files in the user which is attempting to access the socket. If the socket configuration points to different locations then you should change these to be consistent with the one found in the server configuration. Inside the /etc/my.cnf or /etc/mysql/my.cnf there is a client and server configuration make sure both are consistent.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts