[thelist] connecting to a mySQL database

Kasimir K evolt at kasimir-k.fi
Thu Apr 29 02:23:28 CDT 2004


> Hi there. I am learning to use mySQL db on my hosting. It comes with an web
> admin screen to run SQL etc. What I would like to do is run SQL from some
> sort of client on my PC that can connect directly to the database. Any ideas
> on how I would do this?

I use MySQLCC[1] on daily basis, and phpMyAdmin[2] too, neither is 
perfect to my tast, but together they are great. Good thing with MySQLCC 
is that you can access remote DBs with it.

MySQL administrator[3] might come handy at some point.

I also use Apache/PHP on my local machine to connect to remote MySQL. I 
have local MySQL too, but often I want to try a script on 'real' data, 
but not yet upload the script.


[1] http://www.mysql.com/products/mysqlcc/
[2] http://www.phpmyadmin.net/home_page/
[3] http://www.mysql.com/products/administrator/

More information about the thelist mailing list