Install MySQL 5.5.32 and centoscmake in CentOS 6.5 cmake under VMware10.0.4

Install MySQL 5.5.32 and centoscmake in CentOS 6.5 cmake under VMware10.0.4

I. Preparations

1.1 create the zhuzz/tools directory

[root@localhost ~]# mkdir -p /home/zhuzz/tools[root@localhost ~]# cd /home/zhuzz/tools

 

1.2、upload the cmake-2.8.8.tar.gz | mysql-5.5.32.tar to the zhuzz/tools directory

[root@localhost tools]# rz -y

 

1.3 decompress the cmake installation package

[root@localhost tools]# tar xf cmake-2.8.8.tar.gz

  1.4 install the cmake installation package

[root@localhost tools]# cd cmake-2.8.8[root@localhost cmake-2.8.8]# ./configure

##### Error Reporting #####

---------------------------------------------CMake 2.8.8, Copyright 2000-2011 Kitware, Inc.---------------------------------------------Error when bootstrapping CMake:Cannot find appropriate C compiler on this system.Please specify one using environment variable CC.See cmake_bootstrap.log for compilers attempted. ---------------------------------------------Log of errors: /home/zhuzz/tools/cmake-2.8.8/Bootstrap.cmk/cmake_bootstrap.log---------------------------------------------

##### Solution download and install gcc-c ++ #####

[root@localhost cmake-2.8.8]# yum install gcc-c++

 

[root@localhost cmake-2.8.8]# gmake [root@localhost cmake-2.8.8]# gmake install

 

1.5 install the dependency package ncurses-devel

[root@localhost cmake-2.8.8]# yum install ncurses-devel -y

Ii. Installation 2.1 create users and groups

[root@localhost cmake-2.8.8]# groupadd mysql[root@localhost cmake-2.8.8]# useradd mysql -s /sbin/nologin -M -g mysql

 

2.2 unzip the mysql-5.5.32.tar.gz and enter this directory

[root@localhost cmake-2.8.8]# cd ..[root@localhost tools]# tar xf mysql-5.5.32.tar.gz[root@localhost tools]# cd mysql-5.5.32

 

2.3 decompress and compile the MySQL installation package

[root@localhost tools]# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.5.32 \-DMYSQL_DATADIR=/usr/local/mysql-5.5.32/data \-DMYSQL_UNIX_ADDR=/usr/local/mysql-5.5.32/tmp/mysql.sock \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_FEDERATED_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \-DWITH_READLINE=1 \-DENABLED_LOCAL_INFILE=1 \-DWITH_DEBUG=0 \

 

[root@localhost mysql-5.5.32]# make && make install

 

2.4 create soft links

[root@localhost mysql-5.5.32]# ln -s /usr/local/mysql-5.5.32/  /usr/local/mysql

 

2.5 configuration file

[root@localhost mysql-5.5.32]# cp support-files/my-small.cnf /etc/my.cnf 

 

  2.6 configure Environment Variables

[root@localhost mysql-5.5.32]# echo 'export PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile[root@localhost mysql-5.5.32]# tail -l /etc/profile[root@localhost mysql-5.5.32]# source /etc/profile[root@localhost mysql-5.5.32]# echo $PATH/usr/local/mysql/bin:/usr/lib/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

 

2.7 authorization

[root@localhost mysql-5.5.32]# cd /usr/local/mysql[root@localhost mysql]# chown -R mysql.mysql ./[root@localhost mysql]# chmod -R 1777 /tmp/

 

Iii. Initialization and startup
3.1 enter the mysql/scripts directory in the installation directory and initialize

[root@localhost mysql]# cd /usr/local/mysql/scripts/

[root@localhost scripts]# ./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=mysql

 

##### Initialize OK when you see it #####

Installing MySQL system tables...OKFilling help tables...OK

 

3.2, Configuration File

[root@localhost scripts]# cd /home/zhuzz/tools/mysql-5.5.32[root@localhost mysql-5.5.32]# cp support-files/mysql.server /etc/init.d/mysqld

 

3.3. Authorize the mysql startup directory

[root@localhost mysql-5.5.32]# chmod +x /etc/init.d/mysqld

 

3.4 start MySQL

[root@localhost mysql-5.5.32]# /etc/init.d/mysqld start[root@localhost mysql-5.5.32]# mysqlmysql> quit

 

3.5 modify the password bin to verify whether the installation is successful

[Root @ localhost mysql-5.5.32] #/usr/local/mysql // bin/mysqladmin-u root password 'root' [root @ localhost mysql-5.5.32] # chkconfig mysqld on [root @ localhost mysql-5.5.32] # chkconfig -- list mysqld 0: disable 1: Disable 2: Enable 3: Enable 4: Enable 5: Enable 6: Disable

 

Iv. Remarks:

4.1 add an additional administrator.

mysql>delete from mysql.user;mysql>grant all privileges on *.* to system@'localhost' identified by 'system' with grant option;

 

4.2 successful initialization:

Installing MySQL system tables...OKFilling help tables...OKTo start mysqld at boot time you have to copysupport-files/mysql.server to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !To do so, start the server, then issue the following commands:/usr/local/mysql//bin/mysqladmin -u root password 'new-password'/usr/local/mysql//bin/mysqladmin -u root -h localhost.localdomain password 'new-password'Alternatively you can run:/usr/local/mysql//bin/mysql_secure_installationwhich will also give you the option of removing the testdatabases and anonymous user created by default.  This isstrongly recommended for production servers.See the manual for more instructions.You can start the MySQL daemon with:cd /usr/local/mysql/ ; /usr/local/mysql//bin/mysqld_safe &You can test the MySQL daemon with mysql-test-run.plcd /usr/local/mysql//mysql-test ; perl mysql-test-run.plPlease report any problems with the /usr/local/mysql//scripts/mysqlbug script!