MySQL安装随笔

参考官网 数据库安装文档 [ https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html ] 数据初始化文档 [ https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html ] mysql-5.7.33-linux-glibc2.12-x86_64.tar下载 [ https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.33-linux-glibc2.12-x86_64.tar ]

yum search libaio  # 查询libaio

yum install libaio  # 安装libaio

groupadd mysql  # 创建专用组

useradd -r -g mysql -s /bin/false mysql  # 创建专用用户

mv mysql-5.7.33-linux-glibc2.12-x86_64.tar /usr/local/  # 移动tar包位置

cd /usr/local

tar xvf mysql-5.7.33-linux-glibc2.12-x86_64.tar  # 解压包

tar zxvf mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz  # 解压包

ln -s /usr/local/mysql-5.7.33-linux-glibc2.12-x86_64 mysql  # 添加软连接

cd mysql

mkdir data  # 创建数据存放目录

chown mysql:mysql data  # 更改目录归属用户和组

mkdir etc

cd etc

touch my.cnf  # 创建配置文件

cat >my.cnf <<EOF [mysqld] basedir=/usr/local/mysql datadir=/usr/local/mysql/data EOF

cd /usr/local/mysql

bin/mysqld --defaults-file=/usr/local/mysql/etc/my.cnf --initialize --user=mysql  # 初始化数据（记住密码如：9N)#fMSkGyZs）

初始化数据报错 bin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory yum install -y numactl  # 如果报错，就安装numactl库

启动bin/mysqld --defaults-file=/usr/local/mysql/etc/my.cnf --user=mysql &

编辑 vi /etc/profile 在最后一行添加 PATH=$PATH:/usr/local/mysql/bin

bin/mysql -u root -p;

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

vi ~/.bashrc添加alias startmysql='mysqld --defaults-file=/usr/local/mysql/etc/my.cnf --user=mysql &'