Dear all:
As title, I’ve installed openSUSE 11.1 (32/64 bit version) smoothly.
But after then I type #mysql in terminal try to login mysql, it showed as below:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
I’d install on 32/64 bit x86 PC and even VMware client,
but it still showed such message to me.
Can anyone tell me what’s the reason for?
Thanks.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Is MySQL (the server) installed? Is it running? Is there a database
created (if a new RDBMS instance MySQL typically creates a default set
of databases)? Which version of MySQL? Can you login from another box
(which would require an open port in MySQL and an unblocked port by
relevant firewalls)?
Good luck.
Morse b lin wrote:
> Dear all:
>
> As title, I’ve installed openSUSE 11.1 (32/64 bit version) smoothly.
>
> But after then I type #mysql in terminal try to login mysql, it showed
> as below:
> ERROR 2002 (HY000): Can’t connect to local MySQL server through socket
> ‘/var/lib/mysql/mysql.sock’ (2)
>
> I’d install on 32/64 bit x86 PC and even VMware client,
> but it still showed such message to me.
>
> Can anyone tell me what’s the reason for?
>
> Thanks.
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJWioW3s42bA80+9kRAuYjAJ0ZEJRsxNZ4BkaB3anMbHjrRiNS3ACeOxfC
k6ASWWI4f8Bip5lsQn8Z9Kg=
=S9m2
-----END PGP SIGNATURE-----
I’m having the exact same issue. I’ve spent many hours trying to find a solution. I’ll be really interested in seeing what you come up with…Thanks for posting.
One possible explanation is that msyqld is not running; you can start this manually but the best way is to go to YaST>System>System services and ensure that mysql and apache are checked. Then both will start whenever you login. (In my experience neither of these are checked in a fresh openSUSE install).
Absolutely beautiful. That fixed it for me. Many thanks!
Many thanks for all of you.
It’s working now, I’ve forgot to check the system service. :shame:
I’ve tried many different kind of Linux these days. :
Some kind of the Linuxs’ Mysql is run directly when system boot up. :X
Anyway, thanks again and have a happy new year !! rotfl!
Morse from Taiwan.
Still not working for me. I’m using a fresh install of opensuse 11.1, I did a plain vanilla install of MYSQL using YAST. I start the service, it says successful but when I refresh status I get:
/etc/init.d/mysql status returned 1 (program is dead and /var/run pid file exists):
I’ve un-installed and re-installed.
I suspect it might be some kind of permissions issue… when I issue a mysql restart, it returns the following:
Restarting service multi MySQL
Shutting down service multi MySQL WARNING: Log file disabled. Maybe directory or file isn’t writable?
mysqld_multi log file version 2.16; run: Tue Feb 10 13:49:06 2009
Stopping MySQL servers
done
Starting service multi MySQL WARNING: Log file disabled. Maybe directory or file isn’t writable?
mysqld_multi log file version 2.16; run: Tue Feb 10 13:49:06 2009
Starting MySQL servers
Any ideas? Again, this is out of the box install, mysql directly from YAST.
I’m not sure why mysql_multi is running but you need to edit mysql.conf to start logfiles.
Ignore the previous comment; it’s my.conf. If you haven’t got a copy in /etc, there are samples in /usr/share/mysql which you can select, edit and then copy to /etc.
mysql_multi should not be running in a standard setup; I presume you have edited /etc/sysconfig/mysql to start it, in which case you probably need to edit /usr/share/mysql/my-large.conf and copy it to /etc as my.conf
Otherwise, edit /etc/sysconfig/mysql to turn it off and see what happens.
Wow! That did it, finally! Thanks
A fresh my.cnf did the trick.