Nightowl wrote:

<top-posting fixed>

>> root@fire:/usr/local/mysql# mysql
>> ERROR 2002: Can't connect to local MySQL server through socket
>> '/tmp/mysql.sock' (111)
>> the permissions are all correct that I can see. I am a newbie.
>
> Is your MySQL server running?

> Nop as soon as I try run
>
> root@fire:/var/lib/mysql# safe_mysqld
> Starting mysqld daemon with databases from /usr/local/var
> 030925 17:39:49 mysqld ended
>
> that is all that happens i try ps -ef and i cannot find the mysql
> running...

Have you ever started it (I mean, are the grant tables installed)? If not,
you need to run

mysql_install_db

first, then run

mysqladmin -u root password <type your new password here>
mysqladmin -u root -h localhost password <type your password here>

Then, type

safe_mysqld -user=root&

Now mysqld should start and you can type

mysql -u root -p

to connect to the server.

I think the info on useing mysqladmin is printed out when you install the
grant tables (mysql_install_db). Also, this question has been discussed
several times in this newsgroup several times, and Google will give you
several links. So, in case I got something wrong, google for an answer.

Best,
Merl