{"id":85,"date":"2007-03-19T00:27:55","date_gmt":"2007-03-19T06:27:55","guid":{"rendered":"http:\/\/blog.supportpro.com\/?p=85"},"modified":"2026-02-23T01:37:53","modified_gmt":"2026-02-23T07:37:53","slug":"mysql-basics","status":"publish","type":"post","link":"https:\/\/www.supportpro.com\/blog\/mysql-basics\/","title":{"rendered":"Complete MySQL Guide: Installation, Commands, Backup &amp; Administration"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">What Is MySQL?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL (pronounced <em>\u201cMy Ess Cue El\u201d<\/em>) is one of the world\u2019s most popular open-source relational database management systems (RDBMS).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It uses <strong>Structured Query Language (SQL)<\/strong> to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create databases<\/li>\n\n\n\n<li>Store and retrieve data<\/li>\n\n\n\n<li>Modify records<\/li>\n\n\n\n<li>Manage users and permissions<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL is widely known for:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Speed<\/li>\n\n\n\n<li>Reliability<\/li>\n\n\n\n<li>Scalability<\/li>\n\n\n\n<li>Flexibility<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">It powers millions of websites and applications worldwide.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Advantages of MySQL<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Here are some key benefits:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Multithreaded Architecture<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL supports multiple concurrent connections without significantly impacting performance.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Broad Language Support<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">It integrates with many programming languages including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>PHP<\/li>\n\n\n\n<li>Java<\/li>\n\n\n\n<li>C\/C++<\/li>\n\n\n\n<li>Python<\/li>\n\n\n\n<li>Perl<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">3. Open Source &amp; Cost Effective<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL Community Edition is free to download and use.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4. Cross-Platform Compatibility<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Works on Linux, Windows, macOS, and Unix systems.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Installing MySQL on Linux<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">Using RPM (RedHat \/ CentOS)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Search for available packages:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>yum search mysql-server<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Install the package:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>yum install mysql-server<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Using DEB (Debian \/ Ubuntu)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Search:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-cache search mysql-server<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Install:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-get install mysql-server<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Installing from Source<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Download the source file:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>wget mysql.tar.gz<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Extract:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>tar zxvf mysql.tar.gz<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Configure:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>.\/configure<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Starting and Stopping MySQL<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">The MySQL service can be controlled in multiple ways.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Using service command<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>service mysqld start<br>service mysqld stop<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Using init.d<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>\/etc\/init.d\/mysqld start<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Using systemctl (modern systems)<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl start mysqld<br>systemctl stop mysqld<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The MySQL server is started by the <code>mysqld<\/code> daemon, often through <code>mysqld_safe<\/code>.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">MySQL Storage Engines<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Storage engines define how data is stored and managed.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">ISAM<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Non-transactional<\/li>\n\n\n\n<li>Stored in <code>.frm<\/code>, <code>.ISD<\/code>, <code>.ISM<\/code> files<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">MyISAM<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Improved version of ISAM<\/li>\n\n\n\n<li>Faster for read-heavy workloads<\/li>\n\n\n\n<li>Stored in <code>.frm<\/code>, <code>.MYD<\/code>, <code>.MYI<\/code> files<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">InnoDB<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Transaction-safe<\/li>\n\n\n\n<li>Supports commit &amp; rollback<\/li>\n\n\n\n<li>Crash recovery capable<\/li>\n\n\n\n<li>Default engine in modern MySQL versions<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">For production systems, <strong>InnoDB<\/strong> is recommended.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Basic MySQL Commands<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Login as root:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root -p<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Create Database<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE DATABASE sampledb;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Drop Database<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP DATABASE sampledb;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Use Database<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>USE sampledb;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Create Table<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE president (<br>  last_name VARCHAR(15) NOT NULL,<br>  first_name VARCHAR(15) NOT NULL<br>);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Show Tables<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW TABLES;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Describe Table<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>DESCRIBE president;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">MySQL User Permissions<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Grant privileges:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT ALL ON *.* TO 'db_user'@'localhost' IDENTIFIED BY 'password';<br>FLUSH PRIVILEGES;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This assigns full privileges to a user.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">Backing Up Databases Using mysqldump<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">Backup Database<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump -u root -p mydatabase &gt; backup.sql<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Restore Backup<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql mydatabase &lt; backup.sql<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Transfer Database to Remote Server<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump mydatabase | mysql -h remote_ip newdatabase<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">MySQL Administration with mysqladmin<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\"><code>mysqladmin<\/code> allows administrative operations.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Examples:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Create database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqladmin create data<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Show process list:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqladmin processlist<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Check server status:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqladmin status<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">MySQL &amp; PHP Integration<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">To enable MySQL support in PHP:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>yum search php-mysql<br>yum install php-mysql<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">On WHM servers:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">WHM \u2192 Apache Update \u2192 PHP Modules \u2192 Enable MySQL Module<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Simple PHP connection example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php<br>mysql_connect(\"localhost\",\"admin\",\"passwd\") or die(mysql_error());<br>echo \"Connected to MySQL\";<br>?&gt;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">MySQL in cPanel &amp; WHM<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Every cPanel \/ WHM server includes MySQL by default.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Restart MySQL via WHM<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">WHM \u2192 Restart Services \u2192 MySQL<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Or via shell:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/scripts\/restartsrv_mysql<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Optimizing MySQL (my.cnf)<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Configuration file location:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/etc\/my.cnf<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Sample structure:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;mysqld]<br>datadir=\/var\/lib\/mysql<br>socket=\/var\/lib\/mysql\/mysql.sock<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Key tuning parameters:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>innodb_buffer_pool_size<\/li>\n\n\n\n<li>max_connections<\/li>\n\n\n\n<li>query_cache_size<\/li>\n\n\n\n<li>table_open_cache<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Proper tuning improves performance significantly.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">MySQL Monitoring Tools<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">MTOP<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Monitors queries and performance statistics.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">MKILL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Kills long-running MySQL queries automatically.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">FAQ<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">Is MySQL free?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Yes, MySQL Community Edition is open-source and free.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Which storage engine should I use?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In most cases, InnoDB is recommended for reliability and transaction support.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How do I restart MySQL safely?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Use <code>systemctl restart mysqld<\/code> or restart via WHM.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you require help, <a href=\"https:\/\/www.supportpro.com\/requestquote.php\">contact SupportPRO Server Admin<\/a><\/p>\n\n\n\n<p class=\"has-text-align-center wp-block-paragraph\"><span id=\"hs-cta-wrapper-9d590242-d641-4383-94b4-8cfd62f0af6b\" class=\"hs-cta-wrapper\"><span id=\"hs-cta-9d590242-d641-4383-94b4-8cfd62f0af6b\" class=\"hs-cta-node hs-cta-9d590242-d641-4383-94b4-8cfd62f0af6b\"><a href=\"https:\/\/www.supportpro.com\/freecheckup.php\"><img decoding=\"async\" id=\"hs-cta-img-9d590242-d641-4383-94b4-8cfd62f0af6b\" class=\"hs-cta-img\" style=\"border-width: 0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/2725694\/9d590242-d641-4383-94b4-8cfd62f0af6b.png\" alt=\"Server not running properly? Get A FREE Server Checkup By Expert Server Admins - $125 Value\"><\/a><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>What Is MySQL? MySQL (pronounced \u201cMy Ess Cue El\u201d) is one of the world\u2019s most popular open-source relational database management systems (RDBMS). It uses Structured Query Language (SQL) to: MySQL&hellip;<\/p>\n","protected":false},"author":4,"featured_media":15609,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-85","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technical-articles"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts\/85","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/comments?post=85"}],"version-history":[{"count":8,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts\/85\/revisions"}],"predecessor-version":[{"id":15610,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts\/85\/revisions\/15610"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/media\/15609"}],"wp:attachment":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/media?parent=85"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/categories?post=85"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/tags?post=85"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}