Install LAMP on CentOS 6.5 y PHPMYADMIN

Install LAMP on CentOS 6.5 (Linux, Apache, MySQL,PHP)

================================
Update system
================================
yum update
chkconfig --list
chkconfig iptables off if enabled
chkconfig ip6tables off if enabled
chkconfig --list
vi /etc/sysconfig/selinux if enabled change to disabled

=================================
Install MySQL Server
=================================
yum install mysql mysql-server
chkconfig --levels 235 mysqld on
service mysqld start
mysql_secure_installation

==================================
Install httpd server
==================================
yum install httpd
chkconfig --levels 235 httpd on
service httpd start

==================================
Install PHP
==================================
yum install php
/etc/init.d/httpd restart

vi /var/www/html/info.php

service httpd restart

phpMyAdmin 4.5 Released. It is web-based client written in php for managing MySQL and MariaDB databases. It provides a user friendly web interface to access and manage your databases. To ease usage to a wide range of people, phpMyAdmin is being translated into 72 languages and supports both LTR and RTL languages.
Install phpMyAdmin

Features of phpMyAdmin:

    • Friendly web interface
    • Supported most of the MySQL features:
      • Browse and drop databases, tables, views, fields and indexes.
      • Create, copy, drop, rename and alter databases, tables, fields and indexes
      • Manage MySQL users and there privileges
    • Import data from CSV and SQL
    • Export data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 – OpenDocument Text and Spreadsheet, Word, LATEX and others
    • Administering multiple servers
This article will help you to install phpMyAdmin on CentOS/RedHat System. It required Apache, PHP and MySQL to be installed on server. If you do not have them read our turtorials to how to install them.
  • Installing Apache MySQL PHP on CentOS and RedHat
    • Step 1: Enable Remi Repository
    phpMyAdmin most updated package is available under remi repository. Install it in your system using following commands.
    CentOS/RHEL 7:
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-7.rpm
 
CentOS/RHEL 6:
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm 

CentOS/RHEL 5:
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm 

Fedora 20:
# rpm -Uvh http://rpms.famillecollet.com/remi-release-20.rpm
 
Fedora 19:
# rpm -Uvh http://rpms.famillecollet.com/remi-release-19.rpm
 
Fedora 18:
# rpm -Uvh http://rpms.famillecollet.com/remi-release-18.rpm
    Step 2: Install phpMyAdmin
    After adding remi repository, install phpMyAdmin using yum package manager. All the dependencies will automatically be installed.
    # yum --enablerepo=remi,remi-test  install phpMyAdmin
    Step 3: Configure phpMyAdmin
    phpMyAdmin by default allowed to access from localhost only. If you want to make it accessible from remote computers edit /etc/httpd/conf.d/phpMyAdmin.conf and update all 127.0.0.1 with your network like below or enable phpMyAdmin access for everyone.
    Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

## Comment below section to allow everyone 
<Directory /usr/share/phpMyAdmin/>
    <IfModule !mod_authz_core.c>
     Order Deny,Allow
     Deny from All
     Allow from 192.168.1.0/24
     Allow from ::1
   </IfModule>
</Directory>

<Directory /usr/share/phpMyAdmin/libraries/>
    Order Deny,Allow
    Deny from All
    Allow from None
</Directory>

<Directory /usr/share/phpMyAdmin/setup/lib/>
    Order Deny,Allow
    Deny from All
    Allow from None
</Directory>

<Directory /usr/share/phpMyAdmin/setup/frames/>
    Order Deny,Allow
    Deny from All
    Allow from None
</Directory>
    After updating phpMyAdmin Apache configuration file, restart Apache service to reload new settings.
    # service httpd restart
    Step 4: Access phpMyAdmin in Browser
    Now you can access phpMyAdmin in browser using following url. Change svr1.tecadmin.net with your server IP/FQDN.
    http://svr1.tecadmin.net/phpMyAdmin/

