## mysql 数据库的安装方法 **yum方式安装mysql** >[success] yum方式安装mysql安装极其简单，只要执行 > > yum install mysql-server即可。 > > **yum方式安装mysql的应用场景** > >yum安装适合对数据库要求不太高的场合，例如并发不大，公司内部，企业内部的一些应用场景 ~~~ [root@greymouster]# yum install mysql-server [root@greymouster]# /etc/init.d/mysqld start ~~~ **采用cmake方式编译安装mysql** 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 ../ ~~~ 2. 依赖包 ~~~ yum install ncurses-devel -y ~~~ 3. 开始安装mysql ~~~ #创建用户和组 groupadd mysql useradd mysql -s /sbin/nologin -M -g mysql ~~~ 4. 解压编译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/tools/mysql-5.5.32 提示，编译时可配置的选项很多，具体可参考结尾附录或官方文档： make #[100%] Built target my_safe_process make install which cmake //查看cmake安装路径 /usr/local/bin/cmake ln -s /application/mysql-5.5.32/ /application/mysql ~~~ 如果上述操作未出现错误，则MySQL5.5.32软件cmake方式的安装就算成功了。 **初始化mysql** 1. 选择配置文件 ~~~ cp /application/mysql-5.5.32/support-files/my-small.cnf /etc/my.cnf ~~~ 2. 配置环境变量 ~~~ echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile tail -l /etc/profile source /etc/profile echo $PATH ~~~ 3. 初始化数据文件 ~~~ #建立mysql数据文件目录 mkdir -p /application/mysql/data #授权mysql用户访问mysql的安装目录 chown -R mysql.mysql /application/mysql/data/ #调整/tmp/权限，否则初始化会错误 chmod -R 1777 /tmp/ #安装mysql数据库文件，注意命令路径： /application/mysql/scripts/mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data/ --user=mysql #cp 启动脚本到/etc/init.d/ cp /home/tools/mysql-5.5.32/support-files/mysql.server /etc/init.d/mysqld #添加执行权限 chmod +x /etc/init.d/mysqld # 启动mysql /etc/init.d/mysqld start #查看端口 netstat -lntup|grep 3306 # 开机自启动 chkconfig mysqld on chkconfig --list mysqld ~~~ 4. 删除mysql的全部管理员，添加额外管理员 ~~~ mysql>delete from mysql.user where user=''; mysql>grant all privileges on *.* to system@'localhost' identified by 'root' with grant option; ~~~