Looking for visual mysql admin tool (to use remotely)

[kingzl3y]

Yo, I've got about 3 weeks to start, complete and write a 8500 report on my final project for university.

I've chosen to use html + css w/ php and mysql to create an online doctors appointment booking system.

I'm pretty new to mysql and just wondering if there's a visual editor/administrator I can use to remotely edit/admin a mysql database which I've got on my webspace?

I've tried to use mysql workbench 5.2 but not sure how to enter my website credentials, i've looked for the past 20 mins and found, well not alot on it.

Do I use my cpanel username and password? or are they different? I've allowed any IP address to access the mysql database, % and stuff.

Is it best to stick with mysql workbench? or is there anything better?

Thanks!:frogbon:

[Denzo]

phpmyadmin

[kingzl3y]

That's how I would do it, but then I wondered if there was more visual approach to it. I'm alright with hard coding, but because I'm not that good I don't think it'll be a good idea

:(

[bl4h]

There's a designer tab in PHPMyAdmin, select a database then click 'Designer' at the top.

[Giraffen93]

SQLYog.

The newer versions are shit though - with their shareware popups..

[kingzl3y]

there is?!

[editline]12:11AM[/editline]

[IMG_thumb]http://i44.tinypic.com/2u6e8zr.jpg[/IMG_thumb]

I can't see anything

[turb_]

heidisql

[ifaux]

your most likely using windows but if you aren't then Sequal Pro

[bl4h]

[QUOTE=kingzl3y;21107263]there is?!

[editline]12:11AM[/editline]

[IMG_thumb]http://i44.tinypic.com/2u6e8zr.jpg[/IMG_thumb]

I can't see anything[/QUOTE]
Select a database (such as 'kingsley') and it should say "Designer" in the top tabs.

It could be in newer versions of PHPMyAdmin only, I'm running v3.2.1.

[zyxxyz]

[QUOTE=turb_;21108445]heidisql[/QUOTE]
[url=http://www.heidisql.com/]Direct link[/url]

[ubermensch]

I like the old MySQL GUI Tools. The stuff they're trying to throw out now I just can't understand.

[<ToD> Aar]

[url=http://www.navicat.com/]Navicat[/url].

[AaRoNg11]

I have to agree with everyone else, HeidiSQL is the way to go. It has a really friendly interface and it can do pretty much everything you can in phpMyAdmin.

[Hexxeh]

HeidiSQL for Windows, Sequel Pro for Mac.

[g@mergeek]

I'd go for Navicat, personally or just use PHPMyAdmin.

[a2h]

[QUOTE=turb_;21108445]heidisql[/QUOTE]

So erm HeidiSQL vs phpMyAdmin - any good comparisons? Did a quick search and didn't find any good ones.

[turb_]

I really haven't used HeidiSQL much, I only use it when I connect to a database other than my own (for my own db, PMA is much more convenient - plus I feel comfortable with it)

[editline]02:11PM[/editline]

That said, HeidiSQL is still good

[g@mergeek]

If your site comes with PMA pre-installed then just go for that.

[kingzl3y]

Awesome, thanks for all the replies.
It's my first Sunday off in over a year, so I've got a bit of time to fuck about with it today.
I'm gonna got a for a shower and then get to work I guess.

Before I go though, How would I connect remotely to my database?

I'm not sure what port number to use or what username or password, my host is [URL="http://www.x9internet.com/hosting.php"]x9 and i'm using the midi package on the PLUTO - UK/USA/CA.[/URL]

Is it best to email them asking what details to use? Or are they similiar to my normal cpanel login?

Cheers

[turb_]

Use the MySQL database username and password that cPanel gives you. The port should be 3309

[editline]12:06AM[/editline]

Sorry, it's 3306. I'm dyslexic

[zyxxyz]

[QUOTE=a2h;21151999]So erm HeidiSQL vs phpMyAdmin - any good comparisons? Did a quick search and didn't find any good ones.[/QUOTE]
Well for starters one is desktop-based and one is browser-based...

Both are very good at doing their jobs, IMO.

[Seanm07]

[QUOTE=turb_;21108445]heidisql[/QUOTE]
This.

I used to use MySQLAdmin but then one day I found Hedisql and it is much faster and better to use. :D

[kingzl3y]

Yo,
I've installed Heidi but still haven't no luck.

I've tried every single possible combination of user/password that I have and still having no luck.

I've allowed anyone to connect remotely. Still no avail. Dropped my host an email, but they are possibly the worst company for communication ever. I probably won't get a reply. Although it is a Sunday, so maybe tomorrow or Tuesday they'll decide to reply.

Apparently the host has toport forward to the mysql server? I'm guessing they haven't done that or I'm just getting it wrong. Terribly wrong.

Cheers

[Seanm07]

Do you have a cpanel with your host?

[kingzl3y]

Yeah, i do

[editline]08:26PM[/editline]

Just a thought, maybe I can't connect, maybe my host won't let me due to whatever reason.

Is there a way I could create a mysql database locally, and then some how export the database to my web host? It sounds possible but I don't know that much about mysql.

But then again, when It comes to testing, how will I get php to run locally without having an apache server? dayum

[Sirkorv]

[QUOTE=kingzl3y;21168102]Yeah, i do

[editline]08:26PM[/editline]

Just a thought, maybe I can't connect, maybe my host won't let me due to whatever reason.

Is there a way I could create a mysql database locally, and then some how export the database to my web host? It sounds possible but I don't know that much about mysql.

But then again, when It comes to testing, how will I get php to run locally without having an apache server? dayum[/QUOTE]

Get XAMPP.

[Dusty_]

[QUOTE=kingzl3y;21168102]Yeah, i do

[editline]08:26PM[/editline]

Just a thought, maybe I can't connect, maybe my host won't let me due to whatever reason.

Is there a way I could create a mysql database locally, and then some how export the database to my web host? It sounds possible but I don't know that much about mysql.

But then again, when It comes to testing, how will I get php to run locally without having an apache server? dayum[/QUOTE]
Seriously, either try creating a mysql user with cpanel and giving it full privs then connecting with heidisql, or just use phpmyadmin. I seriously doubt you're making shit so complex that phpmyadmin slows you down.

[kingzl3y]

I think you're right. It's not that hard. I just like the easy drag-drop solution, but I'm actually looking at phpmyadmin and it's not that difficult. If i get a reply from my host tomorrow, I'll wait. But if not I'll just use the phpmyadmin approach, thanks alot.

[<ToD> Aar]

Just so you know, if your web host operates on a shared-host type system, in other words : more than one person is making use of the one server, they probably won't allow you to use a 3rd party MySQL program. They usually claim it causes issues with stuff, but yeah. Your best bet is to just go with PMA.

[kingzl3y]

[QUOTE=<ToD> Aaron;21170829]Just so you know, if your web host operates on a shared-host type system, in other words : more than one person is making use of the one server, they probably won't allow you to use a 3rd party MySQL program. They usually claim it causes issues with stuff, but yeah. Your best bet is to just go with PMA.[/QUOTE]
Actually make perfect sense. There's a bit of a dark area with the whole 3rd party programs, I've found out stuff which I haven't read when looking through the how-tos or faq. :(