Login Details: Use MySQL username and password.
    phpMyAdmin-Login-Screen
    Congratulation’s You have successfully installed phpMyAdmin. Using single phpMyAdmin we can manage multiple MySQL servers by adding multiple remote MySQL server. Use this article to add multiple MySQL hosts in phpMyAdmin.

    Comentarios

    Publicar un comentario

    Entradas populares de este blog

    iscsiadm - Linux man page

    Name iscsiadm - open-iscsi administration utility Synopsis iscsiadm  -m discoverydb [ -hV ] [ -d debug_level ] [ -P printlevel ] [ -I iface -t type -p ip:port [ -lD ] ] | [ [ -p ip:port -t type ] [ -o operation ] [ -n name ] [ -v value ] [ -lD ] ] iscsiadm  -m discovery [ -hV ] [ -d debug_level ] [ -P printlevel ] [ -I iface -t type -p ip:port [ -l ] ] | [ [ -p ip:port ] [ -l | -D ] ] iscsiadm  -m node [ -hV ] [ -d debug_level ] [ -P printlevel ] [ -L all,manual,automatic ] [ -U all,manual,automatic ] [ -S ] [ [ -T targetname -p ip:port -I iface ] [ -l | -u | -R | -s] ] [ [ -o operation ] [ -n name ] [ -v value ] [ -p ip:port ] ] iscsiadm  -m session [ -hV ] [ -d debug_level ] [ -P printlevel ] [ -r sessionid | sysfsdir [ -R ] [ -u | -s ] ] iscsiadm  -m iface [ -hV ] [ -d debug_level ] [ -P printlevel ] [ -I ifacename ] [ [ -o operation ] [ -n name ] [ -v value ] ] iscsiadm  -m fw [-l] iscsiadm  -m host [ -P printlevel ] [ -H host...
    Leer más

    ESTIMAR ESPACIO TABLA O INDICE

    Desde Oracle 10g el paquete DBMS_SPACE incluye los procedimientos CREATE_TABLE_COST y CREATE_INDEX_COST, que permiten estimar el tamaño necesario para una tabla y un índice, respectivamente.Los datos básicos necesarios para estimar el tamaño de una tabla con CREATE_TABLE_COST son: el nombre del tablespace donde queremos crear la tabla, así como el número de filas que tendrá la tabla en cuestión. Para completar el proceso tenemos 2 opciones:  indicar longitud media de la fila (por ejemplo en el caso de que se trate de una tabla que ya existe, podemos sacarlo, si las estadísticas están actualizadas, de la columna USER_TABLES.AVG_ROW_LEN para la tabla en cuestión); o bien, indicar el tipo y longitud de cada columna, usando una variable del tipo SYS.CREATE_TABLE_COST_COLMNS. Sin embargo, para estimar el tamaño de un índice, tan sólo es necesaria la sentencia DDL básaica de creación del índice: "CREATE INDEX nombre_indice ON nombre de tabla (col1, ...)", pero l...
    Leer más

    T-SQL: Listar todas las tablas de una base de datos con sus respectivos tamaños

    Imagen
    Básicamente se trata de hacer una consulta de la tabla “sysindexes”, pero al tener muchos campos y algunos datos directamente ilegibles construimos una consulta haciendo las conversiones de datos solo de los campos que nos interesan, así como también los filtros respectivos para que no se incluya información que no sean propiedades de una tabla. Finalmente a esta consulta le podemos dar un formato numérico más legible y ordenarlo por el campo que nos sea de interés. En el siguiente ejemplo está ordenado descendente mente por número de registros que contiene la tabla. SELECT X.[name], REPLACE( CONVERT ( varchar , CONVERT (money, X.[ rows ]), 1), '.00' , '' ) AS [ rows ], REPLACE( CONVERT ( varchar , CONVERT (money, X.[reserved]), 1), '.00' , '' ) AS [reserved], REPLACE( CONVERT ( varchar , CONVERT (money, X.[ data ]), 1), '.00' , '' ) AS [ data ], REPLACE( CONVERT ( varchar , CONVERT...
    Leer más