{"id":29552,"date":"2019-02-06T15:25:40","date_gmt":"2019-02-06T21:25:40","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=29552"},"modified":"2022-12-09T07:10:44","modified_gmt":"2022-12-09T13:10:44","slug":"how-to-install-mywebsql-on-ubuntu-18-04","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/","title":{"rendered":"How to Install MyWebSQL on Ubuntu 18.04"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"size-full wp-image-29705 alignnone\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18.jpg\" alt=\"Install MyWebSQL on Ubuntu 18.04\" width=\"742\" height=\"372\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18.jpg 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18-150x75.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18-300x150.jpg 300w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n<p>In this tutorial, we will show you how to set up MyWebSQL on Ubuntu 18.04 server.\u00a0MyWebSQL is a free and open-source web-based WYSIWYG client for managing the databases on your server. It provides a simple and intuitive interface with the look and feel of a desktop application. This PHP-based application offers a rich feature set and plenty of tools for database management. It can work with the most popular database types, such as MySQL, PostgreSQL, and SQLite databases. With its fast and attractive web interface, it is a very good alternative to the popular <a href=\"https:\/\/www.rosehosting.com\/blog\/install-phpmyadmin-on-ubuntu-16-04\/\" target=\"_blank\" rel=\"noopener noreferrer\">phpMyAdmin<\/a>.<\/p>\n<p><!--more--><\/p>\n<h3>Here are some of the most important features:<\/h3>\n<ul class=\"features as-columns\">\n<li class=\"feature\">Multiple Syntax highlighted SQL editors<\/li>\n<li class=\"feature\">WYSIWYG Table creator\/editor<\/li>\n<li class=\"feature\">Quick Inplace multi-record editing<\/li>\n<li class=\"feature\">Desktop application look and feel<\/li>\n<li class=\"feature\">Excellent support for all major browsers<\/li>\n<li class=\"feature\">Zero configuration installation<\/li>\n<li class=\"feature\">Multilingual Interface with themes support<\/li>\n<li class=\"feature\">Supports MySQL, PostgreSQL and SQLite databases<\/li>\n<li class=\"feature\">Import database script, export database, tables or results to multiple formats<\/li>\n<\/ul>\n<p>The installation of MyWebSQL is very fast and easy. No additional configuration is required, and it works with all major web browsers right out of the box.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69cadbd361dc4\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69cadbd361dc4\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#Requirements\" >Requirements:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#Step-1-Connect-to-your-server\" >Step 1: Connect to your server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#Step-2-Install-LAMP\" >Step 2: Install LAMP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#Step-3-Install-the-Required-MyWebSQL-Dependencies\" >Step 3: Install the Required MyWebSQL Dependencies<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#Step-4-Download-and-Install-the-MyWebSQL-Package\" >Step 4: Download and Install the MyWebSQL Package<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#Step-5-Accessing-MyWebSQL\" >Step 5: Accessing\u00a0MyWebSQL<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Requirements\"><\/span>Requirements:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>For the purposes of this tutorial, we will be using an\u00a0<a href=\"https:\/\/www.rosehosting.com\/ubuntu-hosting.html\" target=\"_blank\" rel=\"noopener noreferrer\">Ubuntu 18.04 VPS<\/a>.<\/li>\n<li>You will also need a working LAMP or LEMP (Linux, Apache\/Nginx, MySQL, PHP) stack. Our Ubuntu 18.04 VPS already comes pre-installed with a fully configured LAMP stack. However, if you do not have any web hosting stack installed on your VPS, we will also show you how to do this as a part of this tutorial.<\/li>\n<li>Full SSH root access or a user with sudo privileges is also required.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Step-1-Connect-to-your-server\"><\/span>Step 1: Connect to your server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before we begin,\u00a0 you need to connect to your server via SSH as the root user. To do this, use the following command:<\/p>\n<pre>ssh root@<span style=\"color: #ff0000;\">IP_ADDRESS<\/span> -p <span style=\"color: #ff0000;\">PORT_NUMBER<\/span><\/pre>\n<p>and replace <span style=\"color: #ff0000;\">IP_ADDRESS<\/span>\u00a0and <span style=\"color: #ff0000;\">PORT_NUMBER<\/span>\u00a0with your actual server IP address and SSH port number.<\/p>\n<p>Once logged in, make sure that your server is up-to-date by running the following commands:<\/p>\n<pre>sudo apt update\r\nsudo apt upgrade<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-2-Install-LAMP\"><\/span>Step 2: Install LAMP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In this section, we will show you how to install the LAMP stack on your VPS. If you already have LAMP\/LEMP installed you can skip this part and proceed with the next step of the tutorial.<\/p>\n<p>First, let&#8217;s install the Apache web server. We can do this by running the following command:<\/p>\n<pre>apt install apache2<\/pre>\n<p>After the installation is completed, start Apache and enable it to start automatically after a reboot with:<\/p>\n<pre>systemctl start apache2\r\nsystemctl enable apache2<\/pre>\n<p>To check and verify whether Apache is currently running on your server, execute the following command:<\/p>\n<pre>systemctl status apache2<\/pre>\n<p>Output:<\/p>\n<pre>\u25cf apache2.service - The Apache HTTP Server\r\nLoaded: loaded (\/lib\/systemd\/system\/apache2.service; enabled; vendor preset: enabled)\r\nDrop-In: \/lib\/systemd\/system\/apache2.service.d\r\n         \u2514\u2500apache2-systemd.conf\r\nActive: active (running) since Sat 2019-01-26 02:20:44 CST; 1h 57min ago\r\nMain PID: 14666 (apache2)\r\nTasks: 7 (limit: 2320)\r\nCGroup: \/system.slice\/apache2.service\r\n        \u251c\u2500 504 \/usr\/sbin\/apache2 -k start\r\n        \u251c\u250014666 \/usr\/sbin\/apache2 -k start\r\n        \u251c\u250014686 \/usr\/sbin\/apache2 -k start\r\n        \u251c\u250014687 \/usr\/sbin\/apache2 -k start\r\n        \u251c\u250014688 \/usr\/sbin\/apache2 -k start\r\n        \u251c\u250014689 \/usr\/sbin\/apache2 -k start\r\n        \u2514\u250014690 \/usr\/sbin\/apache2 -k start<\/pre>\n<p>Next, we need to install the MySQL web server. The following command will install the latest MySQL 5.7 server from the official Ubuntu repositories:<\/p>\n<pre>apt install mysql-server<\/pre>\n<p>Once the installation is complete, issue the following command to secure your installation:<\/p>\n<pre>mysql_secure_installation<\/pre>\n<p>You will be prompted to answer several questions:<\/p>\n<pre>Setup VALIDATE PASSWORD plugin? (Press y|Y for Yes, any other key for No) <strong>N<\/strong>\r\nChange root password? (Press y|Y for Yes, any other key for No) <strong>N<\/strong>\r\nRemove anonymous users? (Press y|Y for Yes, any other key for No) <strong>Y<\/strong>\r\nDisallow root login remotely? (Press y|Y for Yes, any other key for No) <strong>Y<\/strong>\r\nRemove test database and access to it? (Press y|Y for Yes, any other key for No) <strong>Y<\/strong>\r\nReload privilege tables now? (Press y|Y for Yes, any other key for No) <strong>Y<\/strong><\/pre>\n<p>The last step of our LAMP stack setup is the PHP installation. Currently, the default PHP version available at the official Ubuntu repository is PHP 7.2.<\/p>\n<p>To install PHP 7.2 on your server along with several PHP extensions, run the following command:<\/p>\n<pre>apt install -y php php-common php-mbstring php-gd php-intl php-xml php-mysql php-mcrypt<\/pre>\n<p>To verify if PHP is properly installed, you can run the following command:<\/p>\n<pre>php -v<\/pre>\n<p>Output:<\/p>\n<pre>PHP 7.2.10-0ubuntu0.18.04.1 (cli) (built: Sep 13 2018 13:45:02) ( NTS )\r\nCopyright (c) 1997-2018 The PHP Group\r\nZend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies\r\nwith Zend OPcache v7.2.10-0ubuntu0.18.04.1, Copyright (c) 1999-2018, by Zend Technologies<\/pre>\n<p>We now have a fully working LAMP stack running on our server. We are now ready to proceed to the next step of this tutorial and begin the MyWebSQL installation.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step-3-Install-the-Required-MyWebSQL-Dependencies\"><\/span>Step 3: Install the Required MyWebSQL Dependencies<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before we install MyWebSQL, we need to install some additional dependencies. They will be required in order to finish the installation and for\u00a0MyWebSQL to work properly.\u00a0 You can install them with:<\/p>\n<pre>apt install wget zip php-pgsql php-mysql php-bcmath<\/pre>\n<p>The following extensions are not required, but they can provide some additional functionality:<\/p>\n<pre>apt install php-curl php-gmp<\/pre>\n<p>If you are using SQLite, the following package is also required:<\/p>\n<pre>apt-get install php-sqlite3<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-4-Download-and-Install-the-MyWebSQL-Package\"><\/span>Step 4: Download and Install the MyWebSQL Package<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>At the moment of writing this article, the latest MyWebSQL version is MyWebSQL 3.7.<\/p>\n<p>You can download the installation file with the following command:<\/p>\n<pre>wget https:\/\/newcontinuum.dl.sourceforge.net\/project\/mywebsql\/stable\/mywebsql-3.7.zip<\/pre>\n<p>To unpack the archive file to the default web server document root directory, run the following command:<\/p>\n<pre class=\"code\">unzip mywebsql-3.7.zip -d \/var\/www\/html<\/pre>\n<p class=\"code\">Set the appropriate file permissions and ownership (www-data is the user of our Apache web server):<\/p>\n<pre>chown -R www-data:www-data \/var\/www\/html\/mywebsql\/\r\nchmod -R 775 \/var\/www\/html\/mywebsql\/<\/pre>\n<p>After the archive is unpacked, MyWebSQL is already configured to use the best options for all parameters. You can now test and verify the installation by typing the following in your browser (using your own server IP address):\u00a0<strong>http:\/\/YOUR-SERVER-IP-ADDRESS\/mywebsql\/install.php<\/strong><\/p>\n<p><img decoding=\"async\" class=\" wp-image-29578 aligncenter\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/mywebsql_test.png\" alt=\"\" width=\"575\" height=\"805\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/mywebsql_test.png 694w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/mywebsql_test-107x150.png 107w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/mywebsql_test-214x300.png 214w\" sizes=\"(max-width: 575px) 100vw, 575px\" \/><\/p>\n<p>Once you verify and make sure that the installation passed all of the requirements, you can remove or rename the <code>install.php<\/code> file from the\u00a0<strong>mywebsql<\/strong> directory. To remove the file, run the following command:<\/p>\n<pre>rm \/var\/www\/html\/mywebsql\/install.php<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-5-Accessing-MyWebSQL\"><\/span>Step 5: Accessing\u00a0MyWebSQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can now access MyWebSQL by typing the following in your browser:\u00a0<strong>http:\/\/YOUR-SERVER-IP-ADDRESS\/mywebsql<\/strong><\/p>\n<p>This will take you to the MyWebSQL login screen where you need to enter\u00a0 your database username and password, select your database server, select whether you use MySQL, PostgreSQL or SQLite, and choose your preferred language:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-27662\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/Installing-MyWebSQL-on-Ubuntu-16.04.jpg\" alt=\"Installing MyWebSQL on Ubuntu 16.04\" width=\"350\" height=\"281\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/Installing-MyWebSQL-on-Ubuntu-16.04.jpg 350w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/Installing-MyWebSQL-on-Ubuntu-16.04-150x120.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/Installing-MyWebSQL-on-Ubuntu-16.04-300x241.jpg 300w\" sizes=\"(max-width: 350px) 100vw, 350px\" \/><\/p>\n<p>Once successfully logged in, you will be taken to the main MyWebSQL page from which you can start managing your databases.<\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-27663\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/MyWebSQL-install-Ubuntu-16.04.jpg\" alt=\"MyWebSQL install Ubuntu 16.04\" width=\"210\" height=\"35\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/MyWebSQL-install-Ubuntu-16.04.jpg 210w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/MyWebSQL-install-Ubuntu-16.04-150x25.jpg 150w\" sizes=\"(max-width: 210px) 100vw, 210px\" \/>Of course, if you are one of our\u00a0<a href=\"https:\/\/www.rosehosting.com\/ubuntu-hosting.html\" target=\"_blank\" rel=\"noopener noreferrer\">Ubuntu Hosting<\/a> customers, you don\u2019t have to install MyWebSQL on your Ubuntu 18.04 VPS &#8211; simply ask our admins, sit back, and relax. Our admins will install MyWebSQL on Ubuntu 18.04 for you immediately.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>PS.<\/strong><\/span> If you liked this post about <strong>how to install MyWebSQL on Ubuntu 18.04 VPS<\/strong>, please share it with your friends on the social networks using the buttons below, or simply leave a comment in the comments section. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, we will show you how to set up MyWebSQL on Ubuntu 18.04 server.\u00a0MyWebSQL is a free and &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install MyWebSQL on Ubuntu 18.04\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#more-29552\" aria-label=\"Read more about How to Install MyWebSQL on Ubuntu 18.04\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":29705,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,1698],"tags":[522,1779],"class_list":["post-29552","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","category-ubuntu","tag-mywebsql","tag-ubuntu-18-04","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Install MyWebSQL on Ubuntu 18.04 | RoseHosting<\/title>\n<meta name=\"description\" content=\"How to Install MyWebSQL on Ubuntu 18.04 | RoseHosting\" \/>\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.rosehosting.com\/blog\/how-to-install-mywebsql-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 MyWebSQL on Ubuntu 18.04\" \/>\n<meta property=\"og:description\" content=\"How to Install MyWebSQL on Ubuntu 18.04 | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-06T21:25:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-09T13:10:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"372\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install MyWebSQL on Ubuntu 18.04\",\"datePublished\":\"2019-02-06T21:25:40+00:00\",\"dateModified\":\"2022-12-09T13:10:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/\"},\"wordCount\":903,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18.jpg\",\"keywords\":[\"mywebsql\",\"Ubuntu 18.04\"],\"articleSection\":[\"Tutorials\",\"Ubuntu\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/\",\"name\":\"How to Install MyWebSQL on Ubuntu 18.04 | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18.jpg\",\"datePublished\":\"2019-02-06T21:25:40+00:00\",\"dateModified\":\"2022-12-09T13:10:44+00:00\",\"description\":\"How to Install MyWebSQL on Ubuntu 18.04 | RoseHosting\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#primaryimage\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18.jpg\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18.jpg\",\"width\":742,\"height\":372,\"caption\":\"Install MyWebSQL on Ubuntu 18.04\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rosehosting.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install MyWebSQL on Ubuntu 18.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"name\":\"RoseHosting.com\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/RoseHosting\",\"https:\/\/x.com\/rosehosting\",\"https:\/\/www.linkedin.com\/in\/rosehosting\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\/\/www.rosehosting.com\",\"https:\/\/www.facebook.com\/rosehosting.helpdesk\"],\"url\":\"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Install MyWebSQL on Ubuntu 18.04 | RoseHosting","description":"How to Install MyWebSQL on Ubuntu 18.04 | RoseHosting","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.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/","og_locale":"en_US","og_type":"article","og_title":"How to Install MyWebSQL on Ubuntu 18.04","og_description":"How to Install MyWebSQL on Ubuntu 18.04 | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2019-02-06T21:25:40+00:00","article_modified_time":"2022-12-09T13:10:44+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18.jpg","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install MyWebSQL on Ubuntu 18.04","datePublished":"2019-02-06T21:25:40+00:00","dateModified":"2022-12-09T13:10:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/"},"wordCount":903,"commentCount":2,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18.jpg","keywords":["mywebsql","Ubuntu 18.04"],"articleSection":["Tutorials","Ubuntu"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/","name":"How to Install MyWebSQL on Ubuntu 18.04 | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18.jpg","datePublished":"2019-02-06T21:25:40+00:00","dateModified":"2022-12-09T13:10:44+00:00","description":"How to Install MyWebSQL on Ubuntu 18.04 | RoseHosting","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18.jpg","width":742,"height":372,"caption":"Install MyWebSQL on Ubuntu 18.04"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-mywebsql-on-ubuntu-18-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install MyWebSQL on Ubuntu 18.04"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/29552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=29552"}],"version-history":[{"count":3,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/29552\/revisions"}],"predecessor-version":[{"id":43989,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/29552\/revisions\/43989"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/29705"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=29552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=29552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=29552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}