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?

[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.



i uses %% for ip wildcards as well



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 (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