#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    3
    Rep Power
    0
    I'm tring to use a Client from Win98 to access our MySql running on Redhat 6.2. I've gone in and set up my username in, host id and db's in the MySql DB. However, when I log in, I get the message:

    Host '' is not allowed to connect to this MySQL Server."

    In HOST table, i've set the host to '%' (for logging in from any machine) and a username of 'jerryh'. I also have set up my username and password in the USER table. What gives?
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    If you didn't use GRANT, did you FLUSH PRIVILEGES after making the entries? or restart mysqld?
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    3
    Rep Power
    0
    Yup, after posting the original message, i restared mysqld, and viola, it worked!

    Am I to assume that anytime I make changes to the tables in the MySql DB, I need to restart or flush privileges?
  6. #4
  7. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    Only when you make direct changes, yes.

    You should check out using GRANT and REVOKE. Generally much safer and no need to flush.
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    3
    Rep Power
    0
    thanks for the tip. I did buy a book; i suppose i should RTFM carefully...!

Similar Threads

  1. Invalid characters with PHP and MySQL
    By gio50000 in forum MySQL Help
    Replies: 2
    Last Post: November 18th, 2004, 09:59 AM
  2. MYSQL CLIENT API !! Need Help!!
    By prem in forum MySQL Help
    Replies: 0
    Last Post: October 20th, 2003, 06:04 AM
  3. Sorting MySQL Data With PHP
    By januszjasinski in forum PHP Development
    Replies: 2
    Last Post: August 29th, 2003, 03:45 AM
  4. mysql - client vs. .mysql_query execution time ..
    By danieldafoe in forum PHP Development
    Replies: 3
    Last Post: April 3rd, 2003, 09:02 AM
  5. Unable to connect to mySQL server
    By blueprint in forum MySQL Help
    Replies: 1
    Last Post: February 13th, 2002, 10:02 AM

IMN logo majestic logo threadwatch logo seochat tools logo