How to use Mysql GUI???

[Shanu.chaudhary]

Hi everyone...

I downloaded mysql-gui-tools-5.0-r12-win32 to use Mysql in browser as I feel difficulty to work in command prompt..:)

I can't find how to open it in browser and how to use it??

Can someone Xplain me about this??:p

Any help is Greatly Appreciated...

Many thanks in Advance....

[Shanu.chaudhary]

Never mind...It is working....:)

[ikebuck]

are you using it admin sql on an external server or a test server? If it's a test server, I believe the mysql gui runs as a stand alone program. You can also use WAMP and use rthe phpmyadmin from the WAMP menu in your taskbar. If you're admin-ing mysql on your remote server, doesn't the host have phpmyadmin? Most do. Hope this helps.

[Shanu.chaudhary]

Thanks for ur reply...Anyhow i am working with it now..
It is a Localhost, Apache server...
I am having one doubt ...With PHPMyAdmin, We can maintain a database for local host as well as remote server right??

I mean once the site becomes online it is used toi maintain a database rgiht??

[ikebuck]

The phpmyadmin on the test and remote servers are going to be two seperate instances, therefore will be controlling two seperate db's. what I've done in the past is to create a database on my test server, configure my php scripts for it, then when I get everythig working, I export( or just copy and paste from one phpmyadmin to the other) the exact same database on my host server and change the approptiate scripts in my connections file,
i.e:
mysql_connect_db('localhost','usename',pass');
becomes
mysql_connect_db('server_host_path','usename',pass');

hope this helps
ike

[aj_nsc]

Not sure if this might help you out, Shanu.

You can't have a phpmyadmin on your local machine that accesses a remote database. As ikebuck rightly pointed out, they will be two separate instances.

What you can do, however, is configure your remote server to allow remote access to your MySQL database. Then configure MySQL query browser on your local machine, part of the MySQL GUI Tools, to connect to your remote server (much like an FTP client) and you can do any maintenance on your database this way. I have only started accessing clients db's remotely this way in the past few months, and I'll never use phpmyadmin on the remote server again unless I need to do some complicated queries. Good luck.

[Shanu.chaudhary]

IkeBuck, Thank U for ur information......I think mysql GUI interface is easy to handle when compared to PHPmyadmin..In my PC, mysql is working but I cant make that phpMyadmin work...It is somewhat confusing for me....Anyhow Mysql GUI interface is the better one ..right??

aj_nsc, Thanks for ur' information .......Presently I am working in localhost......once the site which i am wroking becomes online then I need to work with remote database.......

Can someone xplain me how can i change my local db to remote machine once my site becomes online.......(I am new to programming)

Many thanks in Advance........