1.拷贝cmake-2.8.8.tar.gz和mysql-5.5.32.tar.gz至/opt文件夹下
2.安装步骤:
--切换到opt目录
[root@mysql ~]# cd /opt
[root@mysql opt]# ls
cmake-2.8.8.tar.gz mysql-5.5.32.tar.gz rh
--解压cmake文件
[root@mysql opt]# tar xf cmake-2.8.8.tar.gz
[root@mysql opt]# cd cmake-2.8.8
[root@mysql cmake-2.8.8]# ls
bootstrap CompileFlags.cmake doxygen.config
ChangeLog.manual configure Example
ChangeLog.txt Copyright.txt Modules
CMakeCPack.cmake CTestConfig.cmake Readme.txt
CMakeCPackOptions.cmake.in CTestCustom.cmake.in Source
CMakeGraphVizOptions.cmake CTestCustom.ctest.in Templates
CMakeLists.txt DartConfig.cmake Tests
CMakeLogo.gif DartLocal.conf.in Utilities
cmake_uninstall.cmake.in Docs
--进行cmake的安装
[root@mysql cmake-2.8.8]# ./configure
CMake has bootstrapped. Now run gmake.
[root@mysql cmake-2.8.8]# gmake
[root@mysql cmake-2.8.8]# gmake install
--添加mysql用户和组
[root@mysql cmake-2.8.8]# groupadd mysql
[root@mysql cmake-2.8.8]# useradd mysql -s /sbin/nologin -M -g mysql
--yum安装ncurses-devel
[root@mysql /]# yum install ncurses-devel -y
--解压mysql文件
[root@mysql /]# cd /opt
[root@mysql opt]# tar xf mysql-5.5.32.tar.gz
[root@mysql opt]# cd mysql-5.5.32
[root@mysql mysql-5.5.32]# ls
BUILD CMakeLists.txt COPYING include libmysqld mysys regex sql-common tests win
BUILD-CMAKE cmd-line-utils dbug INSTALL-SOURCE libservices packaging scripts storage unittest zlib
client config.h.cmake Docs INSTALL-WIN-SOURCE man plugin sql strings VERSION
cmake configure.cmake extra libmysql mysql-test README sql-bench support-files vio
--安装之前编译mysql
cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 \
-DMYSQL_DATADIR=/application/mysql-5.5.32/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.5.32/tmp/mysql.sock \
-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_DEBUG=0
--mysql安装
[root@mysql mysql-5.5.32]# make && make install
[root@mysql mysql-5.5.32]# ln -s /application/mysql-5.5.32/ /application/mysql
--以下为单实例安装配置所需执行步骤,多实例可暂时跳过
[root@mysql mysql-5.5.32]# ls
BUILD CMakeLists.txt CTestTestfile.cmake INSTALL-SOURCE man scripts tests
BUILD-CMAKE cmd-line-utils dbug INSTALL-WIN-SOURCE mysql-test sql unittest
client config.h.cmake Docs libmysql mysys sql-bench VERSION
cmake configure.cmake extra libmysqld packaging sql-common VERSION.dep
CMakeCache.txt COPYING include libservices plugin storage vio
CMakeFiles CPackConfig.cmake info_macros.cmake make_dist.cmake README strings win
cmake_install.cmake CPackSourceConfig.cmake install_manifest.txt Makefile regex support-files zlib
--选择配置文件
[root@mysql mysql-5.5.32]# cp support-files/my-small.cnf /etc/my.cnf
cp: overwrite `/etc/my.cnf'? y
--查看是否有mysql/data目录
[root@mysql mysql-5.5.32]# ll /application/mysql/data/
total 4
drwxr-xr-x. 2 root root 4096 Aug 15 15:38 test
[root@mysql mysql-5.5.32]# chown -R mysql.mysql /application/mysql/data/
[root@mysql mysql-5.5.32]# chmod -R 1777 /tmp/
[root@mysql mysql-5.5.32]# cd /application/mysql/scripts/
[root@mysql scripts]# ls
mysql_install_db
[root@mysql scripts]# cd /application/mysql/scripts/
[root@mysql scripts]# ./mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql
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:
/application/mysql//bin/mysqladmin -u root password 'new-password'
/application/mysql//bin/mysqladmin -u root -h mysql password 'new-password'
Alternatively you can run:
/application/mysql//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 /application/mysql/ ; /application/mysql//bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /application/mysql//mysql-test ; perl mysql-test-run.pl
Please report any problems with the /application/mysql//scripts/mysqlbug script!
[root@mysql scripts]# cd ..
[root@mysql mysql]# ls
bin COPYING data docs include INSTALL-BINARY lib man mysql-test README scripts share sql-bench support-files
[root@mysql mysql]# cd /opt/mysql-5.5.32
[root@mysql mysql-5.5.32]# ls
BUILD CMakeLists.txt CTestTestfile.cmake INSTALL-SOURCE man scripts tests
BUILD-CMAKE cmd-line-utils dbug INSTALL-WIN-SOURCE mysql-test sql unittest
client config.h.cmake Docs libmysql mysys sql-bench VERSION
cmake configure.cmake extra libmysqld packaging sql-common VERSION.dep
CMakeCache.txt COPYING include libservices plugin storage vio
CMakeFiles CPackConfig.cmake info_macros.cmake make_dist.cmake README strings win
cmake_install.cmake CPackSourceConfig.cmake install_manifest.txt Makefile regex support-files zlib
[root@mysql mysql-5.5.32]# cp support-files/mysql.server /etc/init.d/mysqld
[root@mysql mysql-5.5.32]# chmod +x /etc/init.d/mysqld
[root@mysql mysql-5.5.32]# /etc/init.d/mysqld start
Starting MySQL.. SUCCESS!
[root@mysql mysql-5.5.32]# netstat -lntup|grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 28462/mysqld
--配置环境变量
[root@mysql mysql-5.5.32]# echo 'export PATH=/application/mysql/bin:$PATH'>>/etc/profile
[root@mysql mysql-5.5.32]# tail -1 /etc/profile
export PATH=/application/mysql/bin:$PATH
[root@mysql mysql-5.5.32]# source /etc/profile
[root@mysql mysql-5.5.32]# echo $PATH
/application/mysql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
[root@mysql mysql-5.5.32]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.32 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> select user,host from mysql.user;
+------+-----------+
| user | host |
+------+-----------+
| root | 127.0.0.1 |
| root | ::1 |
| | localhost |
| root | localhost |
| | mysql |
| root | mysql |
+------+-----------+
6 rows in set (0.00 sec)
mysql> delete from mysql.user where user='';
Query OK, 2 rows affected (0.00 sec)
mysql> select user,host from mysql.user;
+------+-----------+
| user | host |
+------+-----------+
| root | 127.0.0.1 |
| root | ::1 |
| root | localhost |
| root | mysql |
+------+-----------+
4 rows in set (0.00 sec)
mysql> delete from mysql.user where host='mysql';
Query OK, 1 row affected (0.00 sec)
mysql> select user,host from mysql.user;
+------+-----------+
| user | host |
+------+-----------+
| root | 127.0.0.1 |
| root | ::1 |
| root | localhost |
+------+-----------+
3 rows in set (0.00 sec)
mysql> delete from mysql.user where host='::1';
Query OK, 1 row affected (0.00 sec)
mysql> select user,host from mysql.user;
+------+-----------+
| user | host |
+------+-----------+
| root | 127.0.0.1 |
| root | localhost |
+------+-----------+
2 rows in set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> drop database test;
Query OK, 0 rows affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)
[root@mysql mysql-5.5.32]# /application/mysql//bin/mysqladmin -u root password 'cancer'
[root@mysql mysql-5.5.32]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@mysql mysql-5.5.32]# mysql -uroot -pcancer
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.5.32 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> exit
Bye
[root@mysql mysql-5.5.32]# chkconfig mysqld on
[root@mysql mysql-5.5.32]# chkconfig --list mysqld
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
[root@mysql mysql-5.5.32]# cat /etc/sysconfig/i18n
LANG="en_US.UTF-8"
SYSFONT="latarcyrheb-sun16"
版权声明:本文为博主原创文章,未经博主允许不得转载。