[ale] mySQL from scratch

[Mike Lockhart]

do a "locate mysql.sock", it's probably in /var or somthing, or try
"find / -name mysql.sock".  When you find it, do mysql -S
/path/to/mysql.sock -u root.  As a longterm solution, find the example
my.cnf in /usr/local/mysql and put it in /etc, add in the config line
for the socket file (you can find that on mysql.com's help section) and
restart mysql.

On Fri, 2002-09-20 at 12:14, ChangingLINKS.com wrote:
> I made the change that you suggested, and still got the same error:
> 
> [root at computer root]# mysql -u root
> ERROR 2002: Can't connect to local MySQL server through socket 
> '/tmp/mysql.sock' (2)
> 
> 
> On Friday 20 September 2002 10:07, you wrote:
> After the you set PATH in /etc/profile, add a line below it that says
> "export $PATH"
> 
> On Fri, 2002-09-20 at 02:36, ChangingLINKS.com wrote:
> > ale, 09-20-02 0229
> > I am having a hard time "starting" mySQL. I went through the following 
> > process;
> > MYSQL
> > rpm -e mysql (kill each dependency first)
> > groupadd mysql
> > useradd -g mysql mysql
> > cd /usr/local
> > ln -s /usr/local/mysql-max-3.23.52-pc-linux-gnu-i686 mysql
> > tar xvzf mysql-max-3.23.52-pc-linux-gnu-i686.tar.gz
> > cd mysql-max-3.23.52-pc-linux-gnu-i686
> > vim /etc/profile 
> >  add at the end -> PATH=$PATH:/usr/local/mysql/bin
> > vim /etc/ld.so.conf 
> >  add "/usr/local/mysql/lib"
> > ldconfig
> >          ./configure --prefix=/usr/local/mysql ERROR says binary 
> installation
> >          make                                  "   "
> >          make install                          "   " 
> > scripts/mysql_install_db
> > chown -R root  /usr/local/mysql
> > mkdir var
> > chown -R mysql /usr/local/mysql/var
> > chgrp -R mysql /usr/local/mysql
> > cp support-files/my-medium.cnf /etc/my.cnf
> > vim /etc/my.cnf  
> >  remove "#" before InnoDB lines
> > /usr/local/mysql/bin/safe_mysqld --user=mysql &
> > 
> > >>>>>>>>I get these errors:
> > 
> > [root at computer mysql-max-3.23.52-pc-linux-gnu-i686]# 
> > /usr/local/mysql/bin/safe_mysqld --user=mysql &
> > [1] 1994
> > [root at computer mysql-max-3.23.52-pc-linux-gnu-i686]# Starting mysqld daemon 
> > with databases from /usr/local/mysql-max-3.23.52-pc-linux-gnu-i686/data
> > 020920 02:29:20  mysqld ended
> > 
> > [root at computer mysql-max-3.23.52-pc-linux-gnu-i686]# mysql -u root
> > bash: mysql: command not found
> > 
> > >>>>>>>>>I try to start it from the directory.
> > [root at computer bin]# ./mysql -u root
> > ERROR 2002: Can't connect to local MySQL server through socket 
> > '/tmp/mysql.sock' (111)
> > -- 
> > Wishing you Happiness, Joy and Laughter,
> > Drew Brown
> > http://www.ChangingLINKS.com
> > 
> > ---
> > This message has been sent through the ALE general discussion list.
> > See http://www.ale.org/mailing-lists.shtml for more info. Problems should 
> be 
> > sent to listmaster at ale dot org.
> > 
> -- 
> 
> ================================
> Michael Lockhart - PHP Developer
> Intercosmos Media Group
> mailto:mlockhart at intercosmos.com
> http://orbital.intercosmos.net
> ================================
> 
> 
> -- 
> Wishing you Happiness, Joy and Laughter,
> Drew Brown
> http://www.ChangingLINKS.com
> 
-- 

================================
Michael Lockhart - PHP Developer
Intercosmos Media Group
mailto:mlockhart at intercosmos.com
http://orbital.intercosmos.net
================================

 This is a digitally signed message part