Most all connections with programs such as MySQL Control Center, MySQL Front etc.

here is a step by step connection for MySQL Control Center, use the same settings with other programs and you will be able to connect:

you will need to access your cpanel and go to the mysql section enter
the following in remote access

if your on a static ip (your ip does not change ever) enter in your ip

if you on a dynamic ip (your ip changes after every reboot, connection to
internet) enter in %

if your not sure of either enter %

for mysql control center enter the following in the general tab:

name = your name

host - http://www.domain.com

username - mysql username i.e. cpanelusername_mysqlusername

password - password for the mysql username

database tab:

enter in your database - cpanelusername_databasename

I hope this information is helpful

Hi,

Did you ensure that you added the user to the database? You would create the database in Cpanel in MySQL databases, then create the user, then add the user to the database. If you only did 2 steps (and they are 3 separate steps), then you haven't added the user and need to do so. Click add user after selecting the database and the user in the drop down right beneath the database section.  After the user is added, there will be connection strings to Perl/cgi, php, and java.

Next, if you did add the user and it isn't working, what exact error are you receiving.  The error is an indication of the issue occurring.

Another point would be what exact program are you using to connect? Each program is slightly different and this is useful to know if you want someone to troubleshoot the issue.

Next, has your domain propagated? If it hasn't, you can't connect using it. You would need to use server.lunarpages.com where server is your server's name like galaxy.lunarpages.com or danzig.lunarpages.com, etc.

Finally, provide the exact settings you are using to connect for the fields that Anthony provided (other than your password). If you want me to test connecting, PM me your password. I can only do the testing, however, once all conditions above are answered and met, since I need the information for any testing.

Thanks.

If you connect remotely, you need to use your domain to connect for the host. If you connect locally via a page on your site on the server itself, you need to use localhost for the host.

Nside, did u ever resolve this problem?

I did exactlywhat u did and got the same error.

I was trying to connect with

mysql --host=mydomain.com  --user=myusername_newuser  --database=myusername_dbname

Anyone know how to connect remotely?

I also use ODBC drivers to update my DB on LP from an access db.

These are the settings I have used (edited to make generic):

Host Server Name : www.domain.com
DBname: xxx_phpbb1
User: xxx_name
Password: yyyy
Port: 3306

This has been working for me.

I was having very similiar problems. Interestingly, I had the same findings as GMTurner- that I could connect with a user created AFTER I had allowed access from my IP address, but the user in the database that existed before I had allowed connection from my host still cannot connect.

For example, here is the original error:
Access denied for user: 'denver6_xmb1@xx-xxx-xxx-xxx.my.isp.net',

even though my ip address was already granted permission. At one point I even tried the % as others have suggested, leaving it wide open.

Then I added another test user, and that person connected no problem, the only change being the user name and password, both of which I checked many times. So it seems the sequence of adding the hosts allowed access and the users in the database is a critical piece of getting this to work.

I hope I am wrong about this because I can see how this could cause problems down the line if I want to open the access to the data to other ip addresses. It seems it would require me to create new users as well.

Someone please correct me if I am wrong!

GMTurner,

That is a good suggestion.  :clap:I had not thought of deleting and recreating a user with the same name. Should that issue arise, I will definitely give it a try.