ok here is what happens when i try and start mysql i type [root@www admin]# /etc/rc.d/init.d/mysql start in shell and then i returns back with this
[root@www admin]# Starting mysqld daemon with databases from /home/mysql
010917 18:42:53 mysqld ended

I have no Idea why it is ending also i am having soket problems when i try to change my passwor din mysql or get into mysqadmin here is the error
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql
.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' ex
ists!

i have reinstalled mysql about 10 times and tried to change the defualt path for the .sock file but still no luck

anyone have a fix for this?

Is it trying to start as the "mysql" user? If so, does the user exist in your /etc/passwd file? Does your initial database(s) exist and does the mysql database directory have the correct permissions (owned by the user running the mysql server process)?

Have you run the program that sets up the initial database(s)? I forget what it is called off-hand, but I'm sure someone else can tell you.

Try www.mysql.com and visit their documents. Look for the Installation part, get that out of the way, then find the Setting Initial Permissions section and read it. They practically tell you step by step how to install and set things up.

Good luck. :)

Couple things to try or consider:

a. Move the databases out of their current directory and run the mysql_install_db script again.

b. What kind of installation are you doing? Are you on Red Hat 7.0? The RPM on the RH 7.0 CD does not work properly. Get a new one from the Red Hat or MySQL sites.

c. When the mysqld daemon starts up, it changes directory to the data directory. This is where it expects to write log files and the pid (process ID) file, and where it expects to find databases. The data directory location is hardwired in when the distribution is compiled. However, if mysqld expects to find the data directory somewhere other than where it really is on your system, it will probably abort.

Someone asked this exact same question within the last few weeks (I am almost positive), and I found the answer by searching the mysql site.

Also try: http://www.webhostingtalk.com/search.php?s=&action=showresults&searchid=112399&sortby=lastpost&sortorder=descending