Tiny Core Linux

Tiny Core Extensions => TCE Q&A Forum => Topic started by: q7x on October 23, 2009, 04:33:11 AM

Title: mysql compile error
Post by: q7x on October 23, 2009, 04:33:11 AM

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)”

Title: Re: mysql compile error
Post by: q7x on October 23, 2009, 04:37:04 AM

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)

Title: Re: mysql compile error
Post by: bmarkus on October 24, 2009, 02:59:30 AM

mysql daemon is not running.

Title: Re: mysql compile error
Post by: q7x on October 24, 2009, 03:16:53 AM

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)

Title: Re: mysql compile error
Post by: q7x on October 24, 2009, 03:20:13 AM

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

Title: Re: mysql compile error
Post by: bmarkus on October 24, 2009, 03:20:26 AM

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.

Title: Re: mysql compile error
Post by: q7x on October 24, 2009, 03:31:17 AM

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

Title: Re: mysql compile error
Post by: q7x on October 24, 2009, 03:33:24 AM

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

Title: Re: mysql compile error
Post by: bmarkus on October 24, 2009, 11:44:22 AM

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

Title: Re: mysql compile error
Post by: q7x on October 24, 2009, 02:53:03 PM

what is your mysql version?

Title: Re: mysql compile error
Post by: q7x on October 24, 2009, 05:25:16 PM

solved thanks

Title: Re: mysql compile error
Post by: rebelj12a on January 03, 2011, 07:37:41 PM

How was this solved? Getting this error right now.