mysql-5.5.32源码安装

来源：互联网发布：c语言fgets函数编辑：程序博客网时间：2024/06/10 13:53

系统：Red Hat Enterprise Linux Server release 6.3(32位)

mysql-5.5.32

1.安装依赖包
yum -y install cmake
yum -y install bison
yum -y install ncurses-devel

2.创建mysql用户和组
groupadd mysql
useradd mysql -s /sbin/nologin -M -g mysql

3.创建目录
mkdir -p /app/mysql-5.5.32/data
mkdir -p /app/mysql-5.5.32/tmp

4.解压编译安装
cmake . -DCMAKE_INSTALL_PREFIX=/app/mysql-5.5.32 \ #安装路径
-DMYSQL_DATADIR=/app/mysql-5.5.32/data \ #数据文件路径
-DMYSQL_UNIX_ADDR=/app/mysql-5.5.32/tmp/mysql.sock \ #sock路径
-DMYSQL_USER=mysql \
-DDEFAULT_CHARSET=utf8 \ #默认的字符集
-DDEFAULT_COLLATION=utf8_general_ci \ #默认的校对规则
-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \ #额外支持的字符集
-DENABLED_LOCAL_INFILE=ON \ #打开LOCAL_INFILE功能
#开启支持多种引擎
-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 \
-DWITHREADLINE=1 \
-DWITHEMBEDDED_SERVER=1 \
-DWITH_DEBUG=0

make && make install

5.复制参数文件
cp /app/mysql-5.5.32/support-files/my-small.cnf /etc/my.cnf

6.配置环境变量
echo 'export PATH=/app/mysql-5.5.32/bin:$PATH' >> /etc/profile
tail -1 /etc/profile
source /etc/profile
echo $PATH

7.赋予目录用户组
chown -R mysql.mysql /app/mysql-5.5.32

8.执行数据库初始化脚本
cd /app/mysql-5.5.32/scripts
./mysql_install_db --basedir=/app/mysql-5.5.32 --datadir=/app/mysql-5.5.32/data --user=mysql

9.加mysql启动到系统启动中
cp /app/mysql-5.5.32/support-files/mysql.server /etc/init.d/mysqld

chmod +x /etc/init.d/mysqld

10.启动
/etc/init.d/mysqld start
检查端口
netstat -lntup | grep 3306

11.登陆mysql

select user,host from mysql.user;

删除user为空的用户，伤处主机为::1(此为IPV6地址)
delete from mysql.user where user='';
delete from mysql.user where host='::1';

select user,host from mysql.user;

额外授权管理员
delete from mysql.user;

grant all privileges on *.* to system@'localhost' identified by 'aaa111' with grant option;

为mysql用户增加密码

/app/mysql/bin/mysqladmin -u root password 'aaa111'

将mysql服务加入开机启动
chkconfig mysqld on
chkconfig --list mysqld

mysqld 0:关闭 1:关闭 2:启用 3:启用 4:启用 5:启用 6:关闭

附:

linux字符集设置文件
/etc/sysconfig/i18n
LANG="zh_CN.UTF-8"

0 0