Find the answer to your Linux question:
Results 1 to 5 of 5
I have Suse 10.1 and mysql is installed but when i type mysql into the command line i get the following respones: mysql ERROR 2002 (HY000): Can't connect to local ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Aug 2006
    Posts
    59

    Having trouble using mysql


    I have Suse 10.1 and mysql is installed but when i type mysql into the command line i get the following respones:
    mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

    -If anyone could help me that would be greatly appreciated...
    Thanks,
    Tom

  2. #2
    Blackfooted Penguin daark.child's Avatar
    Join Date
    Apr 2006
    Location
    West Yorks
    Posts
    4,393
    Try doing,
    Code:
    #/etc/init.d/mysql start

  3. #3
    Just Joined!
    Join Date
    Aug 2006
    Posts
    59
    Thanks daark.child it worked

    Tom

  4. #4
    Blackfooted Penguin daark.child's Avatar
    Join Date
    Apr 2006
    Location
    West Yorks
    Posts
    4,393
    Quote Originally Posted by wickster
    Thanks daark.child it worked

    Tom
    Cool. To stop the mysql service, you would do
    Code:
    #/etc/init.d/mysql stop
    and to restart
    Code:
    #/etc/init.d/mysql restart
    The syntax applies to all Suse services and not just mysql.

  5. #5
    Just Joined!
    Join Date
    Oct 2006
    Posts
    4
    yep, but correct me if I'm wrong - I think that is only a temporary fix and will need to be done every time you reboot your machine unless you redo your setup and configure mysql to start on boot.

Posting Permissions

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