系统: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"