Topics

Install MySQL 5.5.27 64-bit RPM on CentOS 6.2 x86_64

  • Install MySQL 5.5.27 64-bit RPM on CentOS 6.2 x86_64

Install MySQL 5.5.27 64-bit RPM on CentOS 6.2 x86_64

Check Installing CentOS 6.2 on VMware, Install PHP 5.3.10 with PHP-FPM on CentOS 6.2 64-bit, Install Nginx 1.0.12 for PHP-FPM on CentOS 6.2 and install memcached 1.4.13 on CentOS 6.2 posts.

– Remove old version

yum remove mysql mysql-devel mysql-server mysql-libs

– Download the needed packages from http://dev.mysql.com/downloads/mysql/#downloads
Download URL varies depending on download mirror

mkdir mysql
cd mysql
#MySQL-client-5.5.27-1.el6.x86_64.rpm
wget http://cdn.mysql.com/Downloads/MySQL-5.5/MySQL-client-5.5.27-1.el6.x86_64.rpm
#MySQL-shared-5.5.27-1.el6.x86_64.rpm
wget http://cdn.mysql.com/Downloads/MySQL-5.5/MySQL-shared-5.5.27-1.el6.x86_64.rpm
#MySQL-devel-5.5.27-1.el6.x86_64.rpm
wget http://cdn.mysql.com/Downloads/MySQL-5.5/MySQL-devel-5.5.27-1.el6.x86_64.rpm
#MySQL-server-5.5.27-1.el6.x86_64.rpm
wget http://cdn.mysql.com/Downloads/MySQL-5.5/MySQL-server-5.5.27-1.el6.x86_64.rpm
#MySQL-shared-compat-5.5.27-1.el6.x86_64.rpm
wget http://cdn.mysql.com/Downloads/MySQL-5.5/MySQL-shared-compat-5.5.27-1.el6.x86_64.rpm

#install
rpm -Uvh *
#create log dir
mkdir /var/log/mysql
chmod 777 /var/log/mysql

#start MySQL
/etc/init.d/mysql start
#add root password
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h centos6.vmware.local password 'new-password'

– configure mysql more info

vi /etc/my.cnf
Learn More

Configuring vsFTPd on CentOS with different port

Check Installing CentOS 6.2 on VMware post.

– make sure SELINUX is disabled and iptables is configured for FTP

– add ftp user

adduser ftpuser -g ftp -s /sbin/nologin -d /server
#set password
passwd ftpuser

– configuration, more info

Learn More

synchronize clock on CentOS server

Check Installing CentOS 6.2 on VMware post.

chkconfig --levels 235 ntpd on
/etc/init.d/ntpd restart
ntpdate 0.pool.ntp.org

– using dateconfig

yum groupinstall 'X Window System'
dateconfig
Learn More

disable root login

Check Installing CentOS 6.2 on VMware post.

This should make the server more secure, review creating admin users post

– this will disable logging in ssh as root

vi /etc/ssh/sshd_config 
#add
PermitRootLogin no
#restart ssh
/etc/init.d/sshd restart
Learn More

Adding new users and admins to Linux server

Check Installing CentOS 6.2 on VMware post.

Using admin user avoids common mistakes done when logging as root, instead use sudo to run root commands.

mkdir /server

#adding web-server user www
adduser www -d /server -s /sbin/nologin

#adding admins group to use instead of root
groupadd admins
visudo
#add
%admins ALL=(ALL)       NOPASSWD: ALL

#add new admin 
adduser admin -g admins
#set password
passwd admin

#add email for user admin
vi /etc/aliases
#add
admin: admin@example.com
#rebuild data
newaliases
Learn More