创建mysql用户和用户组groupaddmysqluseradd-gmysqlmysqlpasswdmysql卸载系统自带的mariadb#查询rpm-qa|grepmariadb返回mariadb-libs-5.5.60-1.el7_5.x86_64#卸载rpm-emariadb-libs-5.5.60-1.el7_5.x86_64返回错误：依赖项失败：（已安装）postfix-2:2.10.1-7.el7.x86_64libmysqlclient.so.18需要libmysqlclient.so.18()(64bit)(libmysqlclient_18)(64bit)isneededby(installed)postfix-2:2.10.1-7.el7.x86_64#Forciblyuninstallrpm-e--nodepsmariadb-libs-5.5.60-1.el7_5.x86_64下载mysqlrpm下载Formysqlrpm，选择RedHatEnterpriseLinux/OracleLinuxRedHatEnterpriseLinux7/OracleLinux7(x86,64-bit)RPMBundle获取下载地址https://cdn.mysql.com//Downlo...wget"https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.13-1.el7.x86_64.rpm-bundle.tar"tar-xvfmysql-8.0.13-1.el7.x86_64.rpm-bundle.tar安装依赖yuminstall-ylibaio.x86_64libaio-devel.x86_64yuminstall-yopenssl-devel.x86_64openssl.x86_64yuminstall-yperl.x86_64perl-devel.x86_64yuminstall-yperl-JSON.noarchyuminstall-yautoconf必须安装，注意顺序，有依赖.rpmrpm-ivhmysql-community-client-8.0.13-1.el7.x86_64.rpmrpm-ivhmysql-community-server-8.0.13-1.el7.x86_64.rpm安装不是必须的，注意顺序，有依赖rpm-ivhmysql-community-libs-compat-8.0.13-1.el7.x86_64.rpmrpm-ivhmysql-community-embedded-compat-8.0.13-1.el7.x86_64.rpmrpm-ivhmysql-community-devel-8.0.13-1.el7.x86_64.rpmrpm-ivhmysql-community-test-8.0.13-1.el7.x86_64.rpm初始化数据库mysqld--initialize--console修改目录权限这一步必须在初始化数据库之后！！！安装后默认是mysql用户和用户组的权限。如果没有，更改chown-Rmysql:mysql/var/lib/mysql/以root用户启动systemctlstartmysqld。如果启动失败，查看日志tail-n100/var/log/mysqld.log查看初始化时的密码启动成功后，可以查看随机生成的初始化密码cat/var/log/mysqld.log|greppassword登录mysql修改mysql用户密码mysql-uroot-p#Changepasswordalteruser'root'@'localhost'identifiedby'yourpassword';#remotesettingusemysql;updateusersethost='%'whereuser='root';#授权用户名的权限，授予任意主机访问数据的权限grantallprivilegeesON*.*to'root'@'%'withgrantoption;刷新权限；添加mysql用户，创建数据库，授权创建用户'flame'@'%'，由'password'标识；创建数据库火焰；将flame.*的所有权限授予'flame'@'%';flushprivileges;centos7防火墙开启端口#开启3306端口firewall-cmd--zone=public--add-port=3306/tcp--permanent#reloadfirewall-cmd--reload#查看状态firewall-cmd--list-allAliyunportsecuritygroupsettingsecuritygroupdescriptionAdd3306portAddnew[incomingdirection]rule生产环境mysql_secure_installation会做以下操作设置root用户密码删除匿名账号取消root用户远程登录删除测试库及访问权限刷新授权表使修改生效相关管理命令#startmysqlsystemctlstartmysqld.service#endsystemctlstopmysqld.service#restartsystemctlrestartmysqld.service#bootselfsystemctlenablemysqld.service
