I would share the way to check the connection to MySQL database server. We can use the telnet or nc command to connect to port 3306. This would be very useful when we do the troubleshooting or to test the connectivity between the application server and the database server. Sample outputs will show succeeded or connected as below :
Host A = 192.168.0.5 Host B = 192.168.0.6
1. Test connectivity using nc command :
[root@192.168.0.5 ~]# nc -z -w1 192.168.0.6 3306
Connection to 192.168.0.6 3306 port [tcp/mysql] succeeded!
2. Test connectivity using telnet command :
[root@192.168.0.5 ~]# echo X | telnet -e X 192.168.0.6 3306
Telnet escape character is 'X'.
Trying 192.168.0.6...
Connected to 192.168.0.6.
Escape character is 'X'.
telnet> Connection closed.
LAMP stand for Linux, Apache, MySQL and PHP which is group of software used to run an web applications. The combination of these software is called LAMP stack. This document will walk you through the steps to install MySQL, Apache and PHP on CentOS 6.5.
What is Apache ? Apache httpd is one of the most popular web servers and has a lot of features that make it very extensible and useful for many different types of websites.
What is MySQL? MySQL Database server is one of the most popular used database in the internet especially for content management and blogging site.
What is PHP? PHP is a widely-used and open-source server-side scripting language that was especially designed for web development to produce dynamic web pages and can be embedded into HTML.
Steps : 1. Install MySQL, Apache and PHP :
[root@centos6-05 ~]# yum install mysql mysql-server httpd php* -y
2. Start Apache and MySQL :
[root@centos6-05 ~]# service httpd start
[root@centos6-05 ~]# service mysqld start
3. Check Apache, MySQL and PHP version : Apache
[root@centos6-05 ~]# httpd -v
Server version: Apache/2.2.15 (Unix)
Server built: Aug 13 2013 17:29:28
MySQL
[root@centos6-05 ~]# mysql -V
mysql Ver 14.14 Distrib 5.1.71, for redhat-linux-gnu (x86_64) using readline 5.1
PHP
[root@centos6-05 ~]# php -v
PHP 5.3.3 (cli) (built: Dec 11 2013 03:29:57)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
4. Verifying Apache, MySQL and PHP :
Create a page called phpinfo.php under web root directory /var/www/html.
MySQL Database server is one of the most popular used database in the internet especially for content management and blogging site. It’s can stores and retrieves data for the blog, websites and applications. This post will describes how you can install and securing MySQL on CentOS 6.4 virtual private server (VPS) or dedicated MySQL database server. For more information on MySQL, you can visit their website at www.mysql.com.
1. Install MySQL Database Server using yum command :
[root@centos64 ~]# yum install mysql mysql-server -y
Example :
[root@centos64 ~]# yum install mysql mysql-server -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.upsi.edu.my
* epel: kartolo.sby.datautama.net.id
* extras: mirror.upsi.edu.my
* updates: mirror.upsi.edu.my
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.1.69-1.el6_4 will be installed
--> Processing Dependency: mysql-libs = 5.1.69-1.el6_4 for package: mysql-5.1.69-1.el6_4.x86_64
---> Package mysql-server.x86_64 0:5.1.69-1.el6_4 will be installed
--> Processing Dependency: perl-DBI for package: mysql-server-5.1.69-1.el6_4.x86_64
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server-5.1.69-1.el6_4.x86_64
--> Processing Dependency: perl(DBI) for package: mysql-server-5.1.69-1.el6_4.x86_64
--> Running transaction check
---> Package mysql-libs.x86_64 0:5.1.67-1.el6_3 will be updated
---> Package mysql-libs.x86_64 0:5.1.69-1.el6_4 will be an update
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be installed
---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
====================================================================================================
Package Arch Version Repository Size
====================================================================================================
Installing:
mysql x86_64 5.1.69-1.el6_4 updates 907 k
mysql-server x86_64 5.1.69-1.el6_4 updates 8.7 M
Installing for dependencies:
perl-DBD-MySQL x86_64 4.013-3.el6 base 134 k
perl-DBI x86_64 1.609-4.el6 base 705 k
Updating for dependencies:
mysql-libs x86_64 5.1.69-1.el6_4 updates 1.2 M
Transaction Summary
====================================================================================================
Install 4 Package(s)
Upgrade 1 Package(s)
Total download size: 12 M
Downloading Packages:
(1/5): mysql-5.1.69-1.el6_4.x86_64.rpm | 907 kB 00:07
(2/5): mysql-libs-5.1.69-1.el6_4.x86_64.rpm | 1.2 MB 00:12
(3/5): mysql-server-5.1.69-1.el6_4.x86_64.rpm | 8.7 MB 01:30
(4/5): perl-DBD-MySQL-4.013-3.el6.x86_64.rpm | 134 kB 00:00
(5/5): perl-DBI-1.609-4.el6.x86_64.rpm | 705 kB 00:06
----------------------------------------------------------------------------------------------------
Total 101 kB/s | 12 MB 01:57
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Updating : mysql-libs-5.1.69-1.el6_4.x86_64 1/6
Installing : perl-DBI-1.609-4.el6.x86_64 2/6
Installing : perl-DBD-MySQL-4.013-3.el6.x86_64 3/6
Installing : mysql-5.1.69-1.el6_4.x86_64 4/6
Installing : mysql-server-5.1.69-1.el6_4.x86_64 5/6
Cleanup : mysql-libs-5.1.67-1.el6_3.x86_64 6/6
Verifying : mysql-libs-5.1.69-1.el6_4.x86_64 1/6
Verifying : perl-DBD-MySQL-4.013-3.el6.x86_64 2/6
Verifying : perl-DBI-1.609-4.el6.x86_64 3/6
Verifying : mysql-server-5.1.69-1.el6_4.x86_64 4/6
Verifying : mysql-5.1.69-1.el6_4.x86_64 5/6
Verifying : mysql-libs-5.1.67-1.el6_3.x86_64 6/6
Installed:
mysql.x86_64 0:5.1.69-1.el6_4 mysql-server.x86_64 0:5.1.69-1.el6_4
Dependency Installed:
perl-DBD-MySQL.x86_64 0:4.013-3.el6 perl-DBI.x86_64 0:1.609-4.el6
Dependency Updated:
mysql-libs.x86_64 0:5.1.69-1.el6_4
Complete!
2. Make mysqld daemon start at boot and start MySQL Database Server :
[root@centos64 ~]# chkconfig mysqld on
[root@centos64 ~]# service mysqld start
Initializing MySQL database: Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h centos64.ehowstuff.local password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /usr/mysql-test ; perl mysql-test-run.pl
Please report any problems with the /usr/bin/mysqlbug script!
[ OK ]
Starting mysqld: [ OK ]
3. Securing MySQL Database Server. This includes setting up the password for mysql root, remove anonymous users, disallow root login remotely and remove test database and access.
[root@centos64 ~]# /usr/bin/mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y
... Success!
By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
... Success!
Cleaning up...
All done! If you've completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
4. For testing, login to MySQL Server using defined password :
[root@centos64 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.1.69 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
+--------------------+
2 rows in set (0.01 sec)
mysql>
When i try to install WordPress, I’ve encountered this error and returned the following warning on browser :
“Your PHP installation appears to be missing the MySQL extension which is required by WordPress.”
Solution :
The reason for this is your existing PHP does not support mysql or php-mysql extension does not installed. To overcome this issue, just install php mysql support using below command on your virtual private server (VPS) or your dedicated web server. 1. Install php with mysql extension :
yum install php-mysql -y
2. Restart httpd :
[root@centos64 ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: [ OK ]
Example :
[root@centos64 html]# yum install php-mysql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.upsi.edu.my
* epel: ftp.cuhk.edu.hk
* extras: mirror.upsi.edu.my
* updates: mirror.upsi.edu.my
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php-mysql.x86_64 0:5.3.3-22.el6 will be installed
--> Processing Dependency: php-pdo(x86-64) for package: php-mysql-5.3.3-22.el6.x86_64
--> Running transaction check
---> Package php-pdo.x86_64 0:5.3.3-22.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
====================================================================================================
Package Arch Version Repository Size
====================================================================================================
Installing:
php-mysql x86_64 5.3.3-22.el6 base 81 k
Installing for dependencies:
php-pdo x86_64 5.3.3-22.el6 base 75 k
Transaction Summary
====================================================================================================
Install 2 Package(s)
Total download size: 155 k
Installed size: 383 k
Is this ok [y/N]: y
Downloading Packages:
(1/2): php-mysql-5.3.3-22.el6.x86_64.rpm | 81 kB 00:00
(2/2): php-pdo-5.3.3-22.el6.x86_64.rpm | 75 kB 00:00
----------------------------------------------------------------------------------------------------
Total 137 kB/s | 155 kB 00:01
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : php-pdo-5.3.3-22.el6.x86_64 1/2
Installing : php-mysql-5.3.3-22.el6.x86_64 2/2
Verifying : php-pdo-5.3.3-22.el6.x86_64 1/2
Verifying : php-mysql-5.3.3-22.el6.x86_64 2/2
Installed:
php-mysql.x86_64 0:5.3.3-22.el6
Dependency Installed:
php-pdo.x86_64 0:5.3.3-22.el6
Complete!
When we hosted the linux dedicated server or virtual private server(VPS) in a data center, security of the system is very important in order to ensure the data and the information are safe from the hackers. Securing and hardening linux dedicated server is mandatory when nearly every computing resources and the application systems is online and susceptible to attack. This post share basic security and hardening tips for the linux dedicated server. If you are plan to host your own linux dedicated server, then this post should able to provide you a good baseline and ideas. The following are the best practices to securing and hardening linux dedicated server :
1. Patching Linux Systems 2. Keep Linux Kernel and Software such as WordPress/Joomla Up to Date 3. Secure SSH 4. Enforcing Stronger Passwords and Password Aging 5. Disable Unnecessary Processes, Services and Daemons 6. Install a host based firewall to protect your dedicated server from unauthorized access 7. Implement Linux Kernel /etc/sysctl.conf hardening 8. Configure Logging and Auditing 9. Install And Use Intrusion Detection System
There are different types of hosting services are used in the computer technology such as shared hosting, VPS (Virtual Private Server) and Dedicated Server hosting. For new websites with low numbers of visitors, I would highly recommend getting a shared hosting. If you need more control of the server, then you should moving from shared hosting to a VPS. There are plenty of hosting companies offering Virtual Private Servers, and VPS hosting is getting cheaper. This blog hosted at RamNode VPS.
At some point, your site will get super slow server performance impact on limited resources when running VPS hosting. More server resources required is due to the increased number of visitors to the tens of thousands or hundreds of thousands per day.
At the situation when you are hitting super slow website performance due to huge numbers of traffic, I would recommend you to getting dedicated servers. Cheaper way is to setup VPS additional to balance the load. If cost is not an issue, I always recommend you to purchase a dedicated server as this will give you excellent processing performance. In a dedicated server environment , resources such as memory , hard drive storage capacity, processing power, and network access are all 100% to dedicated servers instead of shared with multiple VPS or dozens of shared hosting customers. Popular websites on the Internet certainly have excellent servers behind them. Without such an excellent server, web sites with high concurrency of visitors will not be able to survive.
If you are an experienced system administrator, the following articles may not attract you, but for web developers and those new to the web hosting, the following article can be a useful guide on their first steps. I believe the popular website on the internet has been setup by a consultant who specializes in servers or installed by an experienced system administrator. In this article, I would like to share 9 steps to setup Dedicated Server for your Website.
Once you have purchased a dedicated server, you can log in to your server to complete the setup of your server from start to finish. Below is a guide and checklist for you who are new to server administration.
9 Steps to Setup Dedicated Server
1. Choose and Install Linux operating system :
Choosing the right platform on which to host your dedicated server. Please make sure that you are familiar with the preferred operating system (OS) either CentOS or Fedora or Ubuntu or maybe Windows OS. If you choose linux OS, I would recommend you to do a clean minimal installed of the OS.
Apache httpd is one of the most popular web servers and has a lot of features that make it very extensible and useful for many different types of websites. As an alternative to Apache http server, you also can install NGINX. Nginx or “engine x” is a free, open-source HTTP server that provide high-performance edge web server with the lowest memory footprint and the key features to build modern and efficient web infrastructure. I used Nginx to run this blog.
MySQL server is a database server that can stores and retrieves data for the blog, websites and applications. It is one of the most popular most used in the internet especially for content management and blogging site.
5. Install PHP :
PHP: Hypertext Preprocessor is a widely used, free and open-source server-side scripting language that was especially designed for web development to produce dynamic web pages and can be embedded into HTML.
6. Install Bind DNS server :
BIND (the Berkeley Internet Name Domain) also known as NAMED is the most widely used DNS server in the internet. Bind DNS helps to resolve domain name to ip address and ip address to domain name.
7. Install FTP server :
File Transfer Protocol (FTP) is a network protocol used transfer file in the network. one of the most popular FTP server for Unix/Linux is vsftpd. Vsftpd stand for Very Secure FTP Daemon. Vsftpd not only just another popular FTP server for Unix/Linux systems, but vsftpd delivers excellent performance by consuming less memory.
8. Harden and Secure the dedicated server :
There are a few steps to harden the OS of dedicated server. a) Install a host based firewall to protect your dedicated server from unauthorized access: Once you have your web server running, you have to install host based firewall and open only certain port in your firewall. I would recommend you tosetting up iptables on your linux dedicated server.
b) Use Strong passwords : Password complexity requirements should be in place to enforce strong password. A strong password should have mixed case, special characters, numbers, and be longer than 8 characters. Additional security, the passwords should be changed regularly.
c) Disable Unnecessary Processes, Services and Daemons : I would recommend you to disable unneeded processes,services and daemon such as bluetooth, hidd, cups, yum-updatesd, ypbind, nfs, snmpd, saslauthd, netfs, gpm, pcmcia and sendmail. SELinux also should be set to “Disabled”. This is still very experimental so I would leave this disabled unless you really know what you are doing.
9. Install or migrate over the content of your website or blog :
You can start to migrate over the content of your website or blog to your new dedicated server. For dynamic content blog, i would recommend you to use WordPress as a platform. WordPress is an open-source blogging platform. It’s a free blogging tool and content management system (CMS) based on PHP and MySQL.
I hope that this 9 steps to setup dedicated server can be a useful guide on your first steps to have your own dedicated server to run a websites.
This post will covers the steps to install phpMyAdmin to operate MySQL from Web browser. phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. It can manage a whole MySQL server (needs a super-user) as well as a single database. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.
[root@centos63 ~]# yum --enablerepo=epel install phpMyAdmin php-mysql php-mcrypt -y
Loaded plugins: fastestmirror, presto
Loading mirror speeds from cached hostfile
* base: mirror.issp.co.th
* epel: mirror.nus.edu.sg
* extras: mirror.issp.co.th
* updates: mirror.issp.co.th
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php-mcrypt.i686 0:5.3.3-1.el6 will be installed
--> Processing Dependency: php-api = 20090626 for package: php-mcrypt-5.3.3-1.el6.i686
--> Processing Dependency: libmcrypt.so.4 for package: php-mcrypt-5.3.3-1.el6.i686
---> Package php-mysql.i686 0:5.3.3-14.el6_3 will be installed
--> Processing Dependency: php-pdo for package: php-mysql-5.3.3-14.el6_3.i686
---> Package phpMyAdmin.noarch 0:3.5.1-1.el6 will be installed
--> Processing Dependency: php-mbstring >= 5.2.0 for package: phpMyAdmin-3.5.1-1.el6.noarch
--> Processing Dependency: php-gd >= 5.2.0 for package: phpMyAdmin-3.5.1-1.el6.noarch
--> Processing Dependency: php >= 5.2.0 for package: phpMyAdmin-3.5.1-1.el6.noarch
--> Processing Dependency: php-php-gettext for package: phpMyAdmin-3.5.1-1.el6.noarch
--> Running transaction check
---> Package libmcrypt.i686 0:2.5.8-9.el6 will be installed
---> Package php.i686 0:5.3.3-14.el6_3 will be installed
--> Processing Dependency: php-cli = 5.3.3-14.el6_3 for package: php-5.3.3-14.el6_3.i686
---> Package php-common.i686 0:5.3.3-14.el6_3 will be installed
---> Package php-gd.i686 0:5.3.3-14.el6_3 will be installed
--> Processing Dependency: libpng12.so.0(PNG12_0) for package: php-gd-5.3.3-14.el6_3.i686
--> Processing Dependency: libpng12.so.0 for package: php-gd-5.3.3-14.el6_3.i686
--> Processing Dependency: libjpeg.so.62 for package: php-gd-5.3.3-14.el6_3.i686
--> Processing Dependency: libfreetype.so.6 for package: php-gd-5.3.3-14.el6_3.i686
--> Processing Dependency: libXpm.so.4 for package: php-gd-5.3.3-14.el6_3.i686
--> Processing Dependency: libX11.so.6 for package: php-gd-5.3.3-14.el6_3.i686
---> Package php-mbstring.i686 0:5.3.3-14.el6_3 will be installed
---> Package php-pdo.i686 0:5.3.3-14.el6_3 will be installed
---> Package php-php-gettext.noarch 0:1.0.11-3.el6 will be installed
--> Running transaction check
---> Package freetype.i686 0:2.3.11-6.el6_2.9 will be installed
---> Package libX11.i686 0:1.3-2.el6 will be installed
--> Processing Dependency: libX11-common = 1.3-2.el6 for package: libX11-1.3-2.el6.i686
--> Processing Dependency: libxcb.so.1 for package: libX11-1.3-2.el6.i686
---> Package libXpm.i686 0:3.5.8-2.el6 will be installed
---> Package libjpeg.i686 0:6b-46.el6 will be installed
---> Package libpng.i686 2:1.2.49-1.el6_2 will be installed
---> Package php-cli.i686 0:5.3.3-14.el6_3 will be installed
--> Running transaction check
---> Package libX11-common.noarch 0:1.3-2.el6 will be installed
---> Package libxcb.i686 0:1.5-1.el6 will be installed
--> Processing Dependency: libXau.so.6 for package: libxcb-1.5-1.el6.i686
--> Running transaction check
---> Package libXau.i686 0:1.0.5-1.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
====================================================================================================
Package Arch Version Repository Size
====================================================================================================
Installing:
php-mcrypt i686 5.3.3-1.el6 epel 18 k
php-mysql i686 5.3.3-14.el6_3 updates 77 k
phpMyAdmin noarch 3.5.1-1.el6 epel 4.2 M
Installing for dependencies:
freetype i686 2.3.11-6.el6_2.9 CentOS6.3-Repository 363 k
libX11 i686 1.3-2.el6 CentOS6.3-Repository 585 k
libX11-common noarch 1.3-2.el6 CentOS6.3-Repository 188 k
libXau i686 1.0.5-1.el6 CentOS6.3-Repository 22 k
libXpm i686 3.5.8-2.el6 CentOS6.3-Repository 58 k
libjpeg i686 6b-46.el6 CentOS6.3-Repository 133 k
libmcrypt i686 2.5.8-9.el6 epel 94 k
libpng i686 2:1.2.49-1.el6_2 CentOS6.3-Repository 184 k
libxcb i686 1.5-1.el6 CentOS6.3-Repository 104 k
php i686 5.3.3-14.el6_3 updates 1.1 M
php-cli i686 5.3.3-14.el6_3 updates 2.2 M
php-common i686 5.3.3-14.el6_3 updates 523 k
php-gd i686 5.3.3-14.el6_3 updates 103 k
php-mbstring i686 5.3.3-14.el6_3 updates 453 k
php-pdo i686 5.3.3-14.el6_3 updates 72 k
php-php-gettext noarch 1.0.11-3.el6 epel 21 k
Transaction Summary
====================================================================================================
Install 19 Package(s)
Total download size: 10 M
Installed size: 38 M
Downloading Packages:
Setting up and reading Presto delta metadata
updates/prestodelta | 72 kB 00:00
Processing delta metadata
Package(s) data still to download: 10 M
(1/19): libmcrypt-2.5.8-9.el6.i686.rpm | 94 kB 00:00
(2/19): php-5.3.3-14.el6_3.i686.rpm | 1.1 MB 00:09
(3/19): php-cli-5.3.3-14.el6_3.i686.rpm | 2.2 MB 00:19
(4/19): php-common-5.3.3-14.el6_3.i686.rpm | 523 kB 00:04
(5/19): php-gd-5.3.3-14.el6_3.i686.rpm | 103 kB 00:00
(6/19): php-mbstring-5.3.3-14.el6_3.i686.rpm | 453 kB 00:04
(7/19): php-mcrypt-5.3.3-1.el6.i686.rpm | 18 kB 00:00
(8/19): php-mysql-5.3.3-14.el6_3.i686.rpm | 77 kB 00:00
(9/19): php-pdo-5.3.3-14.el6_3.i686.rpm | 72 kB 00:00
(10/19): php-php-gettext-1.0.11-3.el6.noarch.rpm | 21 kB 00:00
(11/19): phpMyAdmin-3.5.1-1.el6.noarch.rpm | 4.2 MB 00:36
----------------------------------------------------------------------------------------------------
Total 135 kB/s | 10 MB 01:19
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : php-common-5.3.3-14.el6_3.i686 1/19
Installing : libX11-common-1.3-2.el6.noarch 2/19
Installing : php-mbstring-5.3.3-14.el6_3.i686 3/19
Installing : php-php-gettext-1.0.11-3.el6.noarch 4/19
Installing : php-cli-5.3.3-14.el6_3.i686 5/19
Installing : php-5.3.3-14.el6_3.i686 6/19
Installing : php-pdo-5.3.3-14.el6_3.i686 7/19
Installing : php-mysql-5.3.3-14.el6_3.i686 8/19
Installing : libmcrypt-2.5.8-9.el6.i686 9/19
Installing : php-mcrypt-5.3.3-1.el6.i686 10/19
Installing : libjpeg-6b-46.el6.i686 11/19
Installing : 2:libpng-1.2.49-1.el6_2.i686 12/19
Installing : libXau-1.0.5-1.el6.i686 13/19
Installing : libxcb-1.5-1.el6.i686 14/19
Installing : libX11-1.3-2.el6.i686 15/19
Installing : libXpm-3.5.8-2.el6.i686 16/19
Installing : freetype-2.3.11-6.el6_2.9.i686 17/19
Installing : php-gd-5.3.3-14.el6_3.i686 18/19
Installing : phpMyAdmin-3.5.1-1.el6.noarch 19/19
Verifying : freetype-2.3.11-6.el6_2.9.i686 1/19
Verifying : php-5.3.3-14.el6_3.i686 2/19
Verifying : php-cli-5.3.3-14.el6_3.i686 3/19
Verifying : libXau-1.0.5-1.el6.i686 4/19
Verifying : php-common-5.3.3-14.el6_3.i686 5/19
Verifying : php-mbstring-5.3.3-14.el6_3.i686 6/19
Verifying : libXpm-3.5.8-2.el6.i686 7/19
Verifying : 2:libpng-1.2.49-1.el6_2.i686 8/19
Verifying : libxcb-1.5-1.el6.i686 9/19
Verifying : phpMyAdmin-3.5.1-1.el6.noarch 10/19
Verifying : libX11-1.3-2.el6.i686 11/19
Verifying : php-php-gettext-1.0.11-3.el6.noarch 12/19
Verifying : php-gd-5.3.3-14.el6_3.i686 13/19
Verifying : libjpeg-6b-46.el6.i686 14/19
Verifying : libX11-common-1.3-2.el6.noarch 15/19
Verifying : php-mysql-5.3.3-14.el6_3.i686 16/19
Verifying : php-pdo-5.3.3-14.el6_3.i686 17/19
Verifying : php-mcrypt-5.3.3-1.el6.i686 18/19
Verifying : libmcrypt-2.5.8-9.el6.i686 19/19
Installed:
php-mcrypt.i686 0:5.3.3-1.el6 php-mysql.i686 0:5.3.3-14.el6_3 phpMyAdmin.noarch 0:3.5.1-1.el6
Dependency Installed:
freetype.i686 0:2.3.11-6.el6_2.9 libX11.i686 0:1.3-2.el6
libX11-common.noarch 0:1.3-2.el6 libXau.i686 0:1.0.5-1.el6
libXpm.i686 0:3.5.8-2.el6 libjpeg.i686 0:6b-46.el6
libmcrypt.i686 0:2.5.8-9.el6 libpng.i686 2:1.2.49-1.el6_2
libxcb.i686 0:1.5-1.el6 php.i686 0:5.3.3-14.el6_3
php-cli.i686 0:5.3.3-14.el6_3 php-common.i686 0:5.3.3-14.el6_3
php-gd.i686 0:5.3.3-14.el6_3 php-mbstring.i686 0:5.3.3-14.el6_3
php-pdo.i686 0:5.3.3-14.el6_3 php-php-gettext.noarch 0:1.0.11-3.el6
Complete!
2. on Line 14 or 15, add IP address you permit. In this case i have added 192.168.1.0/24 and i’m using apache 2.2 :
[root@centos63 ~]# vi /etc/httpd/conf.d/phpMyAdmin.conf
<Directory /usr/share/phpMyAdmin/>
<IfModule mod_authz_core.c>
# Apache 2.4
<RequireAny>
Require ip 127.0.0.1
Require ip ::1
</RequireAny>
</IfModule>
<IfModule !mod_authz_core.c>
# Apache 2.2
Order Deny,Allow
Deny from All
Allow from 127.0.0.1 192.168.1.0/24
Allow from ::1
</IfModule>
</Directory>
This post will covers the steps to install and securing MySQL Database Server. MySQL server is a database server that can stores and retrieves data for the blog, websites and applications. It is one of the most popular most used in the internet especially for content management and blogging site. MySQL is a Relational Database Management System (RDBMS) that runs as a server providing multi-user access to a number of databases. For more information on MySQL, you can visit their website at www.mysql.com.
1. Install MySQL Database Server using yum command :
[root@centos63 ~]# yum install mysql mysql-server -y
Examples :
[root@centos63 ~]# yum install mysql mysql-server -y
Loaded plugins: fastestmirror, presto
Loading mirror speeds from cached hostfile
* base: mirrors.hostemo.com
* extras: mirrors.hostemo.com
* updates: mirrors.hostemo.com
CentOS6.3-Repository | 4.0 kB 00:00 ...
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.i686 0:5.1.61-4.el6 will be installed
--> Processing Dependency: mysql-libs = 5.1.61-4.el6 for package: mysql-5.1.61-4.el6.i686
--> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16) for package: mysql-5.1.61-4.el6.i686
--> Processing Dependency: libmysqlclient_r.so.16 for package: mysql-5.1.61-4.el6.i686
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: mysql-5.1.61-4.el6.i686
--> Processing Dependency: libmysqlclient.so.16 for package: mysql-5.1.61-4.el6.i686
---> Package mysql-server.i686 0:5.1.61-4.el6 will be installed
--> Processing Dependency: perl-DBI for package: mysql-server-5.1.61-4.el6.i686
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server-5.1.61-4.el6.i686
--> Processing Dependency: perl(DBI) for package: mysql-server-5.1.61-4.el6.i686
--> Running transaction check
---> Package mysql-libs.i686 0:5.1.61-4.el6 will be installed
---> Package perl-DBD-MySQL.i686 0:4.013-3.el6 will be installed
---> Package perl-DBI.i686 0:1.609-4.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
====================================================================================================
Package Arch Version Repository Size
====================================================================================================
Installing:
mysql i686 5.1.61-4.el6 CentOS6.3-Repository 892 k
mysql-server i686 5.1.61-4.el6 CentOS6.3-Repository 8.8 M
Installing for dependencies:
mysql-libs i686 5.1.61-4.el6 CentOS6.3-Repository 1.2 M
perl-DBD-MySQL i686 4.013-3.el6 CentOS6.3-Repository 134 k
perl-DBI i686 1.609-4.el6 CentOS6.3-Repository 705 k
Transaction Summary
====================================================================================================
Install 5 Package(s)
Total download size: 12 M
Installed size: 33 M
Downloading Packages:
Setting up and reading Presto delta metadata
Processing delta metadata
Package(s) data still to download: 12 M
----------------------------------------------------------------------------------------------------
Total 22 MB/s | 12 MB 00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : mysql-libs-5.1.61-4.el6.i686 1/5
Installing : perl-DBI-1.609-4.el6.i686 2/5
Installing : perl-DBD-MySQL-4.013-3.el6.i686 3/5
Installing : mysql-5.1.61-4.el6.i686 4/5
Installing : mysql-server-5.1.61-4.el6.i686 5/5
Verifying : mysql-server-5.1.61-4.el6.i686 1/5
Verifying : perl-DBD-MySQL-4.013-3.el6.i686 2/5
Verifying : perl-DBI-1.609-4.el6.i686 3/5
Verifying : mysql-5.1.61-4.el6.i686 4/5
Verifying : mysql-libs-5.1.61-4.el6.i686 5/5
Installed:
mysql.i686 0:5.1.61-4.el6 mysql-server.i686 0:5.1.61-4.el6
Dependency Installed:
mysql-libs.i686 0:5.1.61-4.el6 perl-DBD-MySQL.i686 0:4.013-3.el6 perl-DBI.i686 0:1.609-4.el6
Complete!
2. Start MySQL Database Server :
[root@centos63 ~]# /etc/init.d/mysqld start
or
[root@centos63 ~]# service mysqld start
Examples :
Starting MySQL for first time will returned like this :
[root@centos63 ~]# /etc/init.d/mysqld start
Initializing MySQL database: WARNING: The host 'centos63.ehowstuff.local' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h centos63.ehowstuff.local password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /usr/mysql-test ; perl mysql-test-run.pl
Please report any problems with the /usr/bin/mysqlbug script!
[ OK ]
Starting mysqld: [ OK ]
3. Make MySQL Database Server auto start at boot :
[root@centos63 ~]# /usr/bin/mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y
... Success!
By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
... Success!
Cleaning up...
All done! If you've completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
5. Login to MySQL Server :
[root@centos63 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.1.61 Source distribution
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a Web browser. It is a tools that giving users the ability to interact with their MySQL databases to perform the task such as creating, modifying or drop databases, executing SQL statements, managing users and set permissions. This post will show you the steps on how to setup phpMyAdmin 3.5.1 on CentOS 6.2 using remi repository.
[root@centos62 ~]# vim /etc/httpd/conf.d/phpMyAdmin.conf
Original configuration file :
Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin
<Directory /usr/share/phpMyAdmin/>
order deny,allow
deny from all
allow from 127.0.0.1
allow from ::1
</Directory>
Modify to the following :
Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin
<Directory /usr/share/phpMyAdmin/>
order deny,allow
deny from all
allow from 127.0.0.1
allow from all
</Directory>
Once configured, restart the httpd as below :
[root@centos62 ~]# service httpd restart
Login to the phpmyadmin as below : http://192.168.1.44/phpmyadmin
In this post, i will share with you on how to install Apache Httpd, PHP and MySQL on linux CentOS 6.2 server. All these steps has been tested on CentOS 6.2. Assume that you have installed minimal installation type CentOS 6.2 and has setup your own local yum repository. You can use internet CentOS yum repository instead if you have direct internet connection to your server.
Apache httpd is one of the most popular web servers and has a lot of features that make it very extensible and useful for many different types of websites.
[root@centos6 ~]# yum install httpd
Loaded plugins: fastestmirror
Determining fastest mirrors
CentOS6.2-Repository | 1.3 kB 00:00 ...
CentOS6.2-Repository/primary | 1.2 MB 00:00 ...
CentOS6.2-Repository 3042/3042
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package httpd.i686 0:2.2.15-15.el6.centos will be installed
--> Processing Dependency: httpd-tools = 2.2.15-15.el6.centos for package: httpd-2.2.15-15.el6.centos.i686
--> Processing Dependency: libaprutil-1.so.0 for package: httpd-2.2.15-15.el6.centos.i686
--> Processing Dependency: libapr-1.so.0 for package: httpd-2.2.15-15.el6.centos.i686
--> Processing Dependency: apr-util-ldap for package: httpd-2.2.15-15.el6.centos.i686
--> Processing Dependency: /etc/mime.types for package: httpd-2.2.15-15.el6.centos.i686
--> Running transaction check
---> Package apr.i686 0:1.3.9-3.el6_1.2 will be installed
---> Package apr-util.i686 0:1.3.9-3.el6_0.1 will be installed
---> Package apr-util-ldap.i686 0:1.3.9-3.el6_0.1 will be installed
---> Package httpd-tools.i686 0:2.2.15-15.el6.centos will be installed
---> Package mailcap.noarch 0:2.1.31-2.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
===================================================================================================
Package Arch Version Repository Size
===================================================================================================
Installing:
httpd i686 2.2.15-15.el6.centos CentOS6.2-Repository 818 k
Installing for dependencies:
apr i686 1.3.9-3.el6_1.2 CentOS6.2-Repository 129 k
apr-util i686 1.3.9-3.el6_0.1 CentOS6.2-Repository 89 k
apr-util-ldap i686 1.3.9-3.el6_0.1 CentOS6.2-Repository 15 k
httpd-tools i686 2.2.15-15.el6.centos CentOS6.2-Repository 70 k
mailcap noarch 2.1.31-2.el6 CentOS6.2-Repository 27 k
Transaction Summary
===================================================================================================
Install 6 Package(s)
Total download size: 1.1 M
Installed size: 3.4 M
Is this ok [y/N]: y
Downloading Packages:
---------------------------------------------------------------------------------------------------
Total 3.8 MB/s | 1.1 MB 00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Installing : mailcap-2.1.31-2.el6.noarch 1/6
Installing : apr-1.3.9-3.el6_1.2.i686 2/6
Installing : apr-util-1.3.9-3.el6_0.1.i686 3/6
Installing : httpd-tools-2.2.15-15.el6.centos.i686 4/6
Installing : apr-util-ldap-1.3.9-3.el6_0.1.i686 5/6
Installing : httpd-2.2.15-15.el6.centos.i686 6/6
Installed:
httpd.i686 0:2.2.15-15.el6.centos
Dependency Installed:
apr.i686 0:1.3.9-3.el6_1.2 apr-util.i686 0:1.3.9-3.el6_0.1
apr-util-ldap.i686 0:1.3.9-3.el6_0.1 httpd-tools.i686 0:2.2.15-15.el6.centos
mailcap.noarch 0:2.1.31-2.el6
Complete!
2.0 How to Install php on CentOS 6.2
Next we proceed to Install the php packages on CentOS 6.2.
Simply run the following command :
[root@centos6 ~]# yum install php*
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
CentOS6.2-Repository | 1.3 kB 00:00 ...
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php.i686 0:5.3.3-3.el6_1.3 will be installed
---> Package php-cli.i686 0:5.3.3-3.el6_1.3 will be installed
--> Processing Dependency: libedit.so.0 for package: php-cli-5.3.3-3.el6_1.3.i686
---> Package php-common.i686 0:5.3.3-3.el6_1.3 will be installed
---> Package php-gd.i686 0:5.3.3-3.el6_1.3 will be installed
--> Processing Dependency: libpng12.so.0(PNG12_0) for package: php-gd-5.3.3-3.el6_1.3.i686
--> Processing Dependency: libpng12.so.0 for package: php-gd-5.3.3-3.el6_1.3.i686
--> Processing Dependency: libjpeg.so.62 for package: php-gd-5.3.3-3.el6_1.3.i686
--> Processing Dependency: libfreetype.so.6 for package: php-gd-5.3.3-3.el6_1.3.i686
--> Processing Dependency: libXpm.so.4 for package: php-gd-5.3.3-3.el6_1.3.i686
--> Processing Dependency: libX11.so.6 for package: php-gd-5.3.3-3.el6_1.3.i686
---> Package php-ldap.i686 0:5.3.3-3.el6_1.3 will be installed
---> Package php-mysql.i686 0:5.3.3-3.el6_1.3 will be installed
---> Package php-odbc.i686 0:5.3.3-3.el6_1.3 will be installed
--> Processing Dependency: libodbc.so.2 for package: php-odbc-5.3.3-3.el6_1.3.i686
---> Package php-pdo.i686 0:5.3.3-3.el6_1.3 will be installed
---> Package php-pear.noarch 1:1.9.4-4.el6 will be installed
---> Package php-pecl-apc.i686 0:3.1.3p1-1.2.el6.1 will be installed
---> Package php-pecl-memcache.i686 0:3.0.5-3.el6 will be installed
---> Package php-pgsql.i686 0:5.3.3-3.el6_1.3 will be installed
--> Processing Dependency: libpq.so.5 for package: php-pgsql-5.3.3-3.el6_1.3.i686
---> Package php-soap.i686 0:5.3.3-3.el6_1.3 will be installed
---> Package php-xml.i686 0:5.3.3-3.el6_1.3 will be installed
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.24) for package: php-xml-5.3.3-3.el6_1.3.i686
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.18) for package: php-xml-5.3.3-3.el6_1.3.i686
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.13) for package: php-xml-5.3.3-3.el6_1.3.i686
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.11) for package: php-xml-5.3.3-3.el6_1.3.i686
--> Processing Dependency: libxslt.so.1 for package: php-xml-5.3.3-3.el6_1.3.i686
--> Processing Dependency: libexslt.so.0 for package: php-xml-5.3.3-3.el6_1.3.i686
---> Package php-xmlrpc.i686 0:5.3.3-3.el6_1.3 will be installed
--> Running transaction check
---> Package freetype.i686 0:2.3.11-6.el6_1.7 will be installed
---> Package libX11.i686 0:1.3-2.el6 will be installed
--> Processing Dependency: libX11-common = 1.3-2.el6 for package: libX11-1.3-2.el6.i686
--> Processing Dependency: libxcb.so.1 for package: libX11-1.3-2.el6.i686
---> Package libXpm.i686 0:3.5.8-2.el6 will be installed
---> Package libedit.i686 0:2.11-4.20080712cvs.1.el6 will be installed
---> Package libjpeg.i686 0:6b-46.el6 will be installed
---> Package libpng.i686 2:1.2.46-1.el6_1 will be installed
---> Package libxslt.i686 0:1.1.26-2.el6 will be installed
---> Package postgresql-libs.i686 0:8.4.9-1.el6_1.1 will be installed
---> Package unixODBC.i686 0:2.2.14-11.el6 will be installed
--> Processing Dependency: libltdl.so.7 for package: unixODBC-2.2.14-11.el6.i686
--> Running transaction check
---> Package libX11-common.noarch 0:1.3-2.el6 will be installed
---> Package libtool-ltdl.i686 0:2.2.6-15.5.el6 will be installed
---> Package libxcb.i686 0:1.5-1.el6 will be installed
--> Processing Dependency: libXau.so.6 for package: libxcb-1.5-1.el6.i686
--> Running transaction check
---> Package libXau.i686 0:1.0.5-1.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=======================================================================================================
Package Arch Version Repository Size
=======================================================================================================
Installing:
php i686 5.3.3-3.el6_1.3 CentOS6.2-Repository 1.1 M
php-cli i686 5.3.3-3.el6_1.3 CentOS6.2-Repository 2.2 M
php-common i686 5.3.3-3.el6_1.3 CentOS6.2-Repository 522 k
php-gd i686 5.3.3-3.el6_1.3 CentOS6.2-Repository 102 k
php-ldap i686 5.3.3-3.el6_1.3 CentOS6.2-Repository 35 k
php-mysql i686 5.3.3-3.el6_1.3 CentOS6.2-Repository 76 k
php-odbc i686 5.3.3-3.el6_1.3 CentOS6.2-Repository 47 k
php-pdo i686 5.3.3-3.el6_1.3 CentOS6.2-Repository 71 k
php-pear noarch 1:1.9.4-4.el6 CentOS6.2-Repository 393 k
php-pecl-apc i686 3.1.3p1-1.2.el6.1 CentOS6.2-Repository 93 k
php-pecl-memcache i686 3.0.5-3.el6 CentOS6.2-Repository 60 k
php-pgsql i686 5.3.3-3.el6_1.3 CentOS6.2-Repository 66 k
php-soap i686 5.3.3-3.el6_1.3 CentOS6.2-Repository 138 k
php-xml i686 5.3.3-3.el6_1.3 CentOS6.2-Repository 98 k
php-xmlrpc i686 5.3.3-3.el6_1.3 CentOS6.2-Repository 50 k
Installing for dependencies:
freetype i686 2.3.11-6.el6_1.7 CentOS6.2-Repository 362 k
libX11 i686 1.3-2.el6 CentOS6.2-Repository 585 k
libX11-common noarch 1.3-2.el6 CentOS6.2-Repository 188 k
libXau i686 1.0.5-1.el6 CentOS6.2-Repository 22 k
libXpm i686 3.5.8-2.el6 CentOS6.2-Repository 58 k
libedit i686 2.11-4.20080712cvs.1.el6 CentOS6.2-Repository 73 k
libjpeg i686 6b-46.el6 CentOS6.2-Repository 133 k
libpng i686 2:1.2.46-1.el6_1 CentOS6.2-Repository 184 k
libtool-ltdl i686 2.2.6-15.5.el6 CentOS6.2-Repository 45 k
libxcb i686 1.5-1.el6 CentOS6.2-Repository 104 k
libxslt i686 1.1.26-2.el6 CentOS6.2-Repository 448 k
postgresql-libs i686 8.4.9-1.el6_1.1 CentOS6.2-Repository 201 k
unixODBC i686 2.2.14-11.el6 CentOS6.2-Repository 382 k
Transaction Summary
=======================================================================================================
Install 28 Package(s)
Total download size: 7.8 M
Installed size: 26 M
Is this ok [y/N]: y
Downloading Packages:
-------------------------------------------------------------------------------------------------------
Total 7.2 MB/s | 7.8 MB 00:01
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Installing : libX11-common-1.3-2.el6.noarch 1/28
Installing : php-common-5.3.3-3.el6_1.3.i686 2/28
Installing : php-pdo-5.3.3-3.el6_1.3.i686 3/28
Installing : libxslt-1.1.26-2.el6.i686 4/28
Installing : postgresql-libs-8.4.9-1.el6_1.1.i686 5/28
Installing : libedit-2.11-4.20080712cvs.1.el6.i686 6/28
Installing : php-cli-5.3.3-3.el6_1.3.i686 7/28
Installing : 1:php-pear-1.9.4-4.el6.noarch 8/28
Installing : libjpeg-6b-46.el6.i686 9/28
Installing : libtool-ltdl-2.2.6-15.5.el6.i686 10/28
Installing : unixODBC-2.2.14-11.el6.i686 11/28
Installing : 2:libpng-1.2.46-1.el6_1.i686 12/28
Installing : freetype-2.3.11-6.el6_1.7.i686 13/28
Installing : libXau-1.0.5-1.el6.i686 14/28
Installing : libxcb-1.5-1.el6.i686 15/28
Installing : libX11-1.3-2.el6.i686 16/28
Installing : libXpm-3.5.8-2.el6.i686 17/28
Installing : php-gd-5.3.3-3.el6_1.3.i686 18/28
Installing : php-odbc-5.3.3-3.el6_1.3.i686 19/28
Installing : php-pecl-apc-3.1.3p1-1.2.el6.1.i686 20/28
Installing : php-pecl-memcache-3.0.5-3.el6.i686 21/28
Installing : php-5.3.3-3.el6_1.3.i686 22/28
Installing : php-pgsql-5.3.3-3.el6_1.3.i686 23/28
Installing : php-xml-5.3.3-3.el6_1.3.i686 24/28
Installing : php-mysql-5.3.3-3.el6_1.3.i686 25/28
Installing : php-xmlrpc-5.3.3-3.el6_1.3.i686 26/28
Installing : php-ldap-5.3.3-3.el6_1.3.i686 27/28
Installing : php-soap-5.3.3-3.el6_1.3.i686 28/28
Installed:
php.i686 0:5.3.3-3.el6_1.3 php-cli.i686 0:5.3.3-3.el6_1.3
php-common.i686 0:5.3.3-3.el6_1.3 php-gd.i686 0:5.3.3-3.el6_1.3
php-ldap.i686 0:5.3.3-3.el6_1.3 php-mysql.i686 0:5.3.3-3.el6_1.3
php-odbc.i686 0:5.3.3-3.el6_1.3 php-pdo.i686 0:5.3.3-3.el6_1.3
php-pear.noarch 1:1.9.4-4.el6 php-pecl-apc.i686 0:3.1.3p1-1.2.el6.1
php-pecl-memcache.i686 0:3.0.5-3.el6 php-pgsql.i686 0:5.3.3-3.el6_1.3
php-soap.i686 0:5.3.3-3.el6_1.3 php-xml.i686 0:5.3.3-3.el6_1.3
php-xmlrpc.i686 0:5.3.3-3.el6_1.3
Dependency Installed:
freetype.i686 0:2.3.11-6.el6_1.7 libX11.i686 0:1.3-2.el6
libX11-common.noarch 0:1.3-2.el6 libXau.i686 0:1.0.5-1.el6
libXpm.i686 0:3.5.8-2.el6 libedit.i686 0:2.11-4.20080712cvs.1.el6
libjpeg.i686 0:6b-46.el6 libpng.i686 2:1.2.46-1.el6_1
libtool-ltdl.i686 0:2.2.6-15.5.el6 libxcb.i686 0:1.5-1.el6
libxslt.i686 0:1.1.26-2.el6 postgresql-libs.i686 0:8.4.9-1.el6_1.1
unixODBC.i686 0:2.2.14-11.el6
Complete!
3.0 How to Install MySQL Database Server on CentOS 6.2
This post will show you on how to install MySQL server using yum command.
Simply run the following command :
[root@centos6 ~]# yum install mysql mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.i686 0:5.1.52-1.el6_0.1 will be installed
---> Package mysql-server.i686 0:5.1.52-1.el6_0.1 will be installed
--> Processing Dependency: perl-DBI for package: mysql-server-5.1.52-1.el6_0.1.i686
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server-5.1.52-1.el6_0.1.i686
--> Processing Dependency: perl(DBI) for package: mysql-server-5.1.52-1.el6_0.1.i686
--> Running transaction check
---> Package perl-DBD-MySQL.i686 0:4.013-3.el6 will be installed
---> Package perl-DBI.i686 0:1.609-4.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=================================================================================================
Package Arch Version Repository Size
=================================================================================================
Installing:
mysql i686 5.1.52-1.el6_0.1 CentOS6.2-Repository 898 k
mysql-server i686 5.1.52-1.el6_0.1 CentOS6.2-Repository 8.3 M
Installing for dependencies:
perl-DBD-MySQL i686 4.013-3.el6 CentOS6.2-Repository 134 k
perl-DBI i686 1.609-4.el6 CentOS6.2-Repository 705 k
Transaction Summary
=================================================================================================
Install 4 Package(s)
Total download size: 10 M
Installed size: 27 M
Is this ok [y/N]: y
Downloading Packages:
-------------------------------------------------------------------------------------------------
Total 13 MB/s | 10 MB 00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : perl-DBI-1.609-4.el6.i686 1/4
Installing : perl-DBD-MySQL-4.013-3.el6.i686 2/4
Installing : mysql-5.1.52-1.el6_0.1.i686 3/4
Installing : mysql-server-5.1.52-1.el6_0.1.i686 4/4
Installed:
mysql.i686 0:5.1.52-1.el6_0.1 mysql-server.i686 0:5.1.52-1.el6_0.1
Dependency Installed:
perl-DBD-MySQL.i686 0:4.013-3.el6 perl-DBI.i686 0:1.609-4.el6
Complete!
Hope all these three steps will be useful when installing Apache, PHP and MySQL on linux Centos 6.2 server
phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. It can manage a whole MySQL server (needs a super-user) as well as a single database. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement. In this post, i will show on how to install phpMyAdmin on CentOS 6.2 using EPEL repository. This post assumed that MySQL and Apache Httpd server has been installed and configured as per documented guidelines below : How to Install Httpd on CentOS 6.2 How to Install MySQL Database Server on CentOS 6.2 How to Secure MySQL Database Server
1. How to Install and Configure EPEL Repository : Follow this steps to install and configure the Extra Packages for Enterprise Linux (EPEL) repository on CentOS 6.2. EPEL repository is another extra repository that creates, maintains, and manages a high quality set of additional packages for Enterprise Linux, including, but not limited to, Red Hat Enterprise Linux (RHEL) and CentOS server.
2. Simply run yum command to install phpmyadmin :
[root@centos62 ~]# yum install phpmyadmin -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.hostemo.com
* epel: ftp.riken.jp
* extras: mirrors.hostemo.com
* updates: ossm.utm.my
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package phpMyAdmin.noarch 0:3.4.9-1.el6 will be installed
--> Processing Dependency: php-gd >= 5.2.0 for package: phpMyAdmin-3.4.9-1.el6.noarch
--> Processing Dependency: php-php-gettext for package: phpMyAdmin-3.4.9-1.el6.noarch
--> Running transaction check
---> Package php-gd.i686 0:5.3.3-3.el6_2.6 will be installed
---> Package php-php-gettext.noarch 0:1.0.11-3.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
====================================================================================================
Package Arch Version Repository Size
====================================================================================================
Installing:
phpMyAdmin noarch 3.4.9-1.el6 epel 4.1 M
Installing for dependencies:
php-gd i686 5.3.3-3.el6_2.6 updates 102 k
php-php-gettext noarch 1.0.11-3.el6 epel 21 k
Transaction Summary
====================================================================================================
Install 3 Package(s)
Total download size: 4.2 M
Installed size: 15 M
Downloading Packages:
(1/3): php-gd-5.3.3-3.el6_2.6.i686.rpm | 102 kB 00:00
(2/3): php-php-gettext-1.0.11-3.el6.noarch.rpm | 21 kB 00:00
(3/3): phpMyAdmin-3.4.9-1.el6.noarch.rpm | 4.1 MB 00:46
----------------------------------------------------------------------------------------------------
Total 89 kB/s | 4.2 MB 00:48
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : php-php-gettext-1.0.11-3.el6.noarch 1/3
Installing : php-gd-5.3.3-3.el6_2.6.i686 2/3
Installing : phpMyAdmin-3.4.9-1.el6.noarch 3/3
Installed:
phpMyAdmin.noarch 0:3.4.9-1.el6
Dependency Installed:
php-gd.i686 0:5.3.3-3.el6_2.6 php-php-gettext.noarch 0:1.0.11-3.el6
Complete!
3. Open the phpMyAdmin.conf configuration file as below :
[root@centos62 ~]# vi /etc/httpd/conf.d/phpMyAdmin.conf
Original phpMyAdmin.conf configuration file :
<Directory /usr/share/phpMyAdmin/>
Order Deny,Allow
Deny from All
Allow from 127.0.0.1
Allow from ::1
</Directory>
Change as below. Default setting only allows only localhost. Changes below will allow access to any ip address but very dangerous unless properly secured by SSL :
<Directory /usr/share/phpMyAdmin/>
Order Deny,Allow
Deny from All
Allow from All
Allow from ::1
</Directory>
4. Restart apache httpd service to take effect :
[root@centos62 ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: [ OK ]
5. Open PhpMyAdmin from myour browser using the following URL :
phpMyAdmin is a free software written in PHP intended to handle the administration of MySQL over the World Wide Web. It can manage a whole MySQL server (needs – super user ) and database. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement. In this article, I will explain step how to install phpMyAdmin on CentOS 6.2.
[root@centos62 ~]# wget http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/3.4.9/phpMyAdmin-3.4.9-all-languages.tar.gz
--2012-02-08 19:39:45-- http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/3.4.9/phpMyAdmin-3.4.9-all-languages.tar.gz/download
Resolving sourceforge.net... 216.34.181.60
Connecting to sourceforge.net|216.34.181.60|:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.4.9/phpMyAdmin-3.4.9-all-languages.tar.gz?r=&ts=1328701188&use_mirror=cdnetworks-kr-1 [following]
--2012-02-08 19:39:46-- http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.4.9/phpMyAdmin-3.4.9-all-languages.tar.gz?r=&ts=1328701188&use_mirror=cdnetworks-kr-1
Resolving downloads.sourceforge.net... 216.34.181.59
Connecting to downloads.sourceforge.net|216.34.181.59|:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://cdnetworks-kr-1.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.4.9/phpMyAdmin-3.4.9-all-languages.tar.gz [following]
--2012-02-08 19:39:47-- http://cdnetworks-kr-1.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.4.9/phpMyAdmin-3.4.9-all-languages.tar.gz
Resolving cdnetworks-kr-1.dl.sourceforge.net... 211.39.135.162
Connecting to cdnetworks-kr-1.dl.sourceforge.net|211.39.135.162|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 5763130 (5.5M) [application/x-gzip]
Saving to: âphpMyAdmin-3.4.9-all-languages.tar.gzâ
100%[==========================================================>] 5,763,130 39.4K/s in 91s
2012-02-08 19:41:18 (62.2 KB/s) - âphpMyAdmin-3.4.9-all-languages.tar.gzâ
4. Copy phpMyAdmin-3.4.9-all-languages.tar.gz to DocumentRoot and extract the tar file. Make phpMyAdmin-XX executable. Create config folder and make it writable :
[root@centos62 ~]# mv phpMyAdmin-3.4.9-all-languages.tar.gz /var/www/html/
[root@centos62 ~]# cd /var/www/html/
[root@centos62 html]# tar -xzvf phpMyAdmin-3.4.9-all-languages.tar.gz
[root@centos62 html]# chmod 655 phpMyAdmin-3.4.9-all-languages/
[root@centos62 html]# mv phpMyAdmin-3.4.9-all-languages phpmyadmin
[root@centos62 html]# cd phpmyadmin
5. Copy config.sample.inc.php into config.inc.php. config.inc.php will be the main configuration file :
7. Create the pma user and give access to databse and tables :
mysql> CREATE USER 'pma'@'localhost' IDENTIFIED BY 'pmapassword';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON phpmyadmin.* to pma@localhost;
Query OK, 0 rows affected (0.00 sec)
8. Import the create_tables.sql into phpmyadmin database :
[root@centos62 ~]# mysql -u pma -p -h localhost phpmyadmin < /var/www/html/phpmyadmin/scripts/create_tables.sql
Enter password:
Now, the "phpmyadmin" database has been created, and also the user "pma" exists with that password, that user has all privileges on DB "phpmyadmin" and has all privileges on all tables.
9. Edit configuration file as below :
[root@centos62 ~]# vi /var/www/html/phpmyadmin/config.inc.php
9.1 Modify config.inc.php and add blowfish_secret as below :
$cfg['blowfish_secret'] = 'blowfish_secret@123'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
9.2 Please change auth_type to “cookie” :
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
9.3 Enable advanced features in configuration file as below. Uncomment the below lines :
MySQL Database server is one of the most popular used database in the internet especially for content management and blogging site. It’s can stores and retrieves data for the blog, websites and applications. This post will describes how you can install and securing MySQL on CentOS 6.4 virtual private server (VPS) or dedicated MySQL database server. For more information on MySQL, you can visit their website at www.mysql.com.
When we hosted the linux dedicated server or virtual private server(VPS) in a data center, security of the system is very important in order to ensure the data and the information are safe from the hackers. Securing and hardening linux dedicated server is mandatory when nearly every computing resources and the application systems is online and susceptible to attack. This post share basic security and hardening tips for the linux dedicated server. If you are plan to host your own linux dedicated server, then this post should able to provide you a good baseline and ideas. The following are the best practices to securing and hardening linux dedicated server :
There are different types of hosting services are used in the computer technology such as shared hosting, VPS (Virtual Private Server) and Dedicated Server hosting. For new websites with low numbers of visitors, I would highly recommend getting a shared hosting. If you need more control of the server, then you should moving from shared hosting to a VPS. There are plenty of hosting companies offering Virtual Private Servers, and VPS hosting is getting cheaper. This blog hosted at 
This post will covers the steps to install phpMyAdmin to operate MySQL from Web browser. phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. It can manage a whole MySQL server (needs a super-user) as well as a single database. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.
