MySQL is is an Open-Source Relationship DataBase Management System (RDBMS) which is currently owned by Oracle, but it was founded by Michael Widenius and since leaving Sun Microsystems he has formed the Open Database Alliance and has created the Maria DB which was based on MySQL.
To download MySQL go to http://www.mysql.com
All my websites use MySQL. If you want to use a quick and easy automated set up just to get you going and start building websites. I have used a free product WAMP SERVER when I am working on a Windows computer, but this product does support other platforms. This product will not only set up MySQL for you but will configure PHP and provide you with an Apache HTTP Server as well.
MySQL Proxy can be used to monitor, analise, load balancing, query analysis and query filtering.
MySQLD or MySQL Daemon which is a server process and is the main program. Sub components include:
- Query Engine
- Storage Engine
- MySQL Administrator
- MySQL Query Browser
Client / Server Concepts
MySQL Command line Client runs in two modes interactive and batch
Example of interactive mode:
Sample log on script
- mysql -u user -p -h hostname db name
mysql> SOURCE C:/folder location/script name.sql; NOTE: That the it is using a URL syntax rather than UNC this is in a UNIX form rather than Windows. It caught me out the first time.MySQLADMIN UTILITY is the tool for governing your MySQL Server. Monitoring, Stop/Start Services, Troubleshooting, User Account Administration