Very Computer

by **Patrick McDonnel** » Wed, 01 Jan 2003 07:22:14

With Redhat 8.0 on a AMD Duron machine, trying to start the MySQL client
(to log in on my local server) and it says:

ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)

I've tried compiling MySQL from source, using binaries and RPMs. I've
also tried older versions of MySQL (currently using 3.23.53). Does
anyone know how to fix this problem?

by **jim brow** » Fri, 03 Jan 2003 21:30:34

Are you sure MySQL is running? netstat -a in a terminal window
should show MySQL running near the beginning of the list.
In GNOME, if you select "the RedHat" / server settings / services,
you get a list of servers. I found that mysqld was not checked and so
did not start automatically. CHecking this solved this part of the
problem for me. I still can't get ODBC working with MySQL.

I'm new to this so this may not help.

> With Redhat 8.0 on a AMD Duron machine, trying to start the MySQL client
> (to log in on my local server) and it says:

> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)

> I've tried compiling MySQL from source, using binaries and RPMs. I've
> also tried older versions of MySQL (currently using 3.23.53). Does
> anyone know how to fix this problem?

by **Patrick McDonnel** » Sat, 04 Jan 2003 03:57:55

> Are you sure MySQL is running? netstat -a in a terminal window
> should show MySQL running near the beginning of the list.
> In GNOME, if you select "the RedHat" / server settings / services,
> you get a list of servers. I found that mysqld was not checked and so
> did not start automatically. CHecking this solved this part of the
> problem for me. I still can't get ODBC working with MySQL.

Yes, stupid mistake. I had thought I restarted mysqld, but I executed
the wrong command. Sorry.

> I'm new to this so this may not help.

>> With Redhat 8.0 on a AMD Duron machine, trying to start the MySQL
>> client (to log in on my local server) and it says:

>> ERROR 2002: Can't connect to local MySQL server through socket
>> '/var/lib/mysql/mysql.sock' (2)

>> I've tried compiling MySQL from source, using binaries and RPMs. I've
>> also tried older versions of MySQL (currently using 3.23.53). Does
>> anyone know how to fix this problem?

by **And** » Sun, 05 Jan 2003 05:47:36

> > Are you sure MySQL is running? netstat -a in a terminal window
> > should show MySQL running near the beginning of the list.
> > In GNOME, if you select "the RedHat" / server settings / services,
> > you get a list of servers. I found that mysqld was not checked and so
> > did not start automatically. CHecking this solved this part of the
> > problem for me. I still can't get ODBC working with MySQL.

> Yes, stupid mistake. I had thought I restarted mysqld, but I executed
> the wrong command. Sorry.

> > I'm new to this so this may not help.

> >> With Redhat 8.0 on a AMD Duron machine, trying to start the MySQL
> >> client (to log in on my local server) and it says:

> >> ERROR 2002: Can't connect to local MySQL server through socket
> >> '/var/lib/mysql/mysql.sock' (2)

> >> I've tried compiling MySQL from source, using binaries and RPMs. I've
> >> also tried older versions of MySQL (currently using 3.23.53). Does
> >> anyone know how to fix this problem?

Patrick,
I think you are almost there.
Did you check your security setup? You must open up a port for the
ODBC connection and allow your computer to talk to the remote MySQL
server.
Login as the root user and use your system tools to change your
security setting to allow ODBC traffic. I prefer using the consol
program lokkit.
Get into a console and type lokkit.
Hopefully, this will help.

Very Computer

MySQL Problem

MySQL Problem

MySQL Problem

MySQL Problem

MySQL Problem