{"id":1083,"date":"2019-11-13T10:41:02","date_gmt":"2019-11-13T16:41:02","guid":{"rendered":"https:\/\/www.linuxcloudvps.com\/blog\/?p=1083"},"modified":"2019-11-13T10:41:02","modified_gmt":"2019-11-13T16:41:02","slug":"how-to-install-mariadb-on-ubuntu-18-04","status":"publish","type":"post","link":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/","title":{"rendered":"How to Install MariaDB on Ubuntu 18.04"},"content":{"rendered":"

In this article, we will show you two different methods on how to install MariaDB on your Ubuntu 18.04 Cloud VPS<\/a>.<\/p>\n

\"\"MariaDB is an open-source database server that is a fork of MySQL and can easily serve as a drop-in replacement.
\nIn the first installation method, we will use the official Ubuntu repository, while the second installation method we will install the latest version of MariaDB from the official MariaDB repositories.<\/p>\n

<\/p>\n

Before proceeding with our installation methods, make sure you are logged in as root or a user with sudo privileges.<\/p>\n

Step 1: Log in via SSH on the Ubuntu server:<\/h2>\n
ssh root@<span style="color: #ff0000;">Server_IP_Address<\/span> -p <span style="color: #ff0000;">Port_number<\/span><\/pre>\n
Make sure to replace “Server_IP_Address<\/span>” and “Port_number<\/span>” with your server’s public IP address and SSH port number (if necessary).<\/p>\n
Step 2: Update all packages<\/h2>\n
The first thing to do when you are logged in is to make sure that all the installed packages are up to date:<\/p>\n
sudo apt update\r\nsudo apt upgrade<\/pre>\n
Step 3: Installing MariaDB<\/h2>\n
Method 1: Installing MariaDB on Ubuntu 18.04 from the Ubuntu repositories<\/h3>\n
At the time of writing this article, the latest version of MariaDB available from the official Ubuntu repositories is MariaDB version 10.1.34.<\/p>\n
Once our system is up to date, we will install MariaDB from the Ubuntu repositories with the following steps.<\/p>\n
Step 1:\u00a0<\/strong>Install MariaDB by running the following command:<\/p>\n
sudo apt install mariadb-server<\/pre>\n
Step 2:\u00a0<\/strong>The MariaDB service after the installation will start automatically. We will check the status by typing:<\/p>\n
sudo systemctl status mariadb<\/pre>\n
Output:<\/p>\n
\u25cf mariadb.service - MariaDB 10.1.34 database server\r\nLoaded: loaded (\/lib\/systemd\/system\/mariadb.service; enabled; vendor preset: enabled)\r\nActive: active (running) since Sat 2019-01-26 02:50:17 CST; 22s ago\r\nDocs: man:mysqld(8)\r\nhttps:\/\/mariadb.com\/kb\/en\/library\/systemd\/\r\nMain PID: 10214 (mysqld)\r\nStatus: "Taking your SQL requests now..."\r\nTasks: 27 (limit: 2320)\r\nCGroup: \/system.slice\/mariadb.service\r\n\u2514\u250010214 \/usr\/sbin\/mysqld<\/pre>\n
Step 3:\u00a0<\/strong>We will check the MariaDB version with this command:<\/p>\n
mysql -V<\/pre>\n
Output:<\/p>\n
mysql Ver 15.1 Distrib 10.1.34-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2<\/pre>\n
Method 2: Installing MariaDB on Ubuntu 18.04 from the MariaDB Repositories<\/h3>\n
At the time of writing this article, the latest version of MariaDB available from the MariaDB repositories is version 10.3. You can always check for if the new version is available by visiting the MariaDB Repository page<\/a>.<\/p>\n
To install MariaDB version 10.3 on your Ubuntu 18.04 server, follow these steps:<\/p>\n
Step 1:\u00a0<\/strong>With the command below, we will add the MariaDB GPG key to our system:<\/p>\n
sudo apt-key adv --recv-keys --keyserver hkp:\/\/keyserver.ubuntu.com:80 0xF1656F24C74CD1D8<\/pre>\n
Output:<\/p>\n
Executing: \/tmp\/apt-key-gpghome.8jprLzE53p\/gpg.1.sh --recv-keys --keyserver hkp:\/\/keyserver.ubuntu.com:80 0xF1656F24C74CD1D8\r\ngpg: key F1656F24C74CD1D8: 6 signatures not checked due to missing keys\r\ngpg: key F1656F24C74CD1D8: public key "MariaDB Signing Key <signing-key@mariadb.org>" imported\r\ngpg: Total number processed: 1\r\ngpg: imported: 1<\/pre>\n
Step 2:\u00a0<\/strong>We will add the MariaDB repository by executing the following command:<\/p>\n
sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http:\/\/ftp.utexas.edu\/mariadb\/repo\/10.3\/ubuntu bionic main'<\/pre>\n
Step 3:\u00a0<\/strong>We will now update the list of packages so we can install the latest version of MariaDB from the repository we added in the previous step.<\/p>\n
sudo apt update<\/pre>\n
Step 4:\u00a0<\/strong>Considering that the repository is now added, we will run the following command to install the MariaDB package:<\/p>\n
sudo apt install mariadb-server<\/pre>\n
Step 5:\u00a0<\/strong>To verify that MariaDB service is running, we will run the command:<\/p>\n
sudo systemctl status mariadb<\/pre>\n
Output:<\/p>\n
\u25cf mariadb.service - MariaDB 10.3.12 database server\r\nLoaded: loaded (\/lib\/systemd\/system\/mariadb.service; enabled; vendor preset: enabled)\r\nDrop-In: \/etc\/systemd\/system\/mariadb.service.d\r\n\u2514\u2500migrated-from-my.cnf-settings.conf\r\nActive: active (running) since Sat 2019-01-26 03:12:52 CST; 10s ago\r\nDocs: man:mysqld(8)\r\nhttps:\/\/mariadb.com\/kb\/en\/library\/systemd\/\r\nProcess: 12496 ExecStartPost=\/bin\/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0\/SUCCESS)\r\nProcess: 12493 ExecStartPost=\/etc\/mysql\/debian-start (code=exited, status=0\/SUCCESS)\r\nProcess: 12387 ExecStartPre=\/bin\/sh -c [ ! -e \/usr\/bin\/galera_recovery ] && VAR= || VAR=`\/usr\/bin\/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0\/SUCCESS)\r\nProcess: 12385 ExecStartPre=\/bin\/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0\/SUCCESS)\r\nProcess: 12384 ExecStartPre=\/usr\/bin\/install -m 755 -o mysql -g root -d \/var\/run\/mysqld (code=exited, status=0\/SUCCESS)\r\nMain PID: 12462 (mysqld)\r\nStatus: "Taking your SQL requests now..."\r\nTasks: 31 (limit: 2320)\r\nCGroup: \/system.slice\/mariadb.service\r\n\u2514\u250012462 \/usr\/sbin\/mysqld<\/pre>\n
Step 6:\u00a0<\/strong>We can also print the MariaDB version by typing:<\/p>\n
mysql -V<\/pre>\n
Output:<\/p>\n
mysql Ver 15.1 Distrib 10.3.12-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2<\/pre>\n
Securing MariaDB<\/h2>\n
At this point of this article, we have MariaDB installed on the server, and now by running the mysql_secure_installation command, we can improve the security of the MariaDB server.<\/p>\n
sudo mysql_secure_installation<\/pre>\n
After the execution of the command, the script will prompt you to set up the root user password, remove the anonymous user, restrict root user access to the local machine and remove the test database.<\/p>\n
Output:<\/p>\n
In order to log into MariaDB to secure it, we'll need the current\r\npassword for the root user. If you've just installed MariaDB, and\r\nyou haven't set the root password yet, the password will be blank,\r\nso you should just press enter here.\r\n\r\nEnter current password for root (enter for none):\r\n\r\nSetting the root password ensures that nobody can log into the MariaDB\r\nroot user without the proper authorisation.\r\n\r\nSet root password? [Y\/n] y\r\nNew password:\r\nRe-enter new password:\r\n\r\nBy default, a MariaDB installation has an anonymous user, allowing anyone\r\nto log into MariaDB without having to have a user account created for\r\nthem. This is intended only for testing, and to make the installation\r\ngo a bit smoother. You should remove them before moving into a\r\nproduction environment.\r\n\r\nRemove anonymous users? [Y\/n] y\r\n... Success!\r\n\r\nNormally, root should only be allowed to connect from 'localhost'. This\r\nensures that someone cannot guess at the root password from the network.\r\n\r\nDisallow root login remotely? [Y\/n] y\r\n... Success!\r\n\r\nBy default, MariaDB comes with a database named 'test' that anyone can\r\naccess. This is also intended only for testing, and should be removed\r\nbefore moving into a production environment.\r\n\r\nRemove test database and access to it? [Y\/n] y\r\n- Dropping test database...\r\n... Success!\r\n- Removing privileges on test database...\r\n... Success!\r\n\r\nReloading the privilege tables will ensure that all changes made so far\r\nwill take effect immediately.\r\n\r\nReload privilege tables now? [Y\/n] y\r\n... Success!\r\n\r\nCleaning up...\r\n\r\nAll done! If you've completed all of the above steps, your MariaDB\r\ninstallation should now be secure.<\/pre>\n
In the upper output, we can see that all steps are explained in detail and it is recommended to answer \u201cY\u201d (yes) to all questions.<\/p>\n
Restart your MariaDB server when done:<\/p>\n
sudo systemctl restart mariadb.service<\/pre>\n
Configuring the MariaDB Database Server<\/h2>\n
If we want to make any changes in order to optimize the database server performance, we can edit the MariaDB default configuration file located at \/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code><\/p>\n
sudo nano \/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/pre>\n
After making any changes, you need to restart the database server:<\/p>\n
sudo systemctl restart mariadb.service<\/pre>\n
MariaDB Administration Commands<\/h2>\n
In the last section of this article, we will discuss some useful MariaDB commands. These commands are some of the basic commands that will help you get started with using MariaDB.<\/p>\n
Connect to MariaDB from the Command Line<\/strong><\/h3>\n
The first and most basic command is the command used to log into the MariaDB command line interface:<\/p>\n
mysql -u root -p<\/pre>\n
After running the command above, you will get prompted for the root password. Enter the password to log in to the session.<\/p>\n
Output:<\/p>\n
Enter password:\r\nWelcome to the MariaDB monitor. Commands end with ; or \\g.\r\nYour MariaDB connection id is 46\r\nServer version: 10.3.12-MariaDB-1:10.3.12+maria~bionic mariadb.org binary distribution\r\n\r\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMariaDB [(none)]><\/pre>\n
Checking the Version of your MariaDB Installation<\/strong><\/h3>\n
Check a detailed view of the current version of your MariaDB installation.<\/p>\n
mysqladmin -u root version<\/pre>\n
Output:<\/p>\n
mysqladmin Ver 9.1 Distrib 10.3.12-MariaDB, for debian-linux-gnu on x86_64\r\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\r\n\r\nServer version 10.3.12-MariaDB-1:10.3.12+maria~bionic\r\nProtocol version 10\r\nConnection Localhost via UNIX socket\r\nUNIX socket \/var\/run\/mysqld\/mysqld.sock\r\nUptime: 6 min 43 sec\r\n\r\nThreads: 7 Questions: 460 Slow queries: 0 Opens: 184 Flush tables: 1 Open tables: 31 Queries per second avg: 1.141<\/pre>\n
Showing All Databases<\/strong><\/h3>\n
You can list all the databases that your MariaDB currently has with this simple command:<\/p>\n
show databases;<\/pre>\n
List All Users in MariaDB<\/strong><\/h3>\n
Type the following query at the MariaDB [(none)]> prompt to see\/list the users in a MySQL database:<\/p>\n
SELECT User, Host FROM mysql.user;<\/pre>\n
Output:\r\n\r\n+------------------+-----------+\r\n| User             | Host      |\r\n+------------------+-----------+\r\n| debian-sys-maint | localhost |\r\n| root             | localhost |\r\n+------------------+-----------+\r\n2 rows in set (0.001 sec)<\/pre>\n
Creating New Databases<\/strong><\/h3>\n
If we want to create a new database in MariaDB, we can run the command below:<\/p>\n
CREATE DATABASE our_database;<\/pre>\n
Where our_database<\/code> is the name of the new database created.<\/p>\n
These are just some of the basic commands that let you manipulate your databases. The capabilities of MariaDB are far greater than this, so we recommend reading some of the official documentation to help you get a grip on how to effectively use this excellent database management platform.<\/p>\n
\n
\"\"Of course, if you are one of our Cloud VPS Hosting<\/a>\u00a0customers, you don\u2019t have to install MariaDB\u00a0on your Ubuntu 18.04 Cloud VPS<\/a>\u00a0– simply ask our admins, sit back and relax. Our admins will install MariaDB on Ubuntu 18.04 for you immediately.<\/p>\n
PS.<\/code>If you liked this post about how to install MariaDB on an Ubuntu 18.04 Cloud VPS, please share it with your friends on the social networks using the share shortcuts, or simply leave a comment in the comments section. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"
In this article, we will show you two different methods on how to install MariaDB on your Ubuntu 18.04 Cloud VPS. MariaDB is an open-source database server that is a fork of MySQL and can easily serve as a drop-in replacement. In the first installation method, we will use the official Ubuntu repository, while the … Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":1085,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-1083","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials"],"yoast_head":"\nHow to Install MariaDB on Ubuntu 18.04 | LinuxCloudVPS Blog<\/title>\n<meta name=\"description\" content=\"In this article, we will show you two different methods on how to install MariaDB on your Ubuntu 18.04 Cloud VPS. MariaDB is an open-source database\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Install MariaDB on Ubuntu 18.04 | LinuxCloudVPS Blog\" \/>\n<meta property=\"og:description\" content=\"In this article, we will show you two different methods on how to install MariaDB on your Ubuntu 18.04 Cloud VPS. MariaDB is an open-source database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/\" \/>\n<meta property=\"og:site_name\" content=\"LinuxCloudVPS Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/LinuxCloudVPS\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-13T16:41:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2019\/11\/how-to-install-mariadb-on-ubuntu18.04.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@LinuxCloudVPS\" \/>\n<meta name=\"twitter:site\" content=\"@LinuxCloudVPS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-mariadb-on-ubuntu-18-04\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-mariadb-on-ubuntu-18-04\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#\\\/schema\\\/person\\\/ed907227ee7d151c617e6d0fe74f531a\"},\"headline\":\"How to Install MariaDB on Ubuntu 18.04\",\"datePublished\":\"2019-11-13T16:41:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-mariadb-on-ubuntu-18-04\\\/\"},\"wordCount\":842,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-mariadb-on-ubuntu-18-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/how-to-install-mariadb-on-ubuntu18.04.jpg\",\"articleSection\":[\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-mariadb-on-ubuntu-18-04\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-mariadb-on-ubuntu-18-04\\\/\",\"url\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-mariadb-on-ubuntu-18-04\\\/\",\"name\":\"How to Install MariaDB on Ubuntu 18.04 | LinuxCloudVPS Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-mariadb-on-ubuntu-18-04\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-mariadb-on-ubuntu-18-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/how-to-install-mariadb-on-ubuntu18.04.jpg\",\"datePublished\":\"2019-11-13T16:41:02+00:00\",\"description\":\"In this article, we will show you two different methods on how to install MariaDB on your Ubuntu 18.04 Cloud VPS. MariaDB is an open-source database\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-mariadb-on-ubuntu-18-04\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-mariadb-on-ubuntu-18-04\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-mariadb-on-ubuntu-18-04\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/how-to-install-mariadb-on-ubuntu18.04.jpg\",\"contentUrl\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/how-to-install-mariadb-on-ubuntu18.04.jpg\",\"width\":750,\"height\":360},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-mariadb-on-ubuntu-18-04\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install MariaDB on Ubuntu 18.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/\",\"name\":\"LinuxCloudVPS\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#organization\",\"name\":\"LinuxCloudVPS\",\"url\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/logo.png\",\"width\":217,\"height\":25,\"caption\":\"LinuxCloudVPS\"},\"image\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"http:\\\/\\\/www.facebook.com\\\/LinuxCloudVPS\",\"https:\\\/\\\/x.com\\\/LinuxCloudVPS\",\"http:\\\/\\\/www.linkedin.com\\\/company\\\/linuxcloudvps-com\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#\\\/schema\\\/person\\\/ed907227ee7d151c617e6d0fe74f531a\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"http:\\\/\\\/www.linuxcloudvps.com\\\/\"],\"url\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/author\\\/r0s3admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Install MariaDB on Ubuntu 18.04 | LinuxCloudVPS Blog","description":"In this article, we will show you two different methods on how to install MariaDB on your Ubuntu 18.04 Cloud VPS. MariaDB is an open-source database","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/","og_locale":"en_US","og_type":"article","og_title":"How to Install MariaDB on Ubuntu 18.04 | LinuxCloudVPS Blog","og_description":"In this article, we will show you two different methods on how to install MariaDB on your Ubuntu 18.04 Cloud VPS. MariaDB is an open-source database","og_url":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/","og_site_name":"LinuxCloudVPS Blog","article_publisher":"http:\/\/www.facebook.com\/LinuxCloudVPS","article_published_time":"2019-11-13T16:41:02+00:00","og_image":[{"width":750,"height":360,"url":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2019\/11\/how-to-install-mariadb-on-ubuntu18.04.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@LinuxCloudVPS","twitter_site":"@LinuxCloudVPS","twitter_misc":{"Written by":"admin","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/#article","isPartOf":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/"},"author":{"name":"admin","@id":"https:\/\/www.linuxcloudvps.com\/blog\/#\/schema\/person\/ed907227ee7d151c617e6d0fe74f531a"},"headline":"How to Install MariaDB on Ubuntu 18.04","datePublished":"2019-11-13T16:41:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/"},"wordCount":842,"commentCount":0,"publisher":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2019\/11\/how-to-install-mariadb-on-ubuntu18.04.jpg","articleSection":["Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/","url":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/","name":"How to Install MariaDB on Ubuntu 18.04 | LinuxCloudVPS Blog","isPartOf":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/#primaryimage"},"image":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2019\/11\/how-to-install-mariadb-on-ubuntu18.04.jpg","datePublished":"2019-11-13T16:41:02+00:00","description":"In this article, we will show you two different methods on how to install MariaDB on your Ubuntu 18.04 Cloud VPS. MariaDB is an open-source database","breadcrumb":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/#primaryimage","url":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2019\/11\/how-to-install-mariadb-on-ubuntu18.04.jpg","contentUrl":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2019\/11\/how-to-install-mariadb-on-ubuntu18.04.jpg","width":750,"height":360},{"@type":"BreadcrumbList","@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-mariadb-on-ubuntu-18-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.linuxcloudvps.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install MariaDB on Ubuntu 18.04"}]},{"@type":"WebSite","@id":"https:\/\/www.linuxcloudvps.com\/blog\/#website","url":"https:\/\/www.linuxcloudvps.com\/blog\/","name":"LinuxCloudVPS","description":"","publisher":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.linuxcloudvps.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.linuxcloudvps.com\/blog\/#organization","name":"LinuxCloudVPS","url":"https:\/\/www.linuxcloudvps.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.linuxcloudvps.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2023\/08\/logo.png","contentUrl":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2023\/08\/logo.png","width":217,"height":25,"caption":"LinuxCloudVPS"},"image":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/LinuxCloudVPS","https:\/\/x.com\/LinuxCloudVPS","http:\/\/www.linkedin.com\/company\/linuxcloudvps-com"]},{"@type":"Person","@id":"https:\/\/www.linuxcloudvps.com\/blog\/#\/schema\/person\/ed907227ee7d151c617e6d0fe74f531a","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"admin"},"sameAs":["http:\/\/www.linuxcloudvps.com\/"],"url":"https:\/\/www.linuxcloudvps.com\/blog\/author\/r0s3admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/posts\/1083","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/comments?post=1083"}],"version-history":[{"count":3,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/posts\/1083\/revisions"}],"predecessor-version":[{"id":1091,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/posts\/1083\/revisions\/1091"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/media\/1085"}],"wp:attachment":[{"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/media?parent=1083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/categories?post=1083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/tags?post=1083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}