MariaDB and PhpMyAdmin in OpenSUSE, The LAMP stack incorporates of Linux running machine, Apache internet server software program. MySQL database control system and PHP programming language.
LAMP is a software mixture used to serve dynamic PHP web programs and websites. Note that the P also can stand for Perl or Python instead of PHP.
In the LAMP stack, Linux is the muse of the stack (it holds all the different additives); Apache gives you web content (like internet pages, and so on.) to the stop person over the net upon request via a web browser. PHP is a server-aspect scripting language used to generate dynamic web pages that runs PHP code and retrieve/shop facts from/to a MySQL database.
MariaDB and PhpMyAdmin in OpenSUSE, Installing Apache HTTP Server
The Apache HTTP Server is a free and open source, broadly-used and move-platform internet server software program. It is designed to be cozy, green and extensible for supplying HTTP services in sync with the present day HTTP requirements.
On openSUSE, Apache2 comes mounted through default. Otherwise, run the subsequent zypper command to put in it.
$ sudo zypper install apache2 
Once the Apache2 established, you could begin the provider for the interim. Then enable it to auto-begin at boot time and confirm the carrier the use of the subsequent instructions.
$ sudo systemctl start apache2
$ sudo systemctl enable apache2
$ sudo systemctl status apache2
MariaDB and PhpMyAdmin in OpenSUSE, At this stage, the Apache server should be up and running, you can also verify the status using the netstat command as shown.
$ sudo netstat -tlpn | grep httpd
Now that the net server is jogging, allow’s take a look at if it may serve net pages by using creating a check web web page (index.Html report) inside the net DocumentRoot at “/srv/www/htdocs” as follows.
$ echo "<h1>Apache2 is running fine on openSUSE Leap</h1>" | sudo tee /srv/www/htdocs/index.html
If you have a firewalld installed and enabled on your machine, remember to allow traffic to the Apache2 web server via the firewall before going to the next step.
$ sudo firewall-cmd --permanent --add-port=80/tcp
$ sudo firewall-cmd --permanent --add-port=443/tcp
$ sudo firewall-cmd --reload
Then open an internet browser and navigate the usage of the subsequent deal with: http://localhost or http://SERVER_IP, the contents of the created internet page must be displayed as proven on this screenshot.
Installing MariaDB Database Server
MariaDB is a free and open supply, speedy, scalable and sturdy and community-advanced fork of the MySQL relational database management gadget.
MariaDB comes with more functions, new garage engines, plugins and a number of other equipment for higher overall performance.
PhpMyAdmin and MariaDB in OpenSUSE, To set up MariaDB on OpenSuse, run the subsequent command.
$ sudo zypper install mariadb mariadb-client 
When the set up is entire, start the MariaDB service in the mean time. Then permit it to auto-begin at machine boot time and test if it’s miles up and running as follows:
$ sudo systemctl start mariadb
$ sudo systemctl enable mariadb
$ sudo systemctl status mariadb 
After starting the MariaDB carrier, subsequent, we need to comfortable the MariaDB server installation. This may be completed through running the security script which comes with the MariaDB package, as proven.
$ sudo mysql_secure_installation Once the script is invoked, carefully read the outline at each step. You must set a strong root user password, get rid of nameless customers. Disable faraway root get admission to. Do away with the take a look at database and get right of entry to to it and eventually reload privileges table.
MariaDB and PhpMyAdmin in OpenSUSE, Installing PHP and PHP Modules
PHP or Hypertext Preprocessor is a loose and open source, popular. Platform-impartial and fashionable-cause scripting language that is specifically proper to web development.
PHP is like minded with nearly all if not most net servers software program obtainable and helps many database systems such as MySQL/MariaDB.
To deploy PHP along with needed modules run the subsequent command.
$ sudo zypper install php php-mysql php-gd php-mbstring apache2-mod_php7
Next, enable PHP module and restart Apache web server to effect the latest changes as shown.
$ sudo a2enmod php7 $ sudo systemctl restart apache2Now verify PHP installation information by creating a PHP test file under the DocumentRoot directory. Which should pick the PHP configuration details.
$ echo "<?php phpinfo(); ?>" | sudo tee /srv/www/htdocs/info.phpOpen a web browser and navigate to the cope with: http://localhost/info.Php or http://SERVER_IP/info.Php. To confirm the PHP configuration info as shown within the following screenshot.
Installing and Configuring PhpMyAdmin
PhpMyAdmin is a loose and popular web-based totally tool for MySQL management. PhpMyAdmin permits you to create, adjust, drop, delete, import and export MySQL database tables.
MariaDB and PhpMyAdmin in OpenSUSE, It is likewise used to run MySQL queries, optimize, restore and test tables. Trade collation and execute many other database control instructions.
To install phpMyAdmin on OpenSuse, run the subsequent command.
$ sudo zypper install phpMyAdmin
Now visit your net browser and input the cope with http://localhost/phpMyAdmin. A phpMyAdmin login page need to display as proven in the following screenshot. Enter your database root person login credentials and click on Go.
That’s all! In this academic, we’ve defined you ways install a LAMP stack with Apache, MariaDB, PHP. And PhpMyAdmin on OpenSuse server/computer variants.