{"id":14190,"date":"2025-12-27T12:19:30","date_gmt":"2025-12-27T06:49:30","guid":{"rendered":"https:\/\/www.youstable.com\/blog\/?p=14190"},"modified":"2025-12-27T12:19:32","modified_gmt":"2025-12-27T06:49:32","slug":"create-mysql-on-linux","status":"publish","type":"post","link":"https:\/\/www.youstable.com\/blog\/create-mysql-on-linux","title":{"rendered":"How to Create MySQL on Linux Server in 2026? &#8211; Easy Guide"},"content":{"rendered":"\n<p><strong>To create MySQL on a Linux server<\/strong>, install the MySQL Server package, start and enable the service, run mysql_secure_installation, then create a database and user with proper privileges. <\/p>\n\n\n\n<p>Optionally open port 3306 in your firewall and configure remote access. The exact commands differ for Ubuntu\/Debian and RHEL\/CentOS\/Rocky systems.<\/p>\n\n\n\n<p>In this guide, you\u2019ll learn exactly how to create MySQL on a Linux server from scratch, including installation, security hardening, database\/user setup, firewall rules, tuning essentials, backups, and troubleshooting. <\/p>\n\n\n\n<p>Whether you use Ubuntu\/Debian or RHEL-based distros, you\u2019ll get copy-paste commands and practical, beginner-friendly tips.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"what-you-need-before-you-start-prerequisites\"><strong>What You Need Before You Start (Prerequisites)<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"533\" src=\"https:\/\/www.youstable.com\/blog\/wp-content\/uploads\/2025\/12\/image-111.png\" alt=\"Create MySQL on Linux\" class=\"wp-image-14560\" srcset=\"https:\/\/www.youstable.com\/blog\/wp-content\/uploads\/2025\/12\/image-111.png 800w, https:\/\/www.youstable.com\/blog\/wp-content\/uploads\/2025\/12\/image-111-150x100.png 150w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Linux server running <strong>Ubuntu\/Debian<\/strong> or RHEL\/CentOS\/Rocky (x86_64 is typical).<\/li>\n\n\n\n<li>SSH access with sudo or root privileges.<\/li>\n\n\n\n<li><strong>Package manager:<\/strong> apt (Ubuntu\/Debian) or dnf\/yum (RHEL family).<\/li>\n\n\n\n<li><strong>Optional:<\/strong> open TCP port 3306 if remote connections are required.<\/li>\n\n\n\n<li>Time sync enabled (chrony\/systemd-timesyncd) helps with SSL and logs.<\/li>\n<\/ul>\n\n\n\n<p><strong>Expert Tip:<\/strong> If you prefer a fast, clean start, YouStable\u2019s SSD VPS and Dedicated Servers ship with latest Linux images and quick-install options, helping you get MySQL production-ready with minimal overhead.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"mysql-vs-mariadb-which-should-you-install\"><strong>MySQL vs MariaDB: Which Should You Install?<\/strong><\/h2>\n\n\n\n<p>Many Linux repositories ship MariaDB by default. It\u2019s a high-performance fork of MySQL and 100% compatible for most apps. If you specifically need Oracle MySQL 8 (features like InnoDB Cluster, Enterprise plugins), use the official MySQL repositories.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Choose MySQL<\/strong> when your app or vendor requires MySQL 8.<\/li>\n\n\n\n<li><strong>Choose MariaDB<\/strong> when you want a drop-in replacement with broad distro support.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"install-mysql-on-ubuntu-debian\"><strong>Install MySQL on Ubuntu\/Debian<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"option-a-install-from-ubuntu-debian-repositories\"><strong>Option A: Install from Ubuntu\/Debian repositories<\/strong><\/h3>\n\n\n\n<p>Ubuntu LTS versions typically include MySQL 8 in the official repos. Debian may default to MariaDB if you use meta packages. To ensure MySQL (not MariaDB), install the mysql-server package on Ubuntu.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt update\nsudo apt install -y mysql-server\nsudo systemctl enable --now mysql\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"option-b-install-the-latest-from-the-official-mysql-apt-repository\"><strong>Option B: Install the latest from the official MySQL APT repository<\/strong><\/h3>\n\n\n\n<p>Use this when you want the newest MySQL 8.x from Oracle. Download the latest mysql-apt-config .deb from the MySQL website, then:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># replace the file name below with the latest available version\nwget https:\/\/dev.mysql.com\/get\/mysql-apt-config_0.8.29-1_all.deb\nsudo dpkg -i mysql-apt-config_0.8.29-1_all.deb\nsudo apt update\nsudo apt install -y mysql-server\nsudo systemctl enable --now mysql\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"install-mysql-on-rhel-centos-rocky-alma\"><strong>Install MySQL on RHEL\/CentOS\/Rocky\/Alma<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"option-a-install-mariadb-from-the-os-repository\"><strong>Option A: Install MariaDB from the OS repository<\/strong><\/h3>\n\n\n\n<p>This is the quickest route on RHEL-based systems if MariaDB is acceptable.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo dnf install -y mariadb-server\nsudo systemctl enable --now mariadb\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"option-b-install-mysql-8-from-the-official-mysql-yum-dnf-repository\"><strong>Option B: Install MySQL 8 from the official MySQL YUM\/DNF repository<\/strong><\/h3>\n\n\n\n<p>Use this when you explicitly need Oracle MySQL 8.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># EL9 example (Rocky\/Alma\/RHEL 9) - use the appropriate package for your OS version\nsudo dnf install -y https:\/\/dev.mysql.com\/get\/mysql80-community-release-el9-1.noarch.rpm\nsudo dnf install -y mysql-community-server\nsudo systemctl enable --now mysqld\n<\/code><\/pre>\n\n\n\n<p><strong>Note:<\/strong> On RHEL-based systems with MySQL 8, the initial temporary root password is logged to the error log (often \/var\/log\/mysqld.log). Check it if prompted.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"secure-the-installation\"><strong>Secure the Installation<\/strong><\/h2>\n\n\n\n<p>Run the included hardening script. It sets a strong root password, removes anonymous users, disables remote root login, and drops the test database.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql_secure_installation\n<\/code><\/pre>\n\n\n\n<p>Recommended answers: set a strong root password, remove anonymous users, disallow remote root login, remove test DB, and reload privilege tables.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"create-a-database-and-a-least-privilege-user\"><strong>Create a Database and a Least-Privilege User<\/strong><\/h2>\n\n\n\n<p>Connect to MySQL as root, create a database for your application, and grant least-privilege access to a dedicated user. Replace placeholders with your values.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql -u root -p\n\n-- inside the MySQL shell:\nCREATE DATABASE appdb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\nCREATE USER 'appuser'@'localhost' IDENTIFIED BY 'Str0ng!Passw0rd';\nGRANT ALL PRIVILEGES ON appdb.* TO 'appuser'@'localhost';\nFLUSH PRIVILEGES;\nEXIT;\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"open-the-firewall-optional-for-remote-access\"><strong>Open the Firewall (Optional, for Remote Access)<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"ubuntu-debian-ufw\"><strong>Ubuntu\/Debian (UFW)<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo ufw allow 3306\/tcp\nsudo ufw status\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"rhel-centos-rocky-firewalld\"><strong>RHEL\/CentOS\/Rocky (firewalld)<\/strong><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo firewall-cmd --add-service=mysql --permanent\nsudo firewall-cmd --reload\nsudo firewall-cmd --list-all\n<\/code><\/pre>\n\n\n\n<p>Security tip: Restrict inbound 3306 to specific IPs using cloud security groups or firewall rules. Never expose MySQL widely to the internet.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"enable-remote-connections-safely\"><strong>Enable Remote Connections (Safely)<\/strong><\/h2>\n\n\n\n<p>If your app server connects from another host, bind MySQL to a non-loopback address and create a user for that host. Edit the MySQL config file and restart.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Ubuntu\/Debian\nsudo nano \/etc\/mysql\/mysql.conf.d\/mysqld.cnf\n\n# RHEL family\nsudo nano \/etc\/my.cnf\n\n# set or adjust:\nbind-address = 0.0.0.0\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code># Restart service after changes\n# Ubuntu\/Debian:\nsudo systemctl restart mysql\n\n# RHEL family:\nsudo systemctl restart mysqld\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code># Create a user allowed from a specific IP (preferred)\nsudo mysql -u root -p\n\nCREATE USER 'appuser'@'203.0.113.10' IDENTIFIED BY 'Str0ng!Passw0rd';\nGRANT ALL PRIVILEGES ON appdb.* TO 'appuser'@'203.0.113.10';\nFLUSH PRIVILEGES;\nEXIT;\n<\/code><\/pre>\n\n\n\n<p>Prefer specific host entries over \u2019%\u2019 wildcards. Use SSL\/TLS for production, and place MySQL behind a private network or VPN whenever possible.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"verify-connectivity\"><strong>Verify Connectivity<\/strong><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code># Local\nmysql -u appuser -p -h 127.0.0.1 -D appdb -e \"SELECT 1;\"\n\n# Remote from the app host\nmysql -u appuser -p -h &lt;mysql_server_ip&gt; -D appdb -e \"SHOW TABLES;\"\n<\/code><\/pre>\n\n\n\n<p>If the client cannot connect, test the port first and then review logs.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>nc -vz &lt;mysql_server_ip&gt; 3306\n# Logs (Ubuntu\/Debian)\nsudo journalctl -u mysql --no-pager\n# Logs (RHEL family)\nsudo journalctl -u mysqld --no-pager\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"essential-performance-tuning-safe-defaults\"><strong>Essential Performance Tuning (Safe Defaults)<\/strong><\/h2>\n\n\n\n<p>Adjust these parameters for better baseline performance on small to medium instances. Size the buffer pool to 50\u201370% of available RAM on dedicated DB nodes.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;mysqld]\ninnodb_buffer_pool_size = 1G\ninnodb_log_file_size = 256M\nmax_connections = 200\nslow_query_log = 1\nslow_query_log_file = \/var\/log\/mysql\/slow.log\nlong_query_time = 1\n# bind-address = 127.0.0.1  # lock to localhost when remote access not needed\n<\/code><\/pre>\n\n\n\n<p>After changes, restart MySQL and monitor with SHOW GLOBAL STATUS and the slow query log. For heavier loads, evaluate connection pooling (ProxySQL\/Haproxy) and proper indexing.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"backup-and-restore\"><strong>Backup and Restore<\/strong><\/h2>\n\n\n\n<p>Take logical backups with mysqldump for smaller datasets or nightly backups. Use &#8211;single-transaction to avoid locking InnoDB tables.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Backup a single database\nmysqldump -u root -p --single-transaction --routines --triggers appdb &gt; appdb_$(date +%F).sql\n\n# Restore\nmysql -u root -p appdb &lt; appdb_2025-01-01.sql\n<\/code><\/pre>\n\n\n\n<p>For large, busy databases, consider physical backups (LVM snapshots, MySQL Enterprise Backup, Percona XtraBackup) and test restores regularly.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"ongoing-maintenance\"><strong>Ongoing Maintenance<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Patch regularly:<\/strong> apt\/dnf updates and minor MySQL upgrades (test first).<\/li>\n\n\n\n<li><strong>Monitor logs:<\/strong> error log, slow query log, and system journal.<\/li>\n\n\n\n<li><strong>Check disk\/IO:<\/strong> data directory free space and IOPS headroom.<\/li>\n\n\n\n<li><strong>Backups: <\/strong>automate and verify with periodic restore drills.<\/li>\n\n\n\n<li><strong>Security:<\/strong> restrict 3306, rotate credentials, <a href=\"https:\/\/www.youstable.com\/blog\/how-to-enable-ssl-in-cpanel\/\">enable SSL<\/a> for remote apps.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"troubleshooting-common-issues\"><strong>Troubleshooting Common Issues<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Port 3306 blocked:<\/strong> open firewall or security group; verify nc -vz.<\/li>\n\n\n\n<li><strong>Authentication plugin mismatch:<\/strong> older clients may not support caching_sha2_password (MySQL 8 default). Prefer upgrading clients; otherwise, adjust the user plugin:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER USER 'appuser'@'%' IDENTIFIED WITH mysql_native_password BY 'Str0ng!Passw0rd';\nFLUSH PRIVILEGES;\n<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>SELinux (RHEL family):<\/strong> ensure mysqld can listen on 3306 and access datadir. Use setsebool and proper contexts if you move the datadir.<\/li>\n\n\n\n<li><strong>Service won\u2019t start:<\/strong> check journalctl and error log for datadir permissions or my.cnf syntax errors.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"when-to-choose-managed-or-assisted-setup\"><strong>When to Choose Managed or Assisted Setup<\/strong><\/h2>\n\n\n\n<p>If you want to skip hand-rolling security, backups, and tuning, consider a <a href=\"https:\/\/www.youstable.com\/blog\/benefits-of-fully-managed-dedicated-server\/\">managed VPS or Dedicated Server<\/a>. At YouStable, our engineers can pre-harden MySQL, set up automated backups, and optimize configs for your workload, so you focus on your application instead of server plumbing.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"full-quick-start-end-to-end-commands-ubuntu-example\"><strong>Full Quick-Start: End-to-End Commands (Ubuntu Example)<\/strong><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code># 1) Install\nsudo apt update\nsudo apt install -y mysql-server\nsudo systemctl enable --now mysql\n\n# 2) Secure\nsudo mysql_secure_installation\n\n# 3) Create DB and user\nsudo mysql -u root -p -e \"CREATE DATABASE appdb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\"\nsudo mysql -u root -p -e \"CREATE USER 'appuser'@'localhost' IDENTIFIED BY 'Str0ng!Passw0rd';\"\nsudo mysql -u root -p -e \"GRANT ALL PRIVILEGES ON appdb.* TO 'appuser'@'localhost'; FLUSH PRIVILEGES;\"\n\n# 4) (Optional) Allow remote access\nsudo sed -i 's\/^bind-address.*\/bind-address = 0.0.0.0\/' \/etc\/mysql\/mysql.conf.d\/mysqld.cnf\nsudo systemctl restart mysql\nsudo ufw allow 3306\/tcp\n\n# 5) Test\nmysql -u appuser -p -h 127.0.0.1 -D appdb -e \"SELECT 1;\"\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"conclusion\"><strong>Conclusion<\/strong><\/h2>\n\n\n\n<p>That\u2019s how to create MySQL on a Linux server the right way: install, secure, grant least-privilege, optionally enable remote access, and maintain with backups and tuning. Follow these steps and you\u2019ll have a production-ready database foundation that\u2019s secure, reliable, and fast.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" class=\"wp-block-heading\" id=\"faqs\"><strong>FAQ&#8217;s<\/strong><\/h2>\n\n\n<div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1765955143370\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"is-mysql-or-mariadb-better-for-my-linux-server\"><strong>Is MySQL or MariaDB better for my Linux server?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>If your application or vendor explicitly requires MySQL 8 features, choose MySQL. If not, MariaDB is a stable, high-performance alternative with excellent distro support. Both are widely used in production.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765955163875\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"how-do-i-change-the-mysql-root-password-safely\"><strong>How do I change the MySQL root password safely?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Use mysql_secure_installation to set or change root securely. Alternatively, login as root and run ALTER USER \u2018root\u2019@\u2019localhost\u2019 IDENTIFIED BY \u2018NewStrongPass\u2019; then FLUSH PRIVILEGES; and restart MySQL if needed.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765955173473\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"how-can-i-allow-mysql-remote-access-only-from-one-ip\"><strong>How can I allow MySQL remote access only from one IP?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Set bind-address to 0.0.0.0, open port 3306 for that IP in the firewall, and create a user bound to that host, for example \u2018appuser\u2019@\u2019203.0.113.10\u2019. Avoid wildcard hosts like \u2018%\u2019 in production.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765955181335\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"what-port-does-mysql-use-and-should-i-change-it\"><strong>What port does MySQL use and should I change it?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>MySQL listens on TCP 3306 by default. You can change it in my.cnf (port=3306). Security isn\u2019t achieved by obscurity alone, so pair any port change with firewall restrictions, strong auth, and TLS.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1765955191762\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \" class=\"rank-math-question \" id=\"how-do-i-back-up-mysql-without-downtime\"><strong>How do I back up MySQL without downtime?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Use mysqldump with &#8211;single-transaction for InnoDB to get a consistent snapshot without table locks. For very large databases, use physical backup tools and consider replicas for near-zero-impact backups.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>To create MySQL on a Linux server, install the MySQL Server package, start and enable the service, run mysql_secure_installation, then [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":16366,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"iawp_total_views":5,"footnotes":""},"categories":[350],"tags":[],"class_list":["post-14190","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-knowledgebase"],"acf":[],"featured_image_src":"https:\/\/www.youstable.com\/blog\/wp-content\/uploads\/2025\/12\/How-to-Create-MySQL-on-Linux-Server.jpg","author_info":{"display_name":"Sanjeet Chauhan","author_link":"https:\/\/www.youstable.com\/blog\/author\/sanjeet"},"_links":{"self":[{"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/posts\/14190","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/comments?post=14190"}],"version-history":[{"count":5,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/posts\/14190\/revisions"}],"predecessor-version":[{"id":14562,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/posts\/14190\/revisions\/14562"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/media\/16366"}],"wp:attachment":[{"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/media?parent=14190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/categories?post=14190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.youstable.com\/blog\/wp-json\/wp\/v2\/tags?post=14190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}