centeros7安装mysql

1.下载包https://downloads.mysql.com/archives/community/2.解压到/opt/mysql5.7.40//处理//查看并卸载系统自带的 Mariadb[rootlocalhost/]# rpm-qa|grep mariadb mariadb-libs-5.5.68-1.el7.x86_64[rootlocalhost/]# rpm-e--nodeps mariadb-libs-5.5.68-1.el7.x86_64[rootlocalhost/]# rpm-qa|grep mariadb[rootlocalhost/]# rpm-qa|grep mysql//查询所有 MySQL 对应的文件夹全部删除[rootlocalhost/]# whereis mysql[rootlocalhost/]# find/-name mysql//创建 mysql 用户组和用户[rootlocalhost/]# groupadd mysql[rootlocalhost/]# useradd-r-g mysql mysql3.更改文件夹权限chown-Rmysql:mysql/opt/mysql5.7.4/chmod-R755/opt/mysql5.7.40/4.安装依赖yum search libaio yum install libaio yum-y install numactl yum install libnuma yum install ld-linux.so.2yum install libaio.so.1yum install libnuma.so.1yum install libstdc.so.6yum install libtinfo.so.5yum clean all yum makecache5.进入 /opt/mysql5.7.40/bin/ 目录编译安装并初始化 mysql./mysqld--initialize--usermysql--datadir/opt/mysql5.7.40/data--basedir/opt/mysql5.7.40//务必记住数据库管理员临时密码6.添加配置vim /etc/my.cnf[mysqld]datadir/opt/mysql5.7.40/data port3306sql_modeNO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLESsymbolic-links0max_connections400innodb_file_per_table1lower_case_table_names17.chmod -R 755 /etc/my.cnf8.vim /opt/mysql5.7.40/support-files/mysql.server9.启动[rootlocalhost~]#/opt/mysql5.7.40/support-files/mysql.server startStartingMySQL.Loggingto/opt/mysql5.7.40/data/localhost.localdomain.err.SUCCESS!10.软连接ln-s/opt/mysql5.7.40/support-files/mysql.server/etc/init.d/mysql ln-s/opt/mysql5.7.40/bin/mysql/usr/bin/mysql service mysql restart11.连接mysql-u root-p12.修改密码mysqlset passwordforrootlocalhostpassword(manager123);QueryOK,0rows affected,1warning(0.00sec)mysql13.开启mysql的远程访问权限mysqluse mysql;Readingtable informationforcompletion of table and column namesYoucan turn offthisfeaturetogeta quicker startupwith-ADatabasechanged mysqlupdate user setuser.Host%whereuser.Userroot;QueryOK,1row affected(0.00sec)Rowsmatched:1Changed:1Warnings:0mysqlflush privileges;QueryOK,0rows affected(0.00sec)14.设置开机自启cp/opt/mysql5.7.40/support-files/mysql.server/etc/init.d/mysqld chmodx/etc/init.d/mysqld chkconfig--add mysqld15.开放3306端口firewall-cmd--zonepublic--add-port3306/tcp--permanent firewall-cmd--reload