美文网首页
centos6.5安装mysql5.7

centos6.5安装mysql5.7

作者: joy_蓝蜘蛛 | 来源:发表于2019-06-20 14:19 被阅读0次

    安装:
    https://blog.csdn.net/qq_42339484/article/details/81914221

    忘记密码:
    https://www.cnblogs.com/lixiuming521125/p/7066911.html

    远程访问设置:
    https://blog.csdn.net/wang__wyj/article/details/81303424

    1. 检测系统是否已安装 mysql

      [root@localhost ~]# yum list installed | grep mysql
    

    2. 删除系统已安装的 mysql 及其依赖

      [root@localhost ~]# yum -y remove mysql-libs.i686
    

    3. 给CentOS添加rpm源

        wget http://repo.mysql.com//mysql-community-release-el6-5.noarch.rpm
    

    4.安装yum源

    [root@localhost ~]# yum install mysql-community-release-el6-5.noarch.rpm
        [root@localhost ~]# yum repolist all | grep mysql
        [root@localhost ~]# yum repolist all | grep mysql
        [root@localhost ~]# yum-config-manager --disable mysql55-community
        [root@localhost ~]# yum-config-manager --disable mysql56-community
        [root@localhost ~]# yum-config-manager --enable mysql57-community-dmr
    

    5. 安装 MySQL 服务端

     ```
    yum install mysql-community-server
    Dependency Installed:
    mysql-community-client.x86_64 0:5.7.22-1.el6 
    mysql-community-common.x86_64 0:5.7.22-1.el6 
    mysql-community-libs.x86_64 0:5.7.22-1.el6
    
    Complete!
    看到以上结束语句,表示安装成功
    

    6. 启动 mysql 服务

     service mysqld start
    

    7查看启动是否成功:

     service mysqld status
        
    

    mysqld (pid 10698) 正在运行...

    7. 修改 root 初始密码

    我这里用的是安全模式下进入设置密码
    
       service mysqld stop
       mysqld_safe –skip-grant-tables &
    

    重新开一个终端输入一下命令,然后直接敲enterj键:
    [root@localhost ~]#mysql -uroot -p
    进入之后,敲use mysql,用mysql数据库;
    修改root用户密码

        mysql> update user set authentication_string=password(123456) where user='root'; 
    

    注:mysql5.7的密码字段是authentication_string,不是password
    刷新权限并退出

        mysql> >flush privileges;
        mysql> >quit
        ```
    ##重启mysql,用密码123456即可登录mysql
    

    [root@localhost ~]# service mysqld restart
    [root@localhost ~]# mysql -u root -p

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    mysql>

    出现以上内容,登录成功
    
    ##8.  设置mysql开机启动
    

    [root@localhost ~]# chkconfig mysqld on
    [root@localhost ~]# chkconfig mysqld status

    相关文章

      网友评论

          本文标题:centos6.5安装mysql5.7

          本文链接:https://www.haomeiwen.com/subject/pmndqctx.html