mysql error

[Morgan Wesström]

thanos trompoukis wrote:
> Hi all, I am new with FreeBSD and I have a problem with mysql.
> 
> I have 6.2Release i386
> I am running mysql 5.0.27 and It worked perfectly until the time that I
> formated  /tmp (for some other reason)
> and now when I am trying to connect on mysql *I get this:*
> 
> *[root at leonidas:/]$ mysql
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/tmp/mysql.sock2' (38)*
> 
> *and when I edit /var/db/mysql/leonidas.MSHOME.err  I see this:*
> 
> *090628 14:49:19  mysqld started
> 090628 14:49:19 [Warning] Ignoring user change to 'ser=mysql' because the
> user was set to 'mysql' e
> 
> 090628 14:49:20  InnoDB: Started; log sequence number 0 43655
> 090628 14:49:20 [ERROR] Can't start server : Bind on unix socket: Permission
> denied
> 090628 14:49:20 [ERROR] Do you already have another mysqld server running on
> socket: /tmp/mysql.soc
> 090628 14:49:20 [ERROR] Aborting
> 
> 090628 14:49:20  InnoDB: Starting shutdown...
> 090628 14:49:22  InnoDB: Shutdown completed; log sequence number 0 43655
> 090628 14:49:22 [Note] /usr/local/libexec/mysqld: Shutdown complete
> 
> 090628 14:49:22  mysqld ended
> 
> *I have checked /tmp and there is no mysql.sock file. (because I formated
> /tmp immagine)
> I wouldn't like to loose my database, and I have no idea....
> What I have to do?
> 
> Thanx!  :D

Don't forget to chmod 1777 /tmp
/Morgan