Mysql not started (error 2002)

R

rubijn

I'm trying to install mysql 5.1 on ovh server (FreeBSD 6.2). The install via /usr/ports/database/mysql51-server/ was ok.

But when i start the server
/usr/local/etc/rc.d/mysql-server start
I have no error message but in fact my server doesn't start.

When i try mysql i have
error 2002: can't connect to local mysql....

and in the log file
[ERROR] Can't start server : Bind on unix socket: Permission den
ied
[ERROR] Do you already have another mysqld server running...

I have no process mysqld or other in process list ?

If someone could you help me.

Thanks
 
You might consider running mysql_install_db manually, if you already haven't. It sounds like there's a permission problem with /var/db/mysql -- is the mysql user able to read/write to this directory?

I realize that the rc script should automatically call mysql_install_db, but I swear it wasn't magically working for me a couple months ago. (Once you've got it working, make sure to clear out the default users and stuff).
 
hark said:
You might consider running mysql_install_db manually, if you already haven't. It sounds like there's a permission problem with /var/db/mysql -- is the mysql user able to read/write to this directory?

I realize that the rc script should automatically call mysql_install_db, but I swear it wasn't magically working for me a couple months ago. (Once you've got it working, make sure to clear out the default users and stuff).
Click to expand...

i try mysql_install_db but again some errors
Installing MySQL system tables...
ERROR: 1136 Column count doesn't match value count at row 1
081229 20:32:16 [ERROR] Aborting

The user mysql have rwx in all /var/db/mysql/ ?

I have mysql_enable in /etc/rc.conf and when i test
/usr/local/etc/rc.d/mysql-server rcvar it find the
mysql_enable = YES...

I'm a little bit lost...
 
You might try nuking /var/db/mysql with rm -rf, then re-running mysql_install_db. Obviously, if you're upgrading a MySQL instance, this will delete all your data (though you should have backed it all up before upgrading).
 
r-c-e said:
What does the error log have to say? Located in your datadir.
Click to expand...

where is this log file your talking about ?
in /var/db/mysql/myserver.err
I have this lines

081229 21:25:46 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
^G/usr/local/libexec/mysqld: Can't create/write to file '/var/tmp/ib0ecLIJ' (Errcode: 13)
081229 21:25:46 InnoDB: Error: unable to create temporary file; errno: 13
081229 21:25:46 [ERROR] Plugin 'InnoDB' init function returned error.
081229 21:25:46 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
081229 21:25:46 [ERROR] Can't start server : Bind on unix socket: Permission den
ied
081229 21:25:46 [ERROR] Do you already have another mysqld server running on soc
ket: /tmp/mysql.sock ?
081229 21:25:46 [ERROR] Aborting

081229 21:25:46 [Note] /usr/local/libexec/mysqld: Shutdown complete

081229 21:25:46 mysqld_safe mysqld from pid file /var/db/mysql/
xxxx.pid ended

when i try to start mysql
 
hark said:
You might try nuking /var/db/mysql with rm -rf, then re-running mysql_install_db. Obviously, if you're upgrading a MySQL instance, this will delete all your data (though you should have backed it all up before upgrading).
Click to expand...

I try (it's a new server no db to backup)... But without success i have again error 2002 and i can't start mysql..
 
rubijn said:
^G/usr/local/libexec/mysqld: Can't create/write to file '/var/tmp/ib0ecLIJ' (Errcode: 13)
081229 21:25:46 [ERROR] Can't start server : Bind on unixsocket: Permission denied
Click to expand...

This is the reason the mysql server won't start.

What are the permissions on /var/tmp and /tmp directories? Does the user mysql have write access to /tmp and /var/tmp?

Do /var/tmp/ib0ecLIJ or /tmp/mysql.sock already exsist?
 
You must log in or register to reply here.
Back
Top