I cant connect

This topic is empty.

Viewing 3 reply threads

Author

Posts
- August 6, 2003 at 10:19 pm #8121
  
  tsclan
  Member
  
  At the moment I am a bit stuck with the setting up of MySqlyog. If you can help that would be great
  
  It asks for this information
  
  MySql Host adress:
  
  Username:
  
  Password:
  
  Databases:
  
  now would I be right in doing this
  
  MySql Host adress: localhost
  
  Username:tclan
  
  Password: (iam sure it's correct)
  
  Databases: tigersports
  
  This is what my database user and name is
  
  Database Name: tsclan
  
  Database User: tigersports
  
  when I do that i get an error message saying
  
  “Can't connect to MySql server on localhost (10061)”
  
  Although I now know that my “MySql Host adress:” is not “localhost ”
  
  as it is not instaled on my machine so what should I therfore put in that box
  
  any help would be great
- August 7, 2003 at 3:26 am #14750
  
  Ritesh
  Member
  
  The IP address of the machine on which the MySQL server is installed.
  
  If its a server provided by your ISP, then you can confirm with your ISP about the correct IP.
  
  HTH
- August 14, 2003 at 5:28 pm #14751
  
  gluegun
  Member
  
  Ok I think I figured out that instead of 'localhost' I put my servers address 'db.breezeland.com' so I got THIS far. Now I've entered all the correct information in the required fields but I'm getting the 1045 error like mentioned in the other posts. I figure tsclan will eventually find out his hosts database addrress as I THINK I have but then he will eventually run into the problem that most of us are.. which is… why are we getting the 1045 error… As one user suggested in the 1045 error thread I tried to create my data base with a “@%” at the end of my user name but I got an error saying that I cannont create my data base with a user name like that. It must be alpha numeric meaning no “@%” to create a data base user name. My simple question what do i have to do? I don't see a clear answer. Alot of explaining but no answers. THANKS.
- August 14, 2003 at 5:56 pm #14752
  
  Shadow
  Member
  
  You should check out MySql manual about GRANT and REVOKE syntax and the chapters about security first!
  
  You should ask your ISP to grant access to 'your_user_name'@'%'. '%' means that you can connect from any host. As long as you cannot login to MySql, you cannot create any db.
Author

Posts