Install LEMP Server (Nginx, PHP, MariaDB & phpMyAdmin) on Fedora 22, 23 & 24

3a) Enabling public access to the web server

By default web server is only accessible as localhost. If you want to access publicly you need to allow http & https in firewall.

[Allow http & https in firewall, then reload]
$ sudo firewall-cmd --permanent --add-service=http

$ sudo firewall-cmd --permanent --add-service=https

$ sudo systemctl reload firewalld

4) MariaDB installation

MariaDB is a drop-in replacement for MySQL. MariaDB is open source relational database management system (RDBMS) which is supporting database access. By default Fedora distribution included MariaDB 10.0 to own repository. So, just fire the below command to install it.

[Install MariaDB]
$ sudo dnf install mariadb-server

[Start, Enable & check the status of MariaDB Service on systemd System]
$ sudo systemctl start mariadb.service
$ sudo systemctl enable mariadb.service
$ sudo systemctl status mariadb.service

[Start, Enable & check the status of MariaDB Service on SysVinint System]
$ sudo service mysqld start
$ sudo chkconfig mysqld on

4a) Set MySQL root password

By default there is no password for MySQL instant and you need to run the below command to set the root password for security reason. I advise you to secure MySQL installation using mysql_secure_installation method which will set root password and adjust other settings to make more secure.

[MariaDB Secure installation]
$ sudo mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

Enter current password for root (enter for none): Press Enter
OK, successfully used password, moving on...

Set root password? [Y/n] y
New password: 
Re-enter new password: 
Password updated successfully!
Reloading privilege tables..
 ... Success!

Remove anonymous users? [Y/n] y
 ... Success!

Disallow root login remotely? [Y/n] y
 ... Success!

Remove test database and access to it? [Y/n] y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reload privilege tables now? [Y/n] y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!

install-lamp-on-fedora-24-workstation-3

About Magesh Maruthamuthu

Love to play with all Linux distribution

View all posts by Magesh Maruthamuthu

Leave a Reply

Your email address will not be published. Required fields are marked *