redhat mysql源码安装_redhat 7 源码安装 mysql5.5.49

rpm -aq ncurses-devel libaio-devel cmakeyum install-y ncurses-devel libaio-devel cmake

创建Mysql用户

useradd mysql -s /sbin/nologin -M

解压mysql安装包

tar xf mysql-5.5.49.tar.gz

cd mysql-5.5.49

配置编译参数

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_DATADIR=/usr/local/mysql/data \-DMYSQL_UNIX_ADDR=/usr/local/mysql/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

make & make install

给mysql安装目录用户权限

chown -R mysql:mysql /usr/local/mysql/

初始化操作

cd /usr/local/mysql/scripts/

./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --user=mysql

复制启动文件

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

启动文件授权

chmod +x /etc/init.d/mysqld

配置文件说明

my-huge.cnf #巨大的

my-innodb-heavy-4G.cnf #沉重的

my-large.cnf #大的

my-medium.cnf #中间的

my-small.cnf #小的

如果是生产环境可以根据硬件选择更高级的配置文件，上述配置文件模板对硬件的要求从高到低依次是 my-medium.cnf ==》my-small.cnf ==》 my-large.cnf ==》 my-huge.cnf ==》 my-innodb-heavy-4G.cnf

复制配置文件

cp support-files/my-innodb-heavy-4G.cnf /etc/my.cnf

/etc/init.d/mysqld start

配置环境变量

echo 'export PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile

source /etc/profile

设置mysql密码

mysqladmin -u root password '密码'

设置防火墙

vim /etc/sysconfig/iptables

-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

mysql用户创建和授权

select  user,host,password from mysql.user ;

create user mysql@'192.168.100.110' identified by '密码'; #创建用户

grant all on *.* to mysql@'192.168.100.110'; #授权

flush privileges; #刷新操作