Hi all,

I have installed MySQL onto my RH 8 box from source. Here's what I did...

./configure --prefix=/usr --sysconfdir=/etc --libexecdir=/usr/sbin --localstatedir=/var/lib/mysql --with-mysql-user=mysql --enable-thread-safe-client --without-debug --without-bench &&
make &&
make install

All that went fine. Then, I ran:

mysql_install_db &&
chown -R mysql:mysql /var/lib/mysql

Next:

mysqld_safe 2>&1 >/dev/null &

Next:

mysql -uroot mysql which gave me:

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

Next:

mysqld &

Gave me:

[2] 16931
[root@goliath mysql-4.0.12]# Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
030608 23:25:54 Aborting

030608 23:25:54 mysqld: Shutdown Complete

Next:


mysqld_safe

Gave me:

Starting mysqld daemon with databases from /usr/var
030608 23:26:41 mysqld ended

Next:

ps -auxw | grep mysqld

Gives me:

root 1118 0.0 0.0 3276 628 pts/0 S 23:59 0:00 grep mysqld


Ok, bottom line. I do NOT know anything about MySQL. A friend of mine told me I wanted it to do some web stuff I wanna do, and I think he's right. He does not know what's going on and why this is not working. Could anyone please tell me how to get this up and running with PHP and apache integration? I would be eternally grateful! Thanks a million!!!

Chris

PS. And, please, don't be afraid to treat me like an idiot on this one. Like I said, MySQL = Greek to me!

did you leave out mysql_install_db

try that before running the server. i forgot exactly how to run it
but im sure it needs to be run at some point. i think that
is the command that sets up the mysql database and the test
database (the mysql database is VERY important).

Thanks for the reply. Yes, if you look in my original post, I already ran that. Can anyone thing of anything else? I can't even find info on Google about why this is not working. I really need to get this running! Thank you!!

Chris

Also, I am still trying to work on this on my own, and I have found out something interesting. When I run the command:

/usr/bin/mysqladmin -u root password 'new-password'

I get the following output:

/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

Well, mysqld is not running, but I checked on the /tmp/mysql.sock file anyway and it says:

mysql.sock: No such device or address

What it all mean, Basil?!?! lol

Please help!

Chris

the server has to be running for mysqladmin to work, when
u run it the sock file is created for you (or somethin like that). Youshould
have to mess with that.

mysqladmin needs to have the server running. mysql.sock will be there when mysqld is running.

you need a space between "-u" and "root" - is that how you ran it?

You need to change ownership of the working directory -

chown -R mysql:mysql /usr/mysqlxxx

Skye

You read the warnings about source compiles on RH systems, right? You might wanna just go with the binary.

Thanks guys. I figured it out. It was a user problem... I just had to reinstall the sourse after deleting and properly re-adding the mysql user... Simple. I figured it was something stupid!

Chris