[DOC] Correct some error of mysql-server [Freebsd]

[DarknessMt2-Roxas]

Hello everybody, i share for a simple PDF with some fix for mysql-server on FreeBSD.

I think this pdf can help , so I share it.

Edit: Any version of mysql-server can have this bug.

-I traduce it in english. (Sorry for my worst english)




Source :

Cordialy, Roxas.

[.Shōgun]

fix for what? for which version? lol

[DarknessMt2-Roxas]

Any version can have this error, I edit my post.

[Mastermonkey]

Ah okay....

 Spoiler

If you obtain an error when you start mysql-server
like :
Another MySQL daemon already running with the same unix socket.
Fallow that :
1) At first, we need to delete file socket create by mysql-server

PHP Code:

rm -f /var/lib/mysql/mysql.sock 


2) Now, we try to stop then, if he started.

PHP Code:

service mysqld stop 


3) Give again permissions on mysql files.

PHP Code:

chown -R mysql:root /var/lib/mysql 


4) Restart Mysql-server

PHP Code:

service mysqld start 


Now the error is fixed, but can be return, so save this
pdf .
Cordialy Roxas.

I would never ever do this:

PHP Code:

chown -R mysql:root /var/lib/mysql 


If you do it, evil guys can get root access to your server when you start it as "root"-user and not as "mysql" user
So better do this:

PHP Code:

chown -R mysql:mysql /var/lib/mysql 


Over and out! Correct me if i am wrong :P