Installation and config of MYSQL

[Sridhar Reddy]

Hi,
Need help. Installed Mysql in Redhat 9.0 workstation.
I have installed MYSQL,Appache,P HP.
PHP,Appache installation is fine and intergration is also working fine.
I have installed and configured MYSQL
Problem : I cannot log into MYSQL database either from root or user.(local host)

The error is 2002: unable to connect to local host thru socket "\var\lib\mysoc "
but cannot locate the mysql.sock in /tmp
And the service is sqldb is also not working and cannot locate in services

sridhar

[d@t@]

Re: Installation and config of MYSQL

Check your /etc/my.cnf for socket file location
--
Jay

http://d2t2fish.blogspot.com

Sridhar Reddy wrote:[color=blue]
> Hi,
> Need help. Installed Mysql in Redhat 9.0 workstation.
> I have installed MYSQL,Appache,P HP.
> PHP,Appache installation is fine and intergration is also working[/color]
fine.[color=blue]
> I have installed and configured MYSQL
> Problem : I cannot log into MYSQL database either from root or[/color]
user.(local host)[color=blue]
>
> The error is 2002: unable to connect to local host thru socket[/color]
"\var\lib\mysoc "[color=blue]
> but cannot locate the mysql.sock in /tmp
> And the service is sqldb is also not working and cannot locate in[/color]
services[color=blue]
>
> sridhar[/color]

[Bill Karwin]

Re: Installation and config of MYSQL

Sridhar Reddy wrote:[color=blue]
> The error is 2002: unable to connect to local host thru socket "\var\lib\mysoc "
> but cannot locate the mysql.sock in /tmp
> And the service is sqldb is also not working and cannot locate in services[/color]

I have experienced this error most often when the MySQL server failed to
start. There needs to be a mysqld process running, even if you are
connecting to databases locally.

Start on this page for troubleshooting tips:

http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html

FWIW, I usually have to do some number of MySQL server restarts when I
install it on Linux.

Regards,
Bill K.