Unable to connect

This topic is empty.

Viewing 14 reply threads

Author

Posts
- May 11, 2003 at 5:14 pm #7915
  
  rngade57
  Member
  
  I get an error 1045 everytime I try to connect to my database.
  
  I know my username and password are correct and that the name of the database is correct and the host address is correct.
  
  I checked the admin panel on my server and it is correct and says the the username and password are the same ones I am trying to use.
  
  Any idea what I am doing wrong?
- May 11, 2003 at 5:22 pm #14240
  
  Ritesh
  Member
  
  Can you provide us with the exact error message?
  
  It seems that you dont have the correct permission for remote access. Contact your ISP/MySQL admin to give you proper privileges.
  
  HTH
- May 11, 2003 at 8:31 pm #14241
  
  CalEvans
  Member
  
  Also, what does your mysql error log show?
  
  =C=
- May 11, 2003 at 9:23 pm #14242
  
  rngade57
  Member
  
  The error message is:
  
  “access denied for user '[email protected], (Using Password: YES)'
- May 11, 2003 at 9:29 pm #14243
  
  rngade57
  Member
  
  I am not sure how to access the error log. my website is on lunarpages.com and they provide the mysql hosting. I don't see anyplace to access an error log
- May 12, 2003 at 6:10 am #14244
  
  Ritesh
  Member
  
  Hello
  
  You dont have permission to remotely access the MySQL DB. Ask lunarpages.com to give you the correct permission
  
  HTH
- May 30, 2003 at 8:38 pm #14245
  
  deiwise
  Member
  
  What exactly would the permissions need to be? I'm about to ask my hosters if they'll do it for me – so presumabely I'll need them to allow access for me@myIP – but granting me to what exactly?
  
  Cheers
  
  Will
- May 31, 2003 at 4:08 am #14246
  
  Ritesh
  Member
  
  Looks like you will be connecting using dial-up internet account. If thats the case then ask your host to give you % in the Host field of MySQL User table. That will allow you to connect from any host and not one particular host.
  
  HTH
- June 1, 2003 at 7:45 am #14247
  
  kanga
  Member
  
  I've just downloaded and installed sqlyog and am having trouble connecting. I get the connection screen and the following fields are filled in.
  
  Description: localhost
  
  MySQL Host Address: localhost
  
  User Name:
  
  Password:
  
  Databases:
  
  Port: 3306
  
  Use Compression Protocl (unchecked)
  
  Use SSL Encryption (unchecked)
  
  I haven't entered anything into the above blank three fields (not really sure what I should put in there) and as yet I haven't created any databases.
  
  When I try to connect I get an error messge that says:
  
  Error No 2203
  
  Can't connect to mysql on localhost 10061
  
  I have no idea how to fix this as I'm very new to MYSQL and I desperately need help to get this working for a project I'm doing for my webdesign course, so any help greatly appreciated.
- June 1, 2003 at 1:46 pm #14248
  Ritesh
  Member
  The error means that no MySQL server is running on the server specified. As you have given localhost that means that you would like to connect to a local MySQL server i.e. one installed in your machine.
  - Make sure you have installed MySQL correctly. You can download MySQL from http://www.mysql.com
  - Start the server. Read the MySQL manual on how to startup the MySQL server
  - Give correct UserName/Password in the SQLyog Connection Field dialog.
  HTH
- June 3, 2003 at 3:26 am #14249
  
  kanga
  Member
  
  😀 Thanks for your help. I have it connecting now. I had downloaded MYSQL and SQLYOG then some time later installed PHP Triad was not aware at the time that MYSQL had been installed “twice”. I dumped the first MYSQL that I installed and now everything is working fine.
  
  Thanks for your reply
- June 19, 2003 at 5:02 pm #14250
  
  abbood
  Member
  
  so Ritesh, did you ask your hosters for the proper permissions and did everything work?
  
  b/c i'm having the exact same problem as you do..
- June 19, 2003 at 5:12 pm #14251
  
  Ritesh
  Member
  
  Our host i.e. Interland gives us permission to connect remotely. We dont have any problem to connect to our MySQL server using SQLyog. 😀
- June 24, 2003 at 5:54 pm #14252
  
  Zoly
  Member
  
  Hi, I have the same 1045 issue. I just can't connect. The site is hosted by Easyspace.
  
  I did not ask them for the % yet. But I have a question.
  
  Why is the connection works when I use MySQL Control Center or just plain PHP/MySql script in an ordinary web page? All from the same machine (Dynamic IP).
- June 25, 2003 at 6:28 am #14253
  
  Shadow
  Member
  
  Scripts embedded in web pages work because they are run on the server thus considered as local connection. I know nothing about the control center.
Author

Posts