How can I make MySQL user friendly, what program can I use as an Interface?
Feb 12th, 2008 04:27
dman, Shashank Tripathi, The Guru, Michael Mak, Chuck Roberts, Zachary Kent, Jaco van der Westhuizen, http://sturly.com
FOR WINDOWS MACHINES:
WebYog's free tool is fantastic:
FOR WEB BASED ACCESS:
Most hosts have this already installed (with Cpanel or Plesk) so you
should have it already, but it's also possible to install it on your own
If you are looking for a web-based administration program myPHPAdmin is
great. You (or your ISP) must be have PHP installed on the server for
this application to run.
If you are looking for a language to create your own application
interface to a mySQL database, PHP is the best choice.
You can also use MS Access as a front-end. Make your SQL database,
install the MyODBC drivers, and link to the tables from Access. From
there, it's easy to program Access to make update screens, etc.
There are some powerful desktop MySQL GUI tool, you could try to
download PremiumSoft Navicat (http://www.mysqlstudio.com) or EMS MySQL
tool (http://www.ems-hitech.com/mymanager). They both support to
manage your local or remote databases.
I am using EMS MySQL Manager since last three years and I found it
good. Its available at http://www.sqlmanager.net/products/mysql/manager
You can also like to see whats stored for us in Toad for MySQL. Right
now there is some free trial (Test drive) going on for Toad for MySQL