Linux下安装mysql5.7及相关配置记录

    xiaoxiao2021-03-25  70

    linux 安装mysql 5.7 1.下载mysql

    wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar 解压 tar -xf mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar

    解压完成后由这么几个文件:

    mysql-community-client-5.7.12-1.el6.x86_64.rpm mysql-community-common-5.7.12-1.el6.x86_64.rpm mysql-community-devel-5.7.12-1.el6.x86_64.rpm mysql-community-embedded-5.7.12-1.el6.x86_64.rpm mysql-community-embedded-devel-5.7.12-1.el6.x86_64.rpm mysql-community-libs-5.7.12-1.el6.x86_64.rpm mysql-community-libs-compat-5.7.12-1.el6.x86_64.rpm mysql-community-server-5.7.12-1.el6.x86_64.rpm mysql-community-test-5.7.12-1.el6.x86_64.rpm

    依次执行安装:

    rpm -ivh mysql-community-common-5.7.12-1.el6.x86_64.rpm rpm -ivh mysql-community-server-5.7.12-1.el6.x86_64.rpm ......

    启动mysql:

    /etc/init.d/mysqld start

    查看mysql目录:

    ps aux|grep mysql

    出现如下:

    root 5688 0.0 0.0 113224 3080 pts/0 S 09:35 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql mysql 5886 0.0 2.3 1932112 181040 pts/0 Sl 09:35 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock

    进入mysql安装目录:

    cd /var/lib/mysql

    查看mysql默认密码:

    grep "password" /var/log/mysqld.log

    查找如下语句:A temporary password is generated for root@localhost: fQk2wWh&YRcT 最末尾就是默认初始密码

    登录mysql:

    /var/lib/mysql/mysql -u root -p

    重设密码:

    SET PASSWORD = PASSWORD('123456');

    如果有强制密码检查插件,则过简单的密码会提示:Your password does not satisfy the current policy requirements 则需要设置一定强度的强密码,或者启用全局配置,修改密码插件验证规则:

    set global validate_password_policy=0; //设置安全级别 set global validate_password_length=6; //默认密码长度为8,可以设置为其它值,最小4位

    设置新密码:

    SET PASSWORD = PASSWORD('123456');

    赋所有权限:

    grant all privileges on *.* to 'root' identified by '123456' with grant option; flush privileges;

    ok,可以访问了!

    转载请注明原文地址: https://ju.6miu.com/read-37026.html

    最新回复(0)