How do I remotely connect to a mysql database, tutorials aren't working for me.

I have been trying for the past week to find a way to remotely
connect to my mysql database. I have had no luck in the matter.

I need to know if phpmyadmin allows remote connectivity.

I would like to add that I am only 17 and have had only a couple
months of mysql 'experience'. I wouldn't call it experience either.

On the other hand, I have had more than 7 years of experience
with html and a year with cgi. I do know how to connect to a
database with a php page, too. I just can't figure this out. It is
quite aggravating.


- Kenny Rogers Jr.

mysql -u user1 -h 111.22.33.44 dbname -p


where -u specifies to connect as user1, -h specifies the hostname of the MySQL database as 111.22.33.44 (replace this with the IP address of you VirtualServer account) and the -p at the end signifies that the user has a password. You will be prompted for the password after pressing return.

I don't have a VirtualServer account. (what is one?)

You forgot to mention, that I would also need to download mysql onto my computer. Luckily, I forsaw this event, and I downloaded it a couple of hours ago.

But, unfortunately, I am still having no luck accessing my mysql database.

If somebody has time, please make a step-by-step process for me, and anyone else that is also having this problem.

- Kenny Rogers Jr.

A couple of minutes after that last post, I found that I get this error:

ERROR 1130: Host '###.###.###.###' is not allowed to
connect to this MySQL server

(the ### sign's are what I replaced with my IP address
It is my Actual IP Address for my computer.

I put "mysql -u jnp-krogersjr -h www.kennyrogersjr.com -p"
I tried to put the db name in but it wouldn't work; so I left it out.

- Kenny Rogers Jr.

kenny,

Don't let it get to you. I know this can be a frustrating matter.
Here are a few steps I suggest you take in solving this problem.

1. Where is your Mysql Database Hosted?
a. Your ISP/Web Host?
b. A remote machine that you administer?

Answering the above question will help you figure out who to contact in regard to the following question.

2. Do you have remote access to the MySql Server and/or the particular database you are trying to access.

If not, you need to make sure you have a record in the mysql user and/or db table for your username which has a host entry of '%'.


As a side note, please understand that PhpMyAdmin is a client/server application that normally resides on the
same machine as the mysql server and thus has permission to access the mysql server locally... so just because
you can connect remotely to phpmyadmin does not mean you have access to remotely access the mysql server directly.

I hope this makes sense and I hope you solve your problem

Also, I forgot to mention that I normally use the following command to connect to a mysql server:

mysql -u <username> -p<password> -D <dbname>

Yes, that is -p<password> with no space between the -p and the <password>