I think I know what I DID!!!!

[Coderifous]

OK, this is a followup post to the post I posted about destroying my database.

In the MySQL database, there is a table called host or hosts or something. I took out a line from that table... I think...

That line may have been blank except for a wild character (%) in a column..

is that table responsible for saying where clients are allowed to connect from???? that would explain my problem. I can't connect from localhost. OK I think that's my problem. Does anyone know how to put that entry back into the table, but without being able to login?

 

[cDevX99]

Oh, i get it, there are two files, ( i think i have the structure right...if not I am clos) /etc/hosts.allow & /etc/hosts.deny. deny should be empty, and I think you are correct allow should either be empty or contain a wild char.... in anyevent... adding localhost to that file should certainly do the job.

 

[Broccoli2]

To connect to a MySQL server from the same machine (ie

localhost[code]) you need a specific entry for [code]localhost

in either the

user

table or the

host

table. The wildcard (

%

) does not match

localhost

.

To connect to a MySQL server from another machine (ie not

localhost

) you need either a specific entry for that machine, or a wildcard (

%

).

-Rob