phpMyAdmin working fine, but can't figure out how to connect remote via terminal

[mikeycorn]

phpMyAdmin is working fine for me, but the book I'm working out of is using mysql monitor. Unfortunately, the book is using examples of accessing the database locally, with your computer acting as the server. What I need to do is connect to the database I created on my webhost, but I can't seem to make the connection.

I'm using a program called Easy Term 4.3 and the only two variables you have before trying to make the connection are host and port.

For the host I've tried things such as . . .

http://mysql.mydomain.com

(No, I didn't copy "mydomain" from the book exactly like that . . . 😉 )

For the port, someone told me try 3306, that's the standard. I also tried 2083 because that shows up on my URL in the Address Bar when I'm in phpMyAdmin.

None of it's working.

I'm also confused by the fact that when I use an FTP program, I can't find my database anywhere, even though from the Control Panel, the path to the database is listed as

/usr/local/bin:/usr/bin:/bin

which is quite a confusing looking path if you ask me and I don't see a /usr folder anywhere from the root down . . .

Obviously, I'm confused about a lot of things regarding making a terminal connection, so any help will be appreciated.

[csn]

Sounds like you need to grant permission for that host to access the mysql server. Check the docs for GRANT.

As for FTP - it's run in a "jail". Anything above its root directory won't be accessible.

[mikeycorn]

Thanks for the reply. I should have mentioned that from my webhost's control panel, I was able to set up mydomain_user and give it all privileges . . . the only choices I have to connect from Easy Term are host and port, so is there a way I incorporate the username and password along with the URL into the host line?