MySQL (officially pronounced as /maɪ ˌɛskjuːˈɛl/ "My S-Q-L") is an open-source relational database management system (RDBMS). In July 2013, it was the world's second most[a] widely used RDBMS, and the most widely used open-source client–server model RDBMS.[9] It is named after Michael Widenius' (who is a co-founder of MySQL) daughter, My, while "SQL" stands as the abbreviation for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation. For proprietary use, several paid editions are available, and offer additional functionality.
MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open-source web application software stack (and other "AMP" stacks). LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python". Free-software open-source projects that require a full-featured database management system often use MySQL. Applications that use the MySQL database include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, Drupal and other software. MySQL is also used in many high-profile, large-scale websites, including Google (though not for searches), Facebook ,Twitter,Flickr and YouTube.
On all platforms except Windows, MySQL ships with no GUI tools to administer MySQL databases or manage data contained within the databases. Users may use the included command line tools, or install MySQL Workbench via a separate download. Many third party GUI tools are also available.
Steps to install , configure and allow remote access in mysql server
1. Install the mysql rpms using yum “ yum install mysql ”. If you are facing any issues with yum please refer my previous post on yum issues.
2. Start mysqld service using “service mysqld start”
3. Configure your mysql database using “/usr/bin/mysql_secure_installation”
4. Now login to you mysql server using “mysql –u root -p” and enter the mysql root password which you have given in last step.
5. Now you can create database in your mysql server using “create database mysqldbtst;”
6. Now switch to mysqldbtst database using “use mysqldbtst;”
7. Grand access to the database using “grant all privileges on Testdb to 'testuser'@'%' identified by 'Test@123';”
