Re: [gentoo-user] mysql start issues
Hi... last month i had the same problem I was see a lot of posts in forums, this solution works for me: create a sym link yo mysqd.sock, it's something like this ln -vs /tmp/mysql.sock /var/run/mysql/mysql.sock for mysql 5.0.26-r2, that's work for me. It's important see the my.cnf at the line where mysql put the mysql.sock in my case : [client] password = ** port= 3306 socket= /var/run/mysqld/mysqld.sock $ls -l /tmp/mysql.sock /tmp/mysql.sock - /var/run/mysqld/mysqld.sock I hope that's work for you too. NOTE : Please excuse me for my english it's no so good, but I need to help everyone that i can...that make a better world.. Peace..:D On 3/19/07, Richard Torres [EMAIL PROTECTED] wrote: OK. I Unmerged and re-emerged mysql. # /etc/init.d/mysql stop # emerge -C mysql # tar cjpvf ~/mysql.$(date +%FT%H-%M).tar.bz2 /etc/mysql/my.cnf /var/lib/mysql/ # ls -l ~/mysql.* # rm -rf /var/lib/mysql/ /var/log/mysql # emerge -av dev-db/mysql It completed installing/compiling then.. # emerge --config =dev-db/mysql-5.0.32 Configuring pkg... * MySQL DATADIR is /var/lib/mysql * Previous datadir found, it's YOUR job to change * ownership and take care of it * Creating the mysql database and setting proper * permissions on it ... * Insert a password for the mysql 'root' user * Avoid ['\_%] characters in the password * Retype the password !!! ERROR: dev-db/mysql-5.0.32 failed. Call stack: ebuild.sh, line 1527: Called pkg_config ebuild.sh, line 1255: Called mysql_pkg_config mysql.eclass, line 805: Called die !!! MySQL databases not installed !!! If you need support, post the topmost build error, and the call stack if relevant. # /etc/init.d/mysql start * Starting mysql... * Starting mysql (/etc/mysql/my.cnf) * MySQL NOT started (0) Any ideas? -Original Message- From: Dan Farrell [mailto:[EMAIL PROTECTED] Sent: Sunday, March 18, 2007 9:08 AM To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] mysql start issues On Sat, 17 Mar 2007 13:11:54 -0500 Richard Torres [EMAIL PROTECTED] wrote: Hello, I'm having a trouble starting mysql since I emerged the newer version. 'mysqld.sock' doesn't exist and the logs aren't much help. Any help is greatly appreciated. -Richard # mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) # /etc/init.d/mysql start * Starting mysql... * Starting mysql (/etc/mysql/my.cnf) * MySQL NOT started (0) I had the same problem and my solution was found at : http://www.gentoo.org/doc/en/mysql-upgrading.xml .but I never did get my password-encoded columns back. good luck! -- gentoo-user@gentoo.org mailing list -- gentoo-user@gentoo.org mailing list -- ['Cause without love I won't survive, I love you]. I Francisco Rivas 2.6.19-gentoo-r5 x86 udev v087 gnome 2.16.2 xorg-x11-7.1 hotplug v20040923-r2 e-mail : [EMAIL PROTECTED] msn : [EMAIL PROTECTED] -BEGIN GEEK CODE BLOCK- Version: 3.1 GCS/E/IT/MU d-(+)@ s++: a-- C ULSC*()+++ P+(++)+++ L++(+++) !E--- W+++ !N* !o-(--)-- K--? !w--- !O !M !V PS@ !PE@ Y PGP t 5 X R++ tv- b DI D G e+ h- r+ y- --END GEEK CODE BLOCK--
Re: [gentoo-user] mysql start issues
On Mon, 19 Mar 2007 01:22:07 -0500 Richard Torres [EMAIL PROTECTED] wrote: Configuring pkg... * MySQL DATADIR is /var/lib/mysql * Previous datadir found, it's YOUR job to change * ownership and take care of it * Creating the mysql database and setting proper * permissions on it ... * Insert a password for the mysql 'root' user * Avoid ['\_%] characters in the password * Retype the password !!! ERROR: dev-db/mysql-5.0.32 failed. Call stack: ebuild.sh, line 1527: Called pkg_config ebuild.sh, line 1255: Called mysql_pkg_config mysql.eclass, line 805: Called die Any ideas? I am by no means a mysql expert, but the passwords got deleted, didn't they? # rm -rf /var/lib/mysql/ /var/log/mysql -- gentoo-user@gentoo.org mailing list
RE: [gentoo-user] mysql start issues
Yes. And I re-entered one at the prompts (). -Original Message- From: Dan Farrell [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 9:05 AM To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] mysql start issues On Mon, 19 Mar 2007 01:22:07 -0500 Richard Torres [EMAIL PROTECTED] wrote: Configuring pkg... * MySQL DATADIR is /var/lib/mysql * Previous datadir found, it's YOUR job to change * ownership and take care of it * Creating the mysql database and setting proper * permissions on it ... * Insert a password for the mysql 'root' user * Avoid ['\_%] characters in the password * Retype the password !!! ERROR: dev-db/mysql-5.0.32 failed. Call stack: ebuild.sh, line 1527: Called pkg_config ebuild.sh, line 1255: Called mysql_pkg_config mysql.eclass, line 805: Called die Any ideas? I am by no means a mysql expert, but the passwords got deleted, didn't they? # rm -rf /var/lib/mysql/ /var/log/mysql -- gentoo-user@gentoo.org mailing list -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] mysql start issues
Richard Torres wrote: Yes. And I re-entered one at the prompts (). It's telling you what the problem is - the database already exists (from your last install). Either just ignore the error or delete /var/lib/mysql/mysql and run emerge --config. again. Be lucky, Neil -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] mysql start issues
On Sat, 17 Mar 2007 13:11:54 -0500 Richard Torres [EMAIL PROTECTED] wrote: Hello, I'm having a trouble starting mysql since I emerged the newer version. 'mysqld.sock' doesn't exist and the logs aren't much help. Any help is greatly appreciated. -Richard # mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) # /etc/init.d/mysql start * Starting mysql... * Starting mysql (/etc/mysql/my.cnf) * MySQL NOT started (0) I had the same problem and my solution was found at : http://www.gentoo.org/doc/en/mysql-upgrading.xml ...but I never did get my password-encoded columns back. good luck! -- gentoo-user@gentoo.org mailing list
RE: [gentoo-user] mysql start issues
OK. I Unmerged and re-emerged mysql. # /etc/init.d/mysql stop # emerge -C mysql # tar cjpvf ~/mysql.$(date +%FT%H-%M).tar.bz2 /etc/mysql/my.cnf /var/lib/mysql/ # ls -l ~/mysql.* # rm -rf /var/lib/mysql/ /var/log/mysql # emerge -av dev-db/mysql It completed installing/compiling then.. # emerge --config =dev-db/mysql-5.0.32 Configuring pkg... * MySQL DATADIR is /var/lib/mysql * Previous datadir found, it's YOUR job to change * ownership and take care of it * Creating the mysql database and setting proper * permissions on it ... * Insert a password for the mysql 'root' user * Avoid ['\_%] characters in the password * Retype the password !!! ERROR: dev-db/mysql-5.0.32 failed. Call stack: ebuild.sh, line 1527: Called pkg_config ebuild.sh, line 1255: Called mysql_pkg_config mysql.eclass, line 805: Called die !!! MySQL databases not installed !!! If you need support, post the topmost build error, and the call stack if relevant. # /etc/init.d/mysql start * Starting mysql... * Starting mysql (/etc/mysql/my.cnf) * MySQL NOT started (0) Any ideas? -Original Message- From: Dan Farrell [mailto:[EMAIL PROTECTED] Sent: Sunday, March 18, 2007 9:08 AM To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] mysql start issues On Sat, 17 Mar 2007 13:11:54 -0500 Richard Torres [EMAIL PROTECTED] wrote: Hello, I'm having a trouble starting mysql since I emerged the newer version. 'mysqld.sock' doesn't exist and the logs aren't much help. Any help is greatly appreciated. -Richard # mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) # /etc/init.d/mysql start * Starting mysql... * Starting mysql (/etc/mysql/my.cnf) * MySQL NOT started (0) I had the same problem and my solution was found at : http://www.gentoo.org/doc/en/mysql-upgrading.xml .but I never did get my password-encoded columns back. good luck! -- gentoo-user@gentoo.org mailing list -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] mysql start issues
What related log files show about the error? (/var/log/mysql/*) They should give some info about the source of the error. Configuration error may exist in my.cnf . Richard Torres wrote: Hello, I’m having a trouble starting mysql since I emerged the newer version. ‘mysqld.sock’ doesn’t exist and the logs aren’t much help. Any help is greatly appreciated. -Richard # mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) # /etc/init.d/mysql start * Starting mysql... * Starting mysql (/etc/mysql/my.cnf) * MySQL NOT started (0)
RE: [gentoo-user] mysql start issues
This log doesn't change when I try to start mysql. # tail -f mysql.err 060411 14:23:42 mysqld started 060411 16:47:54 mysqld ended 060629 18:10:25 mysqld started 060703 16:58:17 mysqld ended 060806 08:30:54 mysqld started 060806 08:38:40 mysqld ended 061222 17:52:51 mysqld started # tail -f mysqld.err 070319 9:35:12 [Warning] './mysql/host' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed 070319 9:35:12 [Warning] './mysql/user' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed 070319 9:35:12 [Warning] './mysql/db' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed 070319 9:35:12 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format. _ From: Levent Duymuş [mailto:[EMAIL PROTECTED] Sent: Saturday, March 17, 2007 3:11 PM To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] mysql start issues What related log files show about the error? (/var/log/mysql/*) They should give some info about the source of the error. Configuration error may exist in my.cnf . Richard Torres wrote: Hello, I'm having a trouble starting mysql since I emerged the newer version. 'mysqld.sock' doesn't exist and the logs aren't much help. Any help is greatly appreciated. -Richard # mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) # /etc/init.d/mysql start * Starting mysql... * Starting mysql (/etc/mysql/my.cnf) * MySQL NOT started (0)
Re: [gentoo-user] mysql start issues
It seems that you have problems with mysql's privilege table. Try these: mysqld --skip-grant-tables --user=root (or try with --user=mysql) mysql_fix_privilege_tables pkill mysqld (kill all mysqld process until all of them killed) /etc/init.d/mysql_restart If still mysql cannot start l, please provide the related log lines again. Richard Torres wrote: This log doesn't change when I try to start mysql. # tail -f mysql.err 060411 14:23:42 mysqld started 060411 16:47:54 mysqld ended 060629 18:10:25 mysqld started 060703 16:58:17 mysqld ended 060806 08:30:54 mysqld started 060806 08:38:40 mysqld ended 061222 17:52:51 mysqld started # tail -f mysqld.err 070319 9:35:12 [Warning] './mysql/host' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed 070319 9:35:12 [Warning] './mysql/user' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed 070319 9:35:12 [Warning] './mysql/db' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed 070319 9:35:12 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format. *From:* Levent Duymuş [mailto:[EMAIL PROTECTED] *Sent:* Saturday, March 17, 2007 3:11 PM *To:* gentoo-user@lists.gentoo.org *Subject:* Re: [gentoo-user] mysql start issues What related log files show about the error? (/var/log/mysql/*) They should give some info about the source of the error. Configuration error may exist in my.cnf . Richard Torres wrote: Hello, I'm having a trouble starting mysql since I emerged the newer version. 'mysqld.sock' doesn't exist and the logs aren't much help. Any help is greatly appreciated. -Richard # mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) # /etc/init.d/mysql start * Starting mysql... * Starting mysql (/etc/mysql/my.cnf) * MySQL NOT started (0)