Web-Based MySQL Administration
At http://phpwizard.net/phpMyAdmin you will find a PHP Web
application
that can help you manage MySQL. It enables you to manage
a MySQL database using a browser and makes administrative work much simpler.
BlueSQLFree web based Database management.
After you have installed PHP and MySQL, you are ready to install
phpMyAdmin. The
work done while preparing for IMP has also prepared the
system for
phpMyAdmin. You do have to edit one of the .
php3 files in
phpMyAdmin to
enter the MySQL database name and password.
With
phpMyAdmin, you can create and drop databases
and tables. You can also add and remove fields and perform other administrative
chores.
Navicatanother option,
I have found
phpMyAdmin to be very useful when trying
to create or delete tables. After you have filled out a form that describes the
table, it generates the SQL for you. You can use this
information to create script files for later use.
For now,
phpMyAdmin has some bugs. I have had it
crash on me several times. However, its usefulness is good enough for me to
ignore the occasional crash.
From a security point of view,
phpMyAdmin is
terrible. After it is installed, everyone who uses that Web page has
unrestricted access to the MySQL database. I strongly recommend that you do not
put your server on the Internet with
phpMyAdmin active.
If you do, you must configure your Web server to serve only the
phpMyAdmin Web pages to your local network. You should also
protect the Web pages with a
password. Be careful!
Adminer