View Single Post
  #4  
Old 3rd January 2007, 18:59
Bubo Bubo is offline
Junior Member
 
Join Date: Nov 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for that but I am still a little confused

I created the user as follows:

Code:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost'
    ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%'
    ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
which I thought should allow access from anywhere on the lan.

I can then connect from my Win box using this username however when I try and use a specific windows app to connect I get the access denied message again.

Its all very confusing

Bubo
Reply With Quote