faqts : Computers : Databases : MySQL

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

68 of 93 people (73%) answered Yes
Recently 8 of 10 people (80%) answered Yes

Entry

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:
http://www.webyog.com/en/
FOR WEB BASED ACCESS: 
http://www.phpmyadmin.net/home_page/index.php
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
hosting.  
------------
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.
Zachary Kent
-----
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. 
Chuck
---------
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.
Michael
_____________________________________________
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
http://techiecorner.blogspot.com/2006/02/quest-toad-trial-offer.html
The Guru
____________________________________________