SEO

Hi all
you have probably had this question a few times
I have installed mysql-3.23.56 as it has been said in the Docs, but ...
I keep on getting this error
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.
--

Thanks
Night Owl

Nightowl wrote:

> Hi all
> you have probably had this question a few times
> I have installed mysql-3.23.56 as it has been said in the Docs, but ...
> I keep on getting this error
> 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.
> --
>
> Thanks
> Night Owl

Is your MySQL server running?

Best,
Merl

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...

--

Thanks

Craig Perrett | Technical Support | storm
T + 27 (0)8600 600 60 | F + 27 (0)21 447 8044 | C + 27 (0)83 236 6588
www.storm.co.za


"Merlin" <merlin_the_wizzard@camelot.com> wrote in message
news:56Dcb.1834688$Bf5.263806@news.easynews.com...
Nightowl wrote:

> Hi all
> you have probably had this question a few times
> I have installed mysql-3.23.56 as it has been said in the Docs, but ...
> I keep on getting this error
> 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.
> --
>
> Thanks
> Night Owl

Is your MySQL server running?

Best,
Merl

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Nightowl wrote:
| 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...
|

permisson to the dir /usr/local/var are not set correctly, do a change
mode as follow:

# chown -R mysql /usr/local/var

and try to restart the server again, it should work now.

- --

"The significant problems we face cannot be solved at the same level of
thinking we were at when we created them."
- Albert Einstein (1879-1955)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/cxAJ1bXyj+2X4JERAsVkAKCCjjVkL62QHTut2Ah5GBgRk4Uz2w CeNALu
rWAOy+S5FYhAwgApChc1G0w=
=DqT1
-----END PGP SIGNATURE-----

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

Great thanks... that was very easy...
she is alive.. )

--


"Wong Kum Weng" <jinrong@bigfoot.com> wrote in message
news:3f730f45@news.starhub.net.sg...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Nightowl wrote:
| 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...
|

permisson to the dir /usr/local/var are not set correctly, do a change
mode as follow:

# chown -R mysql /usr/local/var

and try to restart the server again, it should work now.

- --

"The significant problems we face cannot be solved at the same level of
thinking we were at when we created them."
- Albert Einstein (1879-1955)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/cxAJ1bXyj+2X4JERAsVkAKCCjjVkL62QHTut2Ah5GBgRk4Uz2w CeNALu
rWAOy+S5FYhAwgApChc1G0w=
=DqT1
-----END PGP SIGNATURE-----

--
Thanks very much, that has helped me a lot...

"Merlin" <merlin_the_wizzard@camelot.com> wrote in message
news:uiEcb.98509$Ji7.861991@news.easynews.com...
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