Re: [gentoo-user] mysql start issues

[Francisco Rivas]

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 <rtorres827@×××××.com> wrote:
>
> OK.  I Unmerged and re-emerged mysql.
>
> # /etc/init.d/mysql stop
> # emerge -C mysql
> # tar cjpvf ~/mysql.$(date +%F"T"%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:dan@×××××××××.cx]
> Sent: Sunday, March 18, 2007 9:08 AM
> To: gentoo-user@l.g.o
> Subject: Re: [gentoo-user] mysql start issues
>
> On Sat, 17 Mar 2007 13:11:54 -0500
> "Richard Torres" <rtorres827@×××××.com> 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@g.o mailing list
>
> --
> gentoo-user@g.o 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 : fjrivas@××××××.ve
msn : taken2k4@×××××.com

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