mysql installation quickie

Anon

Hey all,
Installed the mysql -3.23.43 source on redhat 6.2. The configure, make, and make install went off without a hitch. I then proceeded to make the temp tables with /usr/local/mysql/bin/./mysql_install_db, and that went off without a hitch as well. Now, when I attempt to start the server, with ->mysql i get a

Error 2002: Cant connect to a local mysql server through socket 'tmp/mysql.sock'(111)'

I dont really know what to do, any help would be appreciated to get this up and running!
Thanks

nashirak

Found your answer right here

http://www.e-gineer.com/instructions/install-mysql3xx-on-linux.phtml

Inclosed is the answer to your problem:

For all of you who get this error "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'.
Check that mysqld is running and that the socket: '/tmp/mysql.sock exists"..... I would try this, it worked for me,
run these commands updatedb; locate mysql.sock it should show you something like /var/lib/mysql/mysql.sock
now type MYSQL_UNIX_PORT=/var/lib/mysql/mysql.sock this tells mysql to use the mysql.sock in the
/var/lib/mysql directory by default its checking for /tmp/mysqld.sock now type export MYSQL_UNIX_PORT
then go back to your mysql directory and do bin/safe_mysqld & and finally you should be able to
bin/mysqladmin ping showing you mysqld is alive note: when you reboot your machine this setting will be lost,
to fix this do this edit /etc/profile and add the line MYSQL_UNIX_PORT=/var/lib/mysql/mysql.sock
somewhere near the top then look down to the end of this file and you'll probably see a line that starts
something like export PATH USER blah blah change this so it it has MYSQL_UNIX_PORT on the end, so it
may look like this now export PATH USER MYSQL_UNIX_PORT now when you restart and load mysql is
should work fine hope this helps Gareth

 -- Gareth Hastings (Sep 10, 2001 19:30:58)

Anon

Nahirak,
I had the same problem when installing mod_auth_mysql-2.20
using apache_1.3.20, mysql-3.23.41, and redhat 7.1
until I used the following configuration options:

mod_auth_mysql:
./configure --with-mysql=/usr/local/mysql
--with-apache=/usr/local/apache

apache:
./configure --activate-module=src/modules/php4/libphp4.a
--activate-module=src/modules/auth_mysql/libauth_mysql.a

--enable-module=most --enable-shared=max
--enable-module=so --enable-module=rewrite
--enable-shared=rewrite

I think that the enabling options are the important
part of the configuration.