Dr. Randy Frid writes: > I recently wrote in that I've tried everything in the book to connect to > MySQL but I'm still getting the infamous "socket (111) error. I've had a > few good suggestions and I think we are almost there. > > Here's where I am. > > With MySQLGUI trying to connect, I changed the host from "localhost" to > 127.0.0.1 in my.cnf. > > Now I get "Host apache is not allowed to connect to this MySQL database". > (I call my server "apache") > > Any ideas now? Seems to me to definately relate to a permissions problem. > > Thanks everyone, for all your help. I need it. > > Cheers, Randy
You should GRANT user to log from host apache : grant ... to nobody@apache or ... to nobody@"%" (to log from any host). -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php