Here we’ve provided installation of PhpMyAdmin for both the web server’s Apache or Nginx. In this article we’re going to show you how to install latest stable version of PhpMyAdmin for Apache or Nginx on RHEL, CentOS and Fedora distributions. It was written in PHP language, through this application you can do various MySQL administration tasks such as create, drop, alter, delete, import, export, search, query, repair, optimize and run other database management command via browser.Īs other well-known web-based interfaces for managing system services, blog creation tools, or content management systems (CMSs), it is often targeted by malicious attackers who seek to exploit the usual lack of security measures. Suggested Read: 20 MySQL (Mysqladmin) Commands for Database Administration in Linux PhpMyAdmin is a web-based interface for managing MySQL / MariaDB databases that is used as a replacement for command-line utilities. To make MySQL administration much easier we’re introducing a web based MySQL administration tool called PhpMyAdmin, with the help of this tool you can control and manage your database administration via a web browser easily. Suggested Read: MySQL Basic Database Administration Commands I have been using it, setting, supporting, and maintaining it since 2009.MySQL administration via command-line in Linux is very difficult job for any newbie system administrator or database administrator, because it contains numerous commands which we cannot remember in our daily life. Love to write and lover of education, culture, and community. I am a professional freelance contributor and founder of tech transit. Go to browser and open phpmyadmin with for any query or concern please comment. Now restart the apache #service httpd restart Now edit apache’s configuration file add Alias for phpmyadmin #vi /etc/httpd/conf/nf Go to /usr/share direcory and download latest version of phpmyadmin. Remove anonymous users? Set root password? y Now configure mysql password, for this follow below steps as mentioned #mysql_secure_installationĮnter current password for root (enter for none): Now Start apache and mysql server #chkconfig httpd on Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies Install required packages as #yum install httpd php php-devel php-common php-gd php-pdo php-mysql php-mcrypt php-mbstring mysql-server -enablerepo=remi You can left this step if already have below packages and softwares on server. Here we are doing fresh installation of php and php module with mysql-server setup. Now download and install Remi repository #wget #rpm -Uvh epel-release-6*.rpm for 64 bit #wget Install Epel repository as this is require for remi for 32 bit #wget As we know that we phpmyadmin is a great GUI tool to handle mysql database, there are always security matters when we talk about the database, so it is important to secure the access of phpmyadmin, In this article we cover a complete server setup with LAMP ,with secure phpmyadmin access by fake url.įirst we need to install important repositories to install latest packages, I always prefer remi repository ,we can install this repository as
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |