Install MySQL 5.5 in CentOS

Install MySQL 5.5 in CentOS

1. Install cmake
# Install the required dependency package
Yum-y install gcc libxml2-dev curl screen \
Libpng12-dev autoconf libpcre3-dev make bzip2 \
Libevent-dev patch libjpeg62-dev libcurl4-openssl-dev \
Libfreetype6-dev g ++ libtool libncurses5-dev psmisc lrzsz
 
# Download an object
Wget http://www.cmake.org/files/v2.8/cmake-2.8.5.tar.gz

# Compile and install
Tar zxvf cmake-2.8.5.tar.gz
Cd cmake-2.8.5
./Boostarp
Make
Make install
Cmake-version
 
Ii. install and configure mysql
# Download source files
Wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.17.tar.gz/from/ftp://ftp.ntu.edu.tw/pub/MySQL/
# Or
Wget ftp://ftp.ntu.edu.tw/pub/MySQL/Downloads/MySQL-5.5/mysql-5.5.17.tar.gz
 
# Creating users and groups
Groupadd mysql
Useradd-g mysql-s/usr/sbin/nologin mysql
 
# Create an installation directory
Mkdir/usr/local/mysql
 
# Create a database directory
Mkdir/usr/local/mysql/data
 
# Decompress
Tar-zxvf mysql-5.5.17.tar.gz
Cd mysql-5.5.17
 
# Compile and install mysql
# Cmake Compilation:
Cmake-DCMAKE_INSTALL_PREFIX =/usr/local/mysql \
-DMYSQL_DATADIR =/usr/local/mysql/data \
-DDEFAULT_CHARSET = utf8 \
-DDEFAULT_COLLATION = utf8_unicode_ci \
-DWITH_READLINE = 1 \
-DWITH_SSL = system \
-DWITH_EMBEDDED_SERVER = 1 \
-DENABLED_LOCAL_INFILE = 1 \
-DDEFAULT_COLLATION = utf8_general_ci \
-DWITH_MYISAM_STORAGE_ENGINE = 1 \
-DWITH_INNOBASE_STORAGE_ENGINE = 1 \
-DWITH_DEBUG = 0
 
# Install mysql
Make & make install
 
# Copy the configuration file
Cp support-files/my-medium.cnf/etc/my. cnf
 
# Set permissions
Chmod + x/usr/local/mysql
Chown-R mysql. mysql/usr/local/mysql
Chown-R mysql: mysql/usr/local/mysql/data
 
# Configure auto-start upon startup
Cp support-files/mysql. server/etc/init. d/mysqld
Chmod + x/etc/init. d/mysqld
Chkconfig-add mysqld
Chkconfg mysqld on
 
# Modify my. cnf Configuration
Vim/etc/my. cnf
# [Mysqld] Add:
Datadir =/usr/local/mysql/data
Default-storage-engine = MyISAM
 
# Optional values:
Log-error =/usr/local/mysql/data/error. log
Pid-file =/usr/local/mysql/data/mysql. pid
User = mysql
Tmpdir =/tmp
 
# Initializing a database
/Usr/local/mysql/scripts/mysql_install_db -- user = mysql -- basedir =/usr/local/mysql -- datadir =/usr/local/mysql/data &
 
# Start MySQL
/Usr/local/mysql/bin/mysqld_safe-defaults-file =/etc/my. cnf &
Or:
/Etc/init. d/mysql start (service mysql start)
 
# Test whether MySQL is started
#1) check whether a mysql process exists
Ps-ef | grep mysql
#2) check whether the port is running
Netstat-tnl | grep 3306
#3) read mysql version information
/Usr/local/mysql/bin/mysqladmin version
 
# So far, MySQL installation is complete