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

  • »

    Single IP NAT Strategy in MikroTik RouterOS 7 |   September 29, 2015

    MikroTik Router has a lot of features which help to customize network as our requirement. Sometimes, it may be our requirement that we need to allow internet access on per IP. Normally, when we apply masquerade NAT rule in our MikroTik Router, all private IPs will be masqueraded or a network block will be masqueraded. If we do normal masqurade and enable a DHCP Server in our network, we may face a lot of unauthorized access in our network. Because [...]

    READ MORE »

  • »

    MikroTik Hotspot with Bandwidth Limitation and Prepaid Billing System |   January 14, 2018

    Say, you are a network administrator and want to establish a network that will have user bandwidth package management facility with prepaid billing system as well as partner advertisement facility. Then, MikroTik Hotspot Server Configuration with MikroTik User Manager Radius Server will be a wise decision. Because, MikroTik User Manager Radius Server is a user authentication, authorization and accounting application that will give facility to manage user bandwidth package with prepaid billing system. On the other hand, you can easily [...]

    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 »

  • »

    FreeRADIUS Installation and Basic Configuration on CentOS 7 |   November 28, 2018

    FreeRADIUS is a modular, high performance and highly customizable open source RADIUS server. Anyone can use FreeRADIUS without any charge and can customize his RADIUS server according to his organizational requirements. In my previous article, I discussed how to install and configure user manager RADIUS server developed by MikroTik. The main disadvantage of user manager RADIUS server is ‘it is not customizable and not suitable for medium or large organization’. On the other hand, FreeRADIUS is giving facility to customize [...]

    READ MORE »

  • »

    Ubuntu Server 20.04 Installation with LVM |   May 28, 2021

    Linux is a free and open source operating system developed by Linus Torvalds on September 17, 1991. It is mainly used as server environment. A lot of Linux distributions are present today. Among them, Ubuntu is one of the best stable Linux distributions. Ubuntu has both Desktop and Server distribution. Ubuntu Server is a high performance and stable enterprise Linux distribution and it can be easily used in production. Ubuntu Server has both community-support and well documentation. So, IT guys can use Ubuntu [...]

    READ MORE »