> [email]romain.alnet[/email] wrote:
> > I've been using mySql for a couple of years now.
> > I was wondering about administration tools that use people out there.
> > I have read many tutorials on the web introducing how to install
> > PHPmyadmin.
> > Phpmyadmin is a good and a very well done PHP frontend for Mysql, but
> > come on, I don't understand the point to make install such tool when
> > you are not working with mysql along with a webserver and php dev.
> IMHO the main reason for the popularity of phpMyAdmin is the fact that
> most hosting providers do not give command line access to their users
> and also disallow access to MySQL from everywhere except from the
> webserver. If those users need a database administration tool they most
> naturally end with phpMyAdmin.
> OTOH phpMyAdmin (and probably every other web based tool) would not be
> my first choice for such a tool:
> 1. there have been countless problems with phpMyAdmin modifying query
> strings (so the same query - from the users point - behaves differently
> if executed from within phpMyAdmin compared to the MySQL CLI)
> 2. there have been countless issues with phpMyAdmin modifying character
> set settings. Queries deliver broken umlauts from within phpMyAdmin but
> work when used from other PHP scripts.
> 3. PHP scripts suffer serious restrictions in terms of memory and/or
> cpu time consumtion. So if the database becomes bigger, phpMyAdmin
> users experience failures in backup/restore operations etc.
> > So what is your prefered tools to administrale your Mysql database.
> I personally do nearly anything with the CLI tools: mysql, mysqldump,
> mysqladmin. Those tools work on local and remote servers, are fast,
> easy and simple.
> I know some people dislike the CLI but there is big choice in GUI tools
> as well. From MySQL AB you can have Query Browser and Workbench. Also
> there are TOAD, Navicat, SQLyog and countless more tools (google for
> "mysql gui admin tool"). Problem: in most cases one wants to run those
> tools on the local workstation but connect to remote MySQL server.
> If one has SSH connection to the remote host, the best solution to
> connect to the MySQL server is to use a SSH tunnel. This is explained
> on many websites. Again, Google is your friend.
> Axel Schwenke, Senior Software Developer, MySQL AB
> Online User Manual: [url]http://dev.mysql.com/doc/refman/5.0/en/[/url]
> MySQL User Forums: [url]http://forums.mysql.com/[/url]