Error No 1045

This topic is empty.

Viewing 7 reply threads

Author

Posts
- November 4, 2003 at 8:22 pm #8231
  
  tgifch
  Member
  
  Hi there
  
  I receive an “Access denied for user” error when trying to connect to the host which has my MySQL databases installed. After filling in all the necessary data and clicking on connect the programm seems to add an @ symbol and concatenates a second string with information about my DSL line into the field user name.
  
  When using phpMyAdmin I have no problems connecting as root. Any ideas what's going wrong?
  
  Thanks
  
  tgifch
- November 4, 2003 at 8:39 pm #15201
  
  Ritesh
  Member
  
  It seems that you dont have permission to connect from a remote host.
- November 4, 2003 at 8:50 pm #15202
  
  tgifch
  Member
  
  Hi Ritesh
  
  Thanks for the prompt reply.
  
  I have all rights to the MySQL database and no restrictions concerning network connectivity.
  
  There is no user in MySQL with the name that SQLyog puts together ([email protected]). Is it possible to influence what the programm concatenates into the user name field?
  
  Any other suggestions?
  
  Thanks
  
  tgifch
- November 5, 2003 at 8:13 am #15203
  
  Ritesh
  Member
  
  SQLyog does not add any information on its own.
  
  Are you able to connect to the MySQL server using any other client utilities like the MySQL Command Line tool.
- November 6, 2003 at 8:44 am #15204
  
  StefanWagner
  Member
  
  Well I do have the same problem too.
  
  I tried to connect to serveral DBs running on LINUX and Windows.
  
  I tried different ports. No success!
  
  My firewall is free on port 3306.
  
  I would like to see, that the connection and the jobs are working before I go and buy the software.
  
  I do have all rights on all the databases.
  
  At least at two of them I know that the provider does not reject outside-connections to the DB.
  
  Any suggestions?
  
  Regards,
  
  Stefan
- November 6, 2003 at 12:55 pm #15205
  
  Shadow
  Member
  
  tgifch!
  
  I believe, your ISP runs phpMyAdmin on its site. If this is right, then your problem is that phpMyAdmin logs on locally, while SQLyog connects from your remote machine. MySql (NOT SQLyog) forms the login name as user_name@host_name, where host_name is the name of the computer you log in from. In you want to connect from home via SQLyog, then you should ask your ISP (or do it yourself, as you may have root privileges) to grant access to either your_user_name@% (from all hosts), or to your_user_name@that_dsl_name (that information about your DSL).
- November 6, 2003 at 1:02 pm #15206
  
  Shadow
  Member
  
  StefanWagner!
  
  Take a look at this topic!
- November 7, 2003 at 9:37 am #15207
  
  tgifch
  Member
  
  Hi All
  
  Thanks for the input and interest in my question. The tip to create an MySQL user with host = % did the trick. I can now access the MySQL databases.
  
  Take care and TGIF
Author

Posts