CocoaMySQL

[polarblau]

Hello,

I'm trying to use CocoaMySQL to edit my MySQL databases on my Bluehost account from my computer - unfortunately I don't seem to get the settings right.

Would somebody be so nice and correct me? - I couldn't find anything, that would have really helped in here so far.

What I've done:

I added my IP to the white-list in "Customer Preferences" with this format: 80.***.***.***/**
I added my IP "Remote Database Access Host" with this format: 80.***.***.***


Then I used the following settings in CocoaMySQL:
Host: http://www.mydomain.com
User: mysqlusername@localhost
Password: mysqlpw
Port: 2082

I also tried the IP instead of my domain for the host, that is show, when I access PHPmyAdmin.

I'm sorry, if this question seems a bit silly - my knowledge in this matter is pretty limited.

I'd appreciate any advice.
Thanks in advance,
-Flo

[charlesp]

I am pretty new to mysql but why not use phpMyAdmin to edit your database.
It's free and easy to use. I have never heard of cocoamysql. What does it do?:o

[felgall]

When you access the database remotely it is no longer on localhost. You need to make arrangements with Bluehost to enable remote access.

[Hwyman]

I have used "MYSQL Front" without any problems. I use port 3306 I think.
I had to add my home computer to the cpanel remote mysql icon before I got it working as well.

http://www.does-what-it-does.com/pictures/remote_db001.jpg

i uses %% for ip wildcards as well

http://www.does-what-it-does.com/pictures/remote_db002.jpg

good luck,

[Necron99]

You need to make arrangements with Bluehost to enable remote access.

Umm, well, at least *I* didn't have to. I use DreamCoder for MySQL and it's just a matter of making sure a user is defined for the database and that your access host is defined in "Remote MySQL" in CPanel.

Dave

[polarblau]

Thanks for all the replies.

@charlesp:
cocoaMySQL (http://cocoamysql.sourceforge.net/) (open source app for OS X) is in a way like a desktop-version of phpMyAdmin. I've used phpMyAdmin for quite a while now and I'm getting a bit bored of slow reloading, frames etc. etc. - It's a great app - no doubts, but I'd still rather use something running local on my computer.

@felgall:
After reading quite a few threads in here I was kinda hoping, that it would work without that.

@Hwyman:
I tried port 3306 as well as %% and % . - Nothing so far. How do you define your access host? I punched in my IP earlier and now only wildcards.
I furthermore changed the settings to:
Then I used the following settings in CocoaMySQL:
Host: http://www.mydomain.com
User: mysqlusername
Password: mysqlpw

@Necron99:
User is defined and connected with the database. Just won't work.
My errormessage looks like this:
Connection failed!
Unable to connect to host http.//www.mydomain.com.
Be sure that the address is correct and that you have the necessary privileges.
MySQL said: Unknown MySQL server host 'http.//www.mydomain.com' (1)

Any ideas? I'd really like to get this to work.
Thanks again,
-Flo

[web2pro]

Hello,

I'm trying to use CocoaMySQL to edit my MySQL databases on my Bluehost account from my computer - unfortunately I don't seem to get the settings right.

Would somebody be so nice and correct me? - I couldn't find anything, that would have really helped in here so far.

What I've done:

I added my IP to the white-list in "Customer Preferences" with this format: 80.***.***.***/**
I added my IP "Remote Database Access Host" with this format: 80.***.***.***


Then I used the following settings in CocoaMySQL:
Host: http://www.mydomain.com
User: mysqlusername@localhost
Password: mysqlpw
Port: 2082

I also tried the IP instead of my domain for the host, that is show, when I access PHPmyAdmin.

I'm sorry, if this question seems a bit silly - my knowledge in this matter is pretty limited.

I'd appreciate any advice.
Thanks in advance,
-Flo


What version of CocoaMySQL are you using.. There was a bug in version CocoaMySQL v0.5 you need to be running CocoaMySQL-SBG v0_5_5

Also what kind of Internet connection do you use at home, e.g wifi etc.. You need to add the external IP address of the router not the internal address you see on your computer..

[polarblau]

I'm running version 0.7b5 and I got my IP via http://www.ip-adress.com/ - since I'm in fact running a WiFi I thought this would be the way to go?!

Could anyone tell me, if the rest of the information is correct?
I mean, if I try to access anything else than a local server I'd replace "localhost" as host with "http://www.tld.com", right?

Thanks,
-Flo

[web2pro]

I'm running version 0.7b5 and I got my IP via http://www.ip-adress.com/ - since I'm in fact running a WiFi I thought this would be the way to go?!

Could anyone tell me, if the rest of the information is correct?
I mean, if I try to access anything else than a local server I'd replace "localhost" as host with "http://www.tld.com", right?

Thanks,
-Flo

I'd be inclined to use the ip address instead of the url..

[polarblau]

Sorry, didn't help either - MySQL said: Unknown MySQL server host 'http://69.89.**.**' (1).
It's getting a bit exhausting. And there seem to be just too many variables that can be wrong.
Any other ideas?
Thanks,
-Flo

[areidmtm]

If CocoaMySQL allows you to use an SSH tunnel, that would be the best way.

Other than that, after adding your IP to the white list AND creating a MySQL user, this is what I use:

Host: yourdomain.com (don't use http://www.)
Port: 3306
username: database_username
password: database_password

If you domain is yourdomain.com and you added a MySQL user of admin, then your user name will look like this:

yourdoma_admin

The first part of the username is the first 8 digits of your domain name. If the first 8 letters of your domain name are common to other domains on the server, then it would be the first 7 letters plus a number (yourdom1_admin, etc). This was provided to you in your welcome email from bluehost.

[polarblau]

THANKS! - now it works!
For everyone who's having the same problem:
areidmtm gave me the hint - NO http://www. within your host.

Just for the record: CocoaMySQL allows to use a SSH tunnel, but wouldn't I need SSH access for that?

Thanks again man, you saved my day :D
-Flo

P.S.: And another stupid question - my IP seems to change all the time. Since I'm not using a dial-up modem, how can this be and what can I do, so that I won't have to update the white-list all the time?

[areidmtm]

P.S.: And another stupid question - my IP seems to change all the time. Since I'm not using a dial-up modem, how can this be and what can I do, so that I won't have to update the white-list all the time?

Even DSL and cable internet will change your IP from time to time, it's called a dynamic IP address. You might want to get a static IP address. Or you add the entire c-class for your IP address in the Customer Preferences and in the Remote Database Access Host you can have wild cards (169.100.%.%)

To use an SSH tunnel, you will have to get SSH enabled on your account. It's not necessary, but it is the safest and a more secure way. However, the way you're using is just as well.

[adddfico]

Just a quick guess as I didn't see you mention it at all yet, but..

When remotely connecting to your database, not only do you have to add your IP to the Remote MySQL link, but you also have to contact Bluehost and have the IP whitelisted to allow it access across their firewall.

[polarblau]

When remotely connecting to your database, not only do you have to add your IP to the Remote MySQL link, but you also have to contact Bluehost and have the IP whitelisted to allow it access across their firewall.

As I see it you can do that yourself (and it worked in my case). This option is given at the bottom of your billing-information within your admin-panel.
-Flo

[gotblues]

Thanks for the info in this thread. only took me 10 minutes to get Sequel pro (new version of CocoaMySql) operating.

To pull all the info together, I had to add my IP to:
Cpanel > Databases > RemoteMySql
and
Cpanel > preferences > update contact/billing info > mysql whitelist

Then in Sequel Pro:
Host: host name w/o http://www
Port: 3306


thanks again. good luck!