mkdir -p /usr/local/env/mysql/data
cd /usr/local/env/mysql/
mysql.tgz 再QT的 /root 下面 或者 https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
tar -zxvf /mysql.tgz -C /usr/local/env/mysql/
groupadd mysql
useradd -r -g mysql mysql
yum install libaio numactl.x86_64 -y
chown -R mysql:mysql /usr/local/env/mysql/
echo 'export PATH=$PATH:/usr/local/env/mysql/mysql/bin' >> ~/.bash_profile
source ~/.bash_profile
vi /etc/my.cnf
./mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/env/mysql/mysql --datadir=/usr/local/env/mysql/mysql/data
记住上边命令结果最后的密码
cp /usr/local/env/mysql/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
service mysqld start
#########下面为/etc/my.cnf的内容
[mysql]
设置mysql客户端默认字符集
default-character-set=utf8
[mysqld]
skip-name-resolve
设置3306端口
port=3306
socket=/tmp/mysql.sock
设置mysql的安装目录
basedir=/usr/local/env/mysql/mysql
设置mysql数据库的数据的存放目录
datadir=/usr/local/env/mysql/mysql/data
允许最大连接数
max_connections=200
服务端使用的字符集默认为8比特编码的latin1字符雿
character-set-server=utf8
创建新表时将使用的默认存储引擿
default-storage-engine=INNODB
lower_case_table_name=1
max_allowed_packet=16M
网友评论