Now we can use MyWebSQL without any problems. When finished you can restart Apache sudo systemctl restart apache2 Using MyWebSQL on Ubuntu 20.04
#Mysql web gui license#
In the process you will be asked for an email and if you agree with the license terms.
#Mysql web gui install#
With these packages installed, we can generate and install the certificates using this command sudo certbot -apache -d sudo apt install certbot python3-certbot-apache To do this, you need to have a valid domain and install these packages. If MyWebSQL is on a server with internet access, then it must be secured with Let’s Encrypt certificates. Sudo systemctl restart apache2 Optional: Secure the installation with Let’s Encrypt sudo ln -s /etc/apache2/sites-available/nf /etc/apache2/sites-enabled/nf
Remember that the value of the ServerName refers to your domain.Įnable the new virtualhost and enable the Apache rewrite module. sudo nano /etc/apache2/sites-available/nfĮrrorLog $/_access.log combined However, if you are using MyWebSQL locally then you can skip this step. Sudo chmod -R 775 /var/www/html/mywebsql/ Optional: Create a new virtual host for MyWebSQLįor Apache to better process MyWebSQL, then the next step is to create a new Virtual Host. Now set the owner of the folder to sudo chown -R www-data:www-data /var/www/html/mywebsql/ sudo unzip mywebsql-3.7.zip -d /var/www/htmlīy doing the above step, the folder is left as if the root user owns it. Now unzip the downloaded package into the Apache root directory. To achieve this goal we will use the wget command cd /tmp/ Step 2: Download and install MyWebSQL on Ubuntu 20.04Īfter all the above processes, we can install MyWebSQL. Now we have the system ready for MyWebSQL. GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY 'Angelo12.,' This is optional but it is convenient to use MyWebSQL without problems from the beginning. Now you have to enter the MariaDB shell and set privileges on a new user other than root.
#Mysql web gui password#
In this script, you have to define a password for the root user Change root password YĪfter this, you will be asked some configuration questions that you can answer Y to all of them without any problem. Now that it is installed, the next thing to do is to secure the MariaDB installation with the mysql_secure_installation script. To do this, run the following command sudo apt install apache2 mariadb-server php libapache2-mod-php php php php-common php-mbstring php-gd php-intl php-curl php-xml php-mysql php-pgsql php-mysql php-bcmath php-bcmath unzip wgetĪs I told you, in that command is LAMP, the necessary PHP modules, and other packages.ĭon’t forget to open ports 80 and 443 so Apache can work. So, you need to install LAMP on Ubuntu 20.04 as well as other PHP modules and packages needed to complete the post. In this case, we will choose Apache because it is easier and because it is very popular. Install MyWebSQL on Ubuntu 20.04 Step 1: Install LAMP on Ubuntu 20.04 and prepare MariaDBĪs it is an application created with PHP and web technology, we can install it on a web server like Apache or Nginx. Also, you can install it on almost any system. Moreover, being a web application it is compatible with all major web browsers on the market.
The application is a fast, intuitive, developer-friendly user interface, so many developers will not have to waste time to find what they need. Unlike PHPMyAdmin which only supports MySQL / MariaDB, MyWebSQL also supports SQLite and PostgreSQL so the possibilities within the application are many. MyWebSQL is an open-source PHP application that allows you to quickly and easily manage an instance of a database manager.
#Mysql web gui how to#
Thanks to this tutorial, you will learn how to install MyWebSQL on Ubuntu 20.04, and with a modern graphical interface, you will be able to manage a database quickly. So we always have the help of various tools that allow us to do this process quickly and easily. Managing and viewing MySQL / MariaDB data using the terminal can be cumbersome.