0
I have been trying to start mysql server but got this error:
Can't start server : Bind on unix socket: Operation not permitted
2013-10-21 13:53:54 25098 [ERROR] Do you already have another mysqld server running on socket: [my-home-dir]/mysql-server/mysql.socket ?
I have searched all pages on google on this topic and have tried all methods, but have no luck.
So here are some more details. I do not have root access on the computer. What I do is install mysql server on my local directory. My my.cnf file looks like this:
[mysqld]
basedir = ~/mysql ## mysql unzipped files
datadir = ~/mysql-server/data
port = 3666
socket = ~/mysql-server/mysql.socket
user = my-ubuntu-user-name
My installation steps are:
- Unzip the source code distribution of mysql 5.6 to ~/mysql
- Create my.cnf as I showed above.
Initialize the server. This step does not show error.
./scripts/mysql_install_db --defaults-file=my.cnf --user=my-ubuntu-user --datadir=~/mysql-server/data --basedir=~/mysql --socket=~/mysql-server/mysql.socket
Start the server
./bin/mysqld --defaults-file=my.cnf
And hence comes the error:
Can't start server : Bind on unix socket: Operation not permitted 2013-10-21 13:53:54 25098 [ERROR] Do you already have another mysqld server running on socket: [my-home-dir]/mysql-server/mysql.socket ?
Also, I have 755 access on all folders related. Any suggestions would be helpful!
---Update
- netstat gives no processes on 3666 running.
- no process called mysql is currently running.
do you get any output from
netstat -tlup | grep 3666
– Frank Thomas – 2013-10-21T20:32:25.277Is mysql running?
ps -ef|grep mysql|grep -v grep
will tell you. 755 won't let you write if you're not the owner. Check who is the owner of~/mysql-server/
withls -ld ~/mysql-server/
andls -ld ~/mysql-server/mysql.socket
. – Calimo – 2013-10-21T20:54:56.517