Just a couple of things that may or may not be over simpistic, but if you
insert the information manually you will need to reload the tables using
mysqladmin or by restarting the mysql server in order for the changes to
take play. You did not mention doing this so I thought I would double check.
Also, make sure the sock file exists where it is looking. I have ran into
situations where the config file was modified and the server was looking in
the wrong location for a file.
Last, I don't know if it makes a difference, but I seldomly use -h localhost
on my system it defaults to this. This should not change anything though.
Chad
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> Bob Hartung
> Sent: Wednesday, May 31, 2000 6:16 PM
> To: [EMAIL PROTECTED]
> Subject: Problem connecting to mysql
>
>
> This is a repost of a post to the mysql list. The only response I
> received there was that I shouldn'g mess with the permission tables
> directly. My problem is connecting to mysql.sock. This may be
> addressed more appropriately here on the RH list. Hope someone can give
> me a hand.
>
>
> I'd appreciate some pointers to get me going in the right direction
>
> MySQL version 3.22.30
> OS Linux RH 6.1 on Athlon 700
>
> I am having trouble connecting to mysql as anything other than root.
> I have added a user with
>
> insert into user host, user, password values('localhost',
> 'inspiron', password('rwhart') ) ;
>
> select host, user, password from user; lists the user, server and an
> encrypted password okay.
>
> Then I logout and log back in as user 'XXXXXXX' with pwd 'YYYYYY' then
> issue
> mysql -h localhost -u inspiron -prwhart
> Note: 'XXXXXXX' and 'YYYYYYY' above are different and of mixed case
> that the username and passwords used to connect to MySQL.
>
> The follow error is returned:
>
> error 2002: Can't connect o local MySQL server through socket
> '/var/lib/mysql.sock' (111)
>
> Does anyone have some suggestions re: where to start ferreting out the
> fix. My reasons are that I am trying to learn PHP based scripting for
> interactive web pages that I plan to implement on an intranet for a
> medical database.
>
> TIA
>
>
> Bob Hartung
>
>
> --
> To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe"
> as the Subject.
>
--
To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe"
as the Subject.
