What is MySQL?
MySQL is a database management system, relational database, multithreading and multiuser with more than six million installations.
On one side is released under the GNU GPL for any use consistent with this license, but for companies that want to incorporate it into proprietary products the company should buy a specific license allowing them to use MySQL in their closed source products. MySQL is developed mostly in ANSI C.
Unlike projects like Apache, where software is developed by a public community code and copyright is held by the individual author, MySQL is owned and sponsored by a private company, which owns the copyright to most of the code.
This is what enables the licensing scheme mentioned above. Besides the sale of proprietary licenses, the company offers support and services. Hire workers for its operations around the world who collaborate via the Internet. MySQL AB was founded by David Axmark, Allan Larsson and Michael Widenius.
MySQL is widely used in web applications, like Drupal or phpBB, platforms (Linux / Windows-Apache-MySQL-PHP / Perl / Python), and bug tracking tools like Bugzilla. Its popularity as a Web application is closely tied to PHP, which often is in combination with MySQL. MySQL database is a very quick reading when you use non-transactional MyISAM engine, but may cause integrity problems in high concurrency environments such alterations. In web application there is low turnout in the modification of data and change the environment is data intensive reading, what makes MySQL ideal for these applications.
HostGator and MySQL
MySQL is very fast on host gator. In my almost 2 year hosting with them I never had problems with mysql what so ever. It’s very easy to create new database (you can have unlimted MySQL databases), and manage it with phpMyAdmin. The tools to create the database is MySQL databases tool and MySQL Database Wizard tool. When you want to connect to MySQL you need to create a user and add that user to the database with appropriate privileges. You can do this with the tools above. There is also an option for Remote SQl if you want to connect remotely to your database on hostgator.
