mysql compile error

[q7x]

after compile and execute mysql In command line I would get “ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)”

[q7x]

i've compile mysql in tc with :
addgroup mysql
adduser -G mysql mysql
./configure --prefix=/usr/local/mysql
make
make install
cp support-files/my-medium.cnf /etc/my.cnf
cd /usr/local/mysql
chown -R mysql .
chgrp -R mysql .
bin/mysql install_db --user=mysql
after last command i get this error:

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

[bmarkus]

mysql daemon is not running.

[q7x]

after run bin/mysqld_safe

091024 15:23:07 mysqld_safe Logging to '/usr/local/mysql/var/box.err'.
091024 15:23:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
091024 15:23:07 mysqld_safe mysqld from pid file /usr/local/mysql/var/box.pid ended


bin/mysql install_db --user=mysql

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

[q7x]

cat var/box.err

091024 15:22:44 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var/usr/local/mysql/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
091024 15:22:44 [ERROR] Aborting

091024 15:22:44 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

091024 15:22:44 mysqld_safe mysqld from pid file /usr/local/mysql/var/box.pid ended
091024 15:23:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var/usr/local/mysql/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
091024 15:23:07 [ERROR] Aborting

091024 15:23:07 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

091024 15:23:07 mysqld_safe mysqld from pid file /usr/local/mysql/var/box.pid ended

[bmarkus]

Most probably configuration error. Log files, error messages and studying sample config and docs may help as well as to analyze how is it working on another system where it is preinstalled.

[q7x]

i used only these command for compile mysql

unzip mysql-5.1.39.zip
cd mysql-5.1.39
addgroup mysql
adduser -G mysql mysql
./configure --prefix=/usr/local/mysql
make
make install
cp support-files/my-medium.cnf /etc/my.cnf
cd /usr/local/mysql
chown -R mysql .
chgrp -R mysql .
bin/mysql install_db --user=mysql

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)



bin/mysqld_safe

091024 15:23:07 mysqld_safe Logging to '/usr/local/mysql/var/box.err'.
091024 15:23:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
091024 15:23:07 mysqld_safe mysqld from pid file /usr/local/mysql/var/box.pid ended




cat var/box.err

091024 15:22:44 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var/usr/local/mysql/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
091024 15:22:44 [ERROR] Aborting

091024 15:22:44 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

091024 15:22:44 mysqld_safe mysqld from pid file /usr/local/mysql/var/box.pid ended
091024 15:23:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var/usr/local/mysql/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
091024 15:23:07 [ERROR] Aborting

091024 15:23:07 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

091024 15:23:07 mysqld_safe mysqld from pid file /usr/local/mysql/var/box.pid ended

[q7x]

Mr bmarkus  do you use another method for compile mysql?another commands?

[bmarkus]

I will post mysql in few days. It is working on my machine, need some cleanup and testing.

[q7x]

what is your mysql version?

[q7x]

solved thanks

[rebelj12a]

How was this solved? Getting this error right now.