MySQL Problem

[waheed2008]

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

[korvirlol]

try rcmysql status to see if the process is running.

if it isnt... rcmysql start

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,

--
Camaleón

[john_hudson]

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

[ken_yap]

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.

[waheed2008]

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.

[ken_yap]

"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.

[waheed2008]

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