Results 1 to 8 of 8

Thread: MySQL Problem

  1. #1

    Red face MySQL Problem

    Hi all,
    I am using Suse 11.1 and the standard package of MySQL along with it. But when I run mysql it is giving me error
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    I am new to suse that is why I could not sought it out. Perhaps MySQL server is not running. I it is so, How to run it??

    Please help me.

    Thanks

  2. #2

    Default Re: MySQL Problem

    try rcmysql status to see if the process is running.

    if it isnt... rcmysql start

  3. #3
    Camalen NNTP User

    Default Re: MySQL Problem

    waheed2008 wrote:

    > Hi all,
    > I am using Suse 11.1 and the standard package of MySQL along with it.
    > But when I run mysql it is giving me error
    >>
    >> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
    >> '/var/lib/mysql/mysql.sock' (2)
    >>

    > I am new to suse that is why I could not sought it out. Perhaps MySQL
    > server is not running. I it is so, How to run it??


    You can start mysql service by opening a terminal and running (as
    root): "rcmysql start"

    Greetings,

    --
    Camalen

  4. #4
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,454

    Default Re: MySQL Problem

    Go to YaST>System>System Services and check mysqld for a permanent solution.

  5. #5
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,686
    Blog Entries
    4

    Default Re: MySQL Problem

    BTW, check that you haven't got a factory version of mysql, I have seen that a couple of people got caught by this because they enabled every repo in sight. Do:

    rpm -q mysql

    It should be version 5.0.x, not 5.1.x.

  6. #6

    Default Re: MySQL Problem

    Thanks a lot for all of your valueable responses. I have used
    $ rcmysql start
    command to start it. I also opened up Yast and set the mysql tu run level 2, 3, & 5. Thanks

    I want to ask a general question. I have use RedHad-9 and in that, I used to start it through "service mysql start". Why different flavours use changed basic application commands.
    Perhaps this is a nonsense question , but it sometimes confused me.

  7. #7
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,686
    Blog Entries
    4

    Default Re: MySQL Problem

    "service" is a Redhat-ism. The standard way which works with all distros is actually

    /etc/init.d/mysql start

    Remember this if you ever have to take any Linux exams. "rcmysql start" is a SUSE-ism. However as a shortcut it's more useful than "service mysql start" because you can use TAB completion after the rc.

  8. #8

    Default Re: MySQL Problem

    Thank you so much for this explanation.
    Have a nice day

Posting Permissions

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