wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm rpm -ivh mysql57-community-release-el7-9.noarch.rpm yum install mysql-server mysqld --initialize # 初始化 chown mysql:mysql -R /var/lib/mysql # 设置权限 systemctl start mysqld # 启动 service mysqld restart # 重启 systemctl status mysqld # 状态 mysqladmin --version # 验证 cat /etc/my.cnf # 配置 cat /var/log/mysqld.log # 日志 grep 'temporary password' /var/log/mysqld.log # 查找临时密码 mysql -uroot -p'kYOob33wi2&u' # 连接(临时密码) alter user user() identified by "123"; # 设置密码 # 允许远程访问 use mysql; select host,user from user; UPDATE user SET Host='%' WHERE User='root' AND Host='localhost' LIMIT 1; flush privileges; #help http://www.runoob.com/mysql/mysql-install.html # RPM 包安装方式 # 按照以下顺序进行安装,因为它们之间存在依赖关系 # common --> libs --> clients --> server # 下载 mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar 或者分别下载