mysql mariadb phpmyadmin

Most Relevant Content

  • FreeRADIUS MySQL Database GUI with phpMyAdmin on CentOS 7

    FreeRADIUS is a high performance RADIUS Server that accepts a large number of networking devices as RADIUS Client including MikroTik Router. MySQL is one of the best user sources for freeRADIUS server. In my previous article, I discussed how to install freeRADIUS server on CentOS 7 and how to integrate MySQL module with freeRADIUS server. I also discussed how to create user group and profile in MySQL database server and authenticate MikroTik PPPoE client with MySQL database user. I used MySQL Command Line Interface (CLI) to insert user information in database server. But most of the people like Graphical User Interface (GUI) rather than Command Line Interface (CLI). A lot of Graphical Software (such as MySQL Workbench, DBTools Manager, phpMyAdmin and so on) can be found to manage MySQL (MariaDB) database graphically. Among these, in this article I will show how to install and configure phpMyAdmin to manage freeRADIUS MySQL database because phpMyAdmin is a free MySQL (MariaDB) management tool over Web Interface. phpMyAdmin Installation and Configuration on CentOS 7 phpMyAdmin is a free and open source MySQL and MariaDB database administration tool that is written in PHP and can manage over Web Interface. So, to get phpMyAdmin we should [...]

    READ MORE »

  • More Similar Content

  • »

    phpMyAdmin with NGINX – Installation and Configuration |   October 14, 2024

    In modern web development, server management is a vital part. Two popular tools that assist in this process are Nginx and phpMyAdmin. Nginx is a high-performance web server, while phpMyAdmin is a widely-used web-based interface for managing MySQL or MariaDB databases. When combined, these tools provide a strong platform for serving dynamic web applications and managing their databases efficiently. What is Nginx? NGINX (pronounced “engine-x”) is an open-source web server that also functions as a reverse proxy, load balancer, and [...]

    READ MORE »

  • »

    Ubuntu Web Server Configuration with phpMyAdmin (LAMP Stack) |   July 12, 2021

    Ubuntu Server is one of the most popular open source operating systems that can be used in production without any hassle. In my previous article, I discussed how to install Ubuntu Server with LVM partition. I also discussed how to assign static IP address on Ubuntu Server interface with Netplan network management tool. Ubuntu web server is a popular service because web developers usually use Ubuntu Server for their development project. Besides development project, Ubuntu web server can also be [...]

    READ MORE »

  • »

    Web Server Configuration in Linux with Apache, MariaDB and PHP |   January 2, 2018

    Web Server is one of the most important and most used servers today. Without web server internet cannot imagine. Even, the article you are reading is also served by a web server. So, having web server configuration knowledge is beneficial for you, I think. A web server is responsible to serve HTTP (Hypertext Transfer Protocol) contents such as text, image, audio, video etc. to its clients. A lot of web servers are present today such as Apache, IIS, Nginx and [...]

    READ MORE »

  • »

    MikroTik PPPoE Server Configuration with freeRADIUS Server |   January 20, 2019

    PPPoE Service is one of the most popular services in MikroTik Router. It is specially used by the local ISP provider for the simplicity of client connection. MikroTik PPPoE Service accepts user or client authentication and authorization both MikroTik local user database and RADIUS user database. RADIUS Server provides an efficient way to manage user authentication, authorization and accounting.  FreeRADIUS is a high performance RADIUS suite that provides user authentication, authorization and accounting facility for a number of network devices [...]

    READ MORE »

  • You May Also Like

  • »

    MikroTik PCC Load Balancing over Unequal Dual WAN Links |   June 12, 2018

    Hi, you are here means you are finding a Load Balancing and Link Redundancy solution with Unequal WAN links in your MikroTik Router. If so, it is your right place. In my previous article I discussed how to configure a Dual WAN Load Balancing and Link Redundancy network using PCC method but it was assumed that both WAN links have equal bandwidth. But in real situation, you may have unequal WAN links such as ISP1 may have 10MB bandwidth and [...]

    READ MORE »

  • »

    FreeRADIUS User Profile Configuration for MikroTik Router |   January 10, 2019

    FreeRADIUS is a high performance RADIUS application that accepts a large number of network devices as RADIUS Client including MikroTik Router. FreeRADIUS MySQL module helps to get user authentication and authorization information from database server and to store user accounting information in database server. Configuring MySQL user group and profile properly, freeRADIUS user restriction can easily be maintained. How to configure user group to apply user limitation was discussed in my previous article. In this article, I will discuss how [...]

    READ MORE »

  • »

    How to Import SSL Certificate in MikroTik RouterOS |   January 16, 2022

    SSL/TLS Certificate is used to make secure communication between server and clients. MikroTik RouterOS has a lot of services such OVPN, SSTP VPN, HTTPS, Hotspot and so on those use SSL/TLS certificate. It is possible to create self-signed certificate in MikroTik RouterOS but self-signed certificate faces untrusted CA warning. So, it is always better to use trusted CA either freemium or premium.  In my previous article, I discussed how to get a free SSL/TLS certificate from Zero SSL but Zero [...]

    READ MORE »

  • »

    MikroTik Hotspot Login by HTTP CHAP, HTTP PAP and HTTPS |   July 25, 2020

    MikroTik Hotspot uses various types of login methods. Among these login methods HTTP CHAP, HTTP PAP and HTTPS are basic and important login methods. So, a MikroTik system administrator should have proper understanding on Hotspot HTTP CHAP, HTTP PAP and HTTPS login methods. In my previous article I discussed how to configure MikroTik Hotspot using Winbox. In this article I will discuss how to use HTTP CHAP, HTTP PAP and HTTPS login methods properly in MikroTik Hotspot Server. MikroTik Hotspot [...]

    READ MORE »

  • »

    How to Install MikroTik CHR on VMware Workstation |   September 9, 2019

    MikroTik is found both RouterBoard where RouterOS and License are prebuilt and RouterOS Application that can be installed on a Physical Machine or Virtual Machine. RouterOS installation on Physical or Virtual Machine has license limitations. Full RouterOS packages cannot be used more than 24 hours without license. So, RouterOS application is not suitable for the Trainee or not suitable to RND purpose. From RouterOS v6.34, MikroTik introduces Cloud Hosted Router (CHR, a new RouterOS version) which has different licensing scheme. [...]

    READ MORE »