{"id":9401,"date":"2019-02-10T03:28:20","date_gmt":"2019-02-10T03:28:20","guid":{"rendered":"https:\/\/www.appservgrid.com\/paw92\/?p=9401"},"modified":"2019-02-10T03:52:06","modified_gmt":"2019-02-10T03:52:06","slug":"linux-today-how-to-install-mywebsql-on-ubuntu-18-04","status":"publish","type":"post","link":"https:\/\/www.appservgrid.com\/paw92\/index.php\/2019\/02\/10\/linux-today-how-to-install-mywebsql-on-ubuntu-18-04\/","title":{"rendered":"Linux Today &#8211; How to Install MyWebSQL on Ubuntu 18.04"},"content":{"rendered":"<div class=\"post-header\">\n<h1 class=\"entry-title\">Feb 6, 2019<span style=\"font-size: 1rem;\">\u00a0<\/span><\/h1>\n<\/div>\n<div class=\"post-wrap\">\n<div class=\"post-content entry-content\">\n<p><a href=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-29705 alignnone\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/install-mywebsql-ubuntu18.jpg\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" 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\" alt=\"Install MyWebSQL on Ubuntu 18.04\" width=\"742\" height=\"372\" \/><\/a><\/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\u00a0<a href=\"https:\/\/www.rosehosting.com\/blog\/install-phpmyadmin-on-ubuntu-16-04\/\" target=\"_blank\" rel=\"noopener\">phpMyAdmin<\/a>.<\/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<h2>Requirements:<\/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\">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>Step 1: Connect to your server<\/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@IP_ADDRESS -p PORT_NUMBER<\/pre>\n<p>and replace\u00a0IP_ADDRESS\u00a0and\u00a0PORT_NUMBER\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>Step 2: Install LAMP<\/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\u2019s 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<\/div>\n<\/div>\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>Step 3: Install the Required MyWebSQL Dependencies<\/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>Step 4: Download and Install the MyWebSQL Package<\/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><a href=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/mywebsql_test.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-29578 aligncenter\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/01\/mywebsql_test.png\" sizes=\"auto, (max-width: 575px) 100vw, 575px\" 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\" alt=\"\" width=\"575\" height=\"805\" \/><\/a><\/p>\n<p>Once you verify and make sure that the installation passed all of the requirements, you can remove or rename the\u00a0<code>install.php<\/code>\u00a0file from the\u00a0<strong>mywebsql<\/strong>\u00a0directory. To remove the file, run the following command:<\/p>\n<pre>rm \/var\/www\/html\/mywebsql\/install.php<\/pre>\n<h2>Step 5: Accessing\u00a0MyWebSQL<\/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 loading=\"lazy\" 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\" sizes=\"auto, (max-width: 350px) 100vw, 350px\" 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\" alt=\"Installing MyWebSQL on Ubuntu 16.04\" width=\"350\" height=\"281\" \/><\/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 loading=\"lazy\" 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\" sizes=\"auto, (max-width: 210px) 100vw, 210px\" 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\" alt=\"MyWebSQL install Ubuntu 16.04\" width=\"210\" height=\"35\" \/>Of course, if you are one of our\u00a0<a href=\"https:\/\/www.rosehosting.com\/ubuntu-hosting.html\" target=\"_blank\" rel=\"noopener\">Ubuntu Hosting<\/a>\u00a0customers, you don\u2019t have to install MyWebSQL on your Ubuntu 18.04 VPS \u2013 simply ask our admins, sit back, and relax. Our admins will install MyWebSQL on Ubuntu 18.04 for you immediately.<\/p>\n<p><strong>PS.<\/strong>\u00a0If you liked this post about\u00a0<strong>how to install MyWebSQL on Ubuntu 18.04 VPS<\/strong>, please share it with your friends on the social networks.<\/p>\n<p><a href=\"http:\/\/www.linuxtoday.com\/infrastructure\/how-to-install-mywebsql-on-ubuntu-18.04-190207002522.html\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Feb 6, 2019\u00a0 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 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.appservgrid.com\/paw92\/index.php\/2019\/02\/10\/linux-today-how-to-install-mywebsql-on-ubuntu-18-04\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Linux Today &#8211; How to Install MyWebSQL on Ubuntu 18.04&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-9401","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/9401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/comments?post=9401"}],"version-history":[{"count":2,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/9401\/revisions"}],"predecessor-version":[{"id":9411,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/9401\/revisions\/9411"}],"wp:attachment":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/media?parent=9401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/categories?post=9401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/tags?post=9401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}