MySQL installation problem on RedHat9

[DJ-Studd]

The following is what I receive when attempting to run mysql_install_db.

[root@webserver mysql]# mysql_install_db
Installing all prepared tables
040702 14:57:43  Warning: Asked for 196608 thread stack, but got 126976
040702 14:57:43  /usr/sbin/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h webserver password 'new-password'
See the manual for more instructions.

NOTE&#58;  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with&#58;
cd / ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory&#58;
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http&#58;//www.mysql.com
Support MySQL by buying support/licenses at https&#58;//order.mysql.com

&#91;root@webserver mysql&#93;#

How can I solve the error at the top and get mysql to create the tables, allowing me to launch it?

Thanks, it's been bugging me all day!
-- DJ

[DJ-Studd]

Hmm, I completely forgot...

If I do a ps aux | grep mysqld I get:
root 2659 0.0 0.1 3576 620 pts/0 S 15:06 0:00 grep mysqld

So, it looks like mysql is running.
If I try to do anything else with mysql I get

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

If I do /etc/init.d/mysql start, and do a ps aux | grep mysqld I'm presented with a dozen instances of mysqld.

Edit again!: Oh, and there is no file called mysql.sock in /var/lib/mysql

Thanks guys, this is really bugging me.
-- DJ

[DJ-Studd]

Yay!
After 2 hours of searching I found a solution!


http://www.sitepoint.com/forums/showthread.php?t=169912

I basically had to run:
ln -s /var/lib/mysql/mysql.sock mysql.sock

Weird
-- DJ