Explore information related to phpmyadmin


Different methods of Checking MySQL Version in Linux

This article covers the ways to check the MySQL version in Linux. In fact, MySQL (and its drop-in replacement MariaDB) is the most popular open-source relational database management system. There are some important differences between MySQL versions, so knowing which version is running on your server might be important in some situations.


How to Check MySQL Version with V Command ?

The easiest way to find the MySQL version is with the command:

$ mysql -V

The command mysql –V is not OS specific. This command works on Windows, OS X, and Linux distributions including Ubuntu.

Read More



Install phpMyAdmin on AlmaLinux / CentOS 8 - Follow the steps outlined here ?

This article covers the installation and configuration procedure of phpMyAdmin on CentOS 8 / AlmaLinux 8. It is one of the most popular database administration tools used by hosting companies and system administrators for performing database activities such as creating, deleting, querying tables, columns, relations, indexes, users, permissions, etc. Now, you can create and manage all the databases conveniently without the need of running SQL queries.

Read More



What is Localhost ?

This article covers what localhost is as well as 127.0.0.1/loopback. In fact, Developers use the localhost to test web applications and programs. Network administrators use the loopback to test network connections. Another use for the localhost is the hosts file, where you can use the loopback to block malicious websites. 


Read More



Install LAMP Stack on CentOS 8 - Step by Step Process ?

This article covers how to install the LAMP stack on the CentOS system. If are using another Linux distribution, visit how to install LAMP stack on Debian, Ubuntu, Red Hat, and Rocky Linux. Basically, A LAMP stack is a collection of open-source software that you can use as a platform to create websites and web applications. The term LAMP is an acronym standing for Linux operating system, the Apache HTTP Server, the MySQL database system, and the PHP programming language.


In LAMP:

  • Linux serves as the server's operating system that handles all the commands on the machine.
  • Apache is a web server software that manages HTTP requests to deliver your website's content.
  • MySQL is a relational database management system (RDBMS) whose function is to maintain user's data on a server.
  • PHP is a scripting language for server-side communication.

Read More



Install LAMP Stack on Rocky Linux 8 - Step by Step Process ?

This article covers how to install LAMP stack on Rocky Linux 8.4. You can now proceed to test or host your website and applications. A LAMP stack is a group of open-source software that is typically installed together to enable a server to host dynamic websites and web apps. This term is actually an acronym which represents the Linux operating system, with the Apache web server. The site data is stored in a MySQL database, and dynamic content is processed by PHP.


How to Install  and configure Apache Web Server ?

1. First, we will start by installing the Apache web server. To complete the installation, use the following command:

$ yum install httpd httpd-tools

2. Once the installation is complete, enable Apache (to start automatically upon system boot), start the web server and verify the status using the commands below:

$ systemctl enable httpd
$ systemctl start httpd
$ systemctl status httpd

3. To make your pages available to public, you will have to edit your firewall rules to allow HTTP and HTTPS requests on your web server by using the following commands:

$ firewall-cmd --permanent --zone=public --add-service=http 
$ firewall-cmd --permanent --zone=public --add-service=https 
$ firewall-cmd --reload
4. Verify that the web server is running and accessible by accessing your server’s IP address:
$ echo "Hello there, Apache webserver is now running" > /var/www/html/index.html

5. And restart tht Web Server to reflect the changes made:

$ systemctl restart httpd

From your browser,

http://IP_address


How to Install PHP on CentOS ?

1. To install PHP on your RHEL 8 use the command below:

$ yum install -y php-mysqlnd php-dom php-simplexml php-xml php-xmlreader php-curl php-exif php-ftp php-gd php-iconv  php-json php-mbstring php-posix php-sockets php-tokenizer

2. Now restart your web server so that Apache knows that it will be serving PHP requests as well:

$ systemctl restart httpd

Read More




For Linux Tutorials

We create Linux HowTos and Tutorials for Sys Admins. Visit us on LinuxAPT.com

Also for Tech related tips, Visit forum.outsourcepath.com or General Technical tips on www.outsourcepath.com