安装时出错_Centos 7 安装Mysql5.7.31

1. mysql 下载(方式一)

https://downloads.mysql.com/archives/community/

2. linux环境确认

- 是否已安装mysql   

# 若能查出信息则表示已安装,根据实际情况判断是否需要卸载重装(下图表示未安装)rpm -qa | grep mysql whereis mysqlfind / -name mysqlrm rf *路径*

- 检查mysql用户组和用户是否存在，如果没有，则创建

cat /etc/group | grep mysqlcat /etc/passwd |grep mysqlgroupadd mysqluseradd -r -g mysql mysql

3. mysql 下载(方式二)

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.31-linux-glibc2.12-x86_64.tar.gztar xzvf mysql-5.7.31-linux-glibc2.12-x86_64.tar.gzmv mysql-5.7.31-linux-glibc2.12-x86_64 /usr/local/cd /usr/local/mv mysql-5.7.31-linux-glibc2.12-x86_64 mysqlmkdir /usr/local/mysql/data

4. 安装

# 更改mysql目录下所有的目录及文件夹所属的用户组和用户，以及权限chown -R mysql:mysql /usr/local/mysqlchmod -R 755 /usr/local/mysql#编译安装并初始化mysql,务必记住初始化输出日志末尾的密码(数据库管理员临时密码)./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql(若上一条命令报错,则执行5.1步骤)#编译完成后,最后的日志为临时密码(4.1)#编辑配置文件my.cnf，添加配置如下[mysqld]datadir=/usr/local/mysql/dataport=3306sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0max_connections=600innodb_file_per_table=1lower_case_table_names=1character_set_server=utf8socket=/usr/local/mysql/mysql.sock[mysqld_safe]#log-error=/usr/local/mysql/mariadb/mariadb.log#pid-file=/usr/local/mysql/mariadb/mariadb.pid# # include all files from the config directory# !includedir /etc/my.cnf.d# 启动测试/usr/local/mysql/support-files/mysql.server start# 添加软连接ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql ln -s /usr/local/mysql/bin/mysql /usr/bin/mysqlln -s /usr/local/mysql/mysql.sock /tmp/mysql.sockservice mysql restart

# 测试登录mysql -u root -p # 若输入临时密码时,报了错,则执行5.2步骤# 修改密码set password for root@localhost = password('GTMCmail8800');

# 开放远程连接use mysql;update user set user.Host='%' where user.User='root';flush privileges;

# 设置开机自动启动1、将服务文件拷贝到init.d下，并重命名为mysqlcp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld2、赋予可执行权限chmod +x /etc/init.d/mysqld3、添加服务chkconfig --add mysqld4、显示服务列表chkconfig --list

数据库编译密码(4.1)

至此就安装完成啦

5. 出错对应

数据编译出错(5.1)

5.1 编译出错

# 查询是否确认编译的动态链接库,若是没有则执行安装rpm -qa|grep libaio# 安装缺少的动态链接库yum install  libaio-devel.x86_64yum -y install numactl

数据库启动错误(5.2)

5.2 登录报错

解决：建立软链接：ln -s /usr/local/mysql/mysql.sock /tmp/mysql.sock原理:  https://blog.csdn.net/hjf161105/article/details/78850658