Hi - I'm using SuSE 8.0. I've used YAST2 to install the MySQL packages. I tried running the safe_mysqld script as root but it wouldn't work because I'd forgotten to set up the mysql tables with mysql_install_db. So I run mysql_install_db and the tables all seem correctly set up in /var/lib/mysql. But now I get another error. My mysqld.log reads like this : 020922 10:24:25 mysqld started 020922 10:24:25 Can't start server : Bind on unix socket: Permission denied 020922 10:24:25 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 020922 10:24:25 Aborting 020922 10:24:25 /usr/sbin/mysqld: Shutdown Complete 020922 10:24:25 mysqld ended Well, I don't have a mysql.sock anywhere on my system, nor is there any instance of mysql running. It seems like a permissions problem, but I'm running safe_mysqld as root. Other ways of starting mysql (eg rcmysql start) fail equally. Can anyone tell me what I need to do to start the mysql server? - Ken
On Sun, 2002-09-22 at 10:19, Kenneth Payne wrote:
Hi -
I'm using SuSE 8.0. I've used YAST2 to install the MySQL packages. I tried running the safe_mysqld script as root but it wouldn't work because I'd forgotten to set up the mysql tables with mysql_install_db.
So I run mysql_install_db and the tables all seem correctly set up in /var/lib/mysql. But now I get another error. My mysqld.log reads like this :
020922 10:24:25 mysqld started 020922 10:24:25 Can't start server : Bind on unix socket: Permission denied 020922 10:24:25 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 020922 10:24:25 Aborting
020922 10:24:25 /usr/sbin/mysqld: Shutdown Complete
020922 10:24:25 mysqld ended
Well, I don't have a mysql.sock anywhere on my system, nor is there any instance of mysql running. It seems like a permissions problem, but I'm running safe_mysqld as root. Other ways of starting mysql (eg rcmysql start) fail equally.
Can anyone tell me what I need to do to start the mysql server?
You don't need to run safe_mysqld manually. When you installed the mysql package, it created a system startup script in /etc/init.d/mysql for you. That script runs safe_mysqld after checking the system setup and a few other things. The first time you start the mysql service with the system script, it should create the system tables and unix socket file (mysql.sock) for you all with the correct permissions. The normal way to start the service is this... rcmysql start and to stop it... rcmysql stop Best Regards, Keith -- LPIC-2, MCSE, N+ Once in a moment, it all comes to you As soon as you get it, you want something new Got spam? Get spastic http://spastic.sourceforge.net
Keith - Thanks for your interest in my problem. You have solved it. I had already tried using rcmysql to start mysql but it failed with the same error. However, your post told me that it creates the system tables as well. When I tried it, and it failed, the system tables already existed. So I deleted all the stuff in /var/lib/mysql and tried again. This time it worked. Thanks again. Best wishes - Ken On Sunday 22 September 2002 16:10, Keith Winston wrote:
You don't need to run safe_mysqld manually. When you installed the mysql package, it created a system startup script in /etc/init.d/mysql for you. That script runs safe_mysqld after checking the system setup and a few other things. The first time you start the mysql service with the system script, it should create the system tables and unix socket file (mysql.sock) for you all with the correct permissions.
The normal way to start the service is this...
rcmysql start
and to stop it...
rcmysql stop
Best Regards, Keith
participants (2)
-
Keith Winston
-
Kenneth Payne