安装mysql

#查看是否已经安装mysql 如果有则删除

rpm -qa|grep -i mysql

rpm -ev mysql-libs-*

rpm -ev mysql-server-5.1.73-3.el6_5.i686

rpm -ev mysql-devel-5.1.73-3.el6_5.i686

1，二进制安装

#解压

?

1 2 3 4 5 6 7 8 9 10 11

tar -zxvf mysql-5.5.33-linux2.6-i686.tar.gz   mv mysql-5.5.33-linux2.6-i686 /application/mysql   cd /application/mysql/   #创建用户和用户组   groupadd mysql   useradd mysql -g mysql -M -s /sbin/nologin

　　

2，cmake安装

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

groupadd mysql   useradd mysql -g mysql -M -s /sbin/nologin<br>1.3 安装相关包 1.3.1 cmake软件 cd /home/oldboy/tools/ tar xf cmake-2.8.8.tar.gz cd cmake-2.8.8 ./configure #CMake has bootstrapped.  Now run gmake. gmake gmake install cd ../   1.3.2 依赖包 yum install ncurses-devel -y   1.4 开始安装mysql 1.4.1 创建用户和组 groupadd mysql useradd mysql -s /sbin/nologin -M -g mysql   1.4.2 解压编译MySQL tar zxf mysql-5.5.32.tar.gz cd mysql-5.5.32 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 \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -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   #-- Build files have been written to: /home/oldboy/tools/mysql-5.5.32 提示，编译时可配置的选项很多，具体可参考结尾附录或官方文档： make #[100%] Built target my_safe_process make install ln -s /application/mysql-5.5.32/ /application/mysql 如果上述操作未出现错误，则MySQL5.5.32软件cmake方式的安装就算成功了。<br>

添加mysql到环境变量

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14

vim /etc/profile    在最后面添加   PATH="/application/mysql/bin/:$PATH"    source  /etc/profile   或者   echo 'export PATH=/application/mysql/bin/:$PATH' >> /etc/profile tail -l /etc/profile source /etc/profile echo $PATH

给data目录授权

?

1 2 3

chown  -R mysql.mysql  /application/mysql/data   chmod -R 1777 /tmp/

　　

初始化mysql

 ./scripts/mysql_install_db  --user=mysql --basedir=/application/mysql/ --datadir=/application/mysql/data/

 #没有错误的话进行下一步

一般会出现两个ok表示成功

?

1 2 3 4

Installing MySQL system tables... OK Filling help tables... OK

　　

 

进入mysql解压目录 启动文件

?

1 2 3 4 5 6 7 8 9

\cp support-files/mysql.server  /etc/init.d/mysqld   chmod +x /etc/init.d/mysqld    vim /etc/init.d/mysqld   basedir=/application/mysql   datadir=/application/mysql/data

　　

 

配置文件：回到安装目录/application/ mysql-5.5.32

\cp mysql-5.5.32/support-files/my-small.cnf /etc/my.cnf

 

启动：

/etc/init.d/mysqld start

/etc/init.d/mysqld stop

 

设置密码：

/application/mysql/bin/mysqladmin  -u root password '123456'

 

 

优化：