mysql connection problems (localhost connection)

mysql connection problems (localhost connection)

Post by Adam Week » Sun, 31 Dec 1899 09:00:00



I am trying to use mysql for the first time on RH7.  I already have had
apache working well, and a few system problems, but all-in-all pretty
solid.  I have two NIC cards, and the LAN/WAN is all working fine.

When I try to, for example, create a DB, here's the message I get, even
as root


./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' exists!

Anyone have any ideas what's going on?

I've also had some weird problems on bootup, where NFS lockd times out
with no response from localhost!

Please respond if you have any ideas.

Thanks

 
 
 

mysql connection problems (localhost connection)

Post by David Maggian » Sun, 31 Dec 1899 09:00:00


I had to abort 7.0 due to other problems that I encountered but there is a
bulletin on the redhat web site about problems with the MySQL that shipped
with 7.0. The link off the top page that says 'update notice' eventually
gets you to a screen with the following info.

--------
The mysql packages shipped with Red Hat Linux 7.0 don't allow users to
access the socket, causing the package to work for users "root" and "mysql"

only. Also, the pid file handling has been fixed.
-------

I'd say load the latest and try again. Hope this helps.

DM


> I am trying to use mysql for the first time on RH7.  I already have had
> apache working well, and a few system problems, but all-in-all pretty
> solid.  I have two NIC cards, and the LAN/WAN is all working fine.

> When I try to, for example, create a DB, here's the message I get, even
> as root


> ./mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (111)'
> Check that mysqld is running and that the socket:
> '/var/lib/mysql/mysql.sock' exists!

> Anyone have any ideas what's going on?

> I've also had some weird problems on bootup, where NFS lockd times out
> with no response from localhost!

> Please respond if you have any ideas.

> Thanks


 
 
 

mysql connection problems (localhost connection)

Post by Patrick F Harri » Sun, 31 Dec 1899 09:00:00


List

I have just spent a couple of nights reviving a Java <>  MySql program, that
ran fine on RH 6.2

After a clean RH 7.0 install the old java stand alone (no-gui.jar) program
could not connect to the old data base
mm.mysql driver. - error message was internally generated by mm.mysql.

Quote:>> "Server configuration denies access to data source".

Symptoms, MySql Severs  is up & I can connect with MySql etc. from the Local
net and from the machine running MySql.

Java application can connect from local net, but not from the local machine!  I
suspect that mm.mysql was trying to find the local
socket and could not. I have no idea how to tell mm.mysql what the local name
socket is.

------

My solution was to take all the fancy installation determination stuff out of
safe_mysqld, hard code the installation stuff there, put a
copy my.cnf  with the same information in  /etc,  and hard code the
installation data in mysql_configuration.

--------

An open issue the system is getting the mysql_setaccess script
(perl5.00  DBI) to run.

Patrick


> I had to abort 7.0 due to other problems that I encountered but there is a
> bulletin on the redhat web site about problems with the MySQL that shipped
> with 7.0. The link off the top page that says 'update notice' eventually
> gets you to a screen with the following info.

> --------
> The mysql packages shipped with Red Hat Linux 7.0 don't allow users to
> access the socket, causing the package to work for users "root" and "mysql"

> only. Also, the pid file handling has been fixed.
> -------

> > Please respond if you have any ideas.

> > Thanks

 
 
 

1. problem with indirect connection to localhost

i'm trying to set up a linux box as a standalone x-terminal.
for this purpose i want to get the machine to display a chooser.
if i start x with 'indirect localhost' x starts up, and the chooser apperars.
but after i have choosen a host the server resets and the chooser apears again.
if i get the chooser from another linux box everything works but than
it's not a standalone setup anymore ;-(.

i have the feeling that there is a problem in the networking code. i'm trying
this setup for half a year now and when is started i couldn't even get the
chooser to show up. after a few kernelupdates and no change on anything else
i get the choose.

i have tryed the same setup on my machine at home which is not networked in the
moment. i have configured the dummy net device and everything works.
i get the chooser and can log into my machine.

who has hints to solve my problem ??

regards
  andre schroeter
--
---------------- PI equals 3 at least for small PI and large 3 ----------------
Andre Schroeter
German Cancer Research Center                        tel.: (+49) 6221 - 42 2382
Dept. Medical and Biological Informatics             fax.: (+49) 6221 - 42 2345
Im Neuenheimer Feld 280                     url: http://mbi.DKFZ-Heidelberg.de/

-------------------------------------------------------------------------------

2. how linux can automaticaly forward a email to an other address?

3. probe-scsi hangs

4. Problem with connections to "localhost"

5. Review of SuSE 7.1 PPC

6. Problem: rsh localhost -- connection refused

7. smtp problems

8. sendmail problem (?) : telnet localhost 25 --> connection refused

9. MySQL connection problem ?

10. MySQL and jdbc connection problem

11. no telnet connection to localhost

12. rsh localhost - connection refused