美文网首页
MySQL-5.6.30-linux-glibc2.5-x86_

MySQL-5.6.30-linux-glibc2.5-x86_

作者: 逗比punk | 来源:发表于2017-05-18 14:40 被阅读1376次

    uname -a

    首先查看系统是32位还是64位操作系统,然后下载相应的mysql版本

    https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz

    创建mysql用户:

    [root@localhost mysql]# useradd mysql

    设置权限:
    [root@localhost mysql]# cd /usr/local  
    [root@localhost local]# chown -R mysql:mysql mysql/
    
    切换到mysql用户
    [root@localhost local]# su - mysql  
    [mysql@localhost ~]$ cd /usr/local/mysql/scripts/ 
    
    安装
     yum –y install perl perl-devel
     [mysql@localhost scripts]$ ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
    
    配置文件
    cd /usr/local/mysql/support-files
    cp my-default.cnf /etc/my.cnf
    cp mysql.server /etc/init.d/mysql
    vim /etc/init.d/mysql          #若mysql的安装目录是/usr/local/mysql,则可省略此步
    
    修改文件中的两个变更值
    basedir=/usr/local/mysql
    datadir=/usr/local/mysql/data
    
    配置环境变量
    vim /etc/profile                                
    export MYSQL_HOME=/usr/local/mysql
    export PATH=$MYSQL_HOME/bin:$PATH
    
    保存退出

    source /etc/profile

    启动
    [root@localhost mysql]# chkconfig --add mysql  
    [root@localhost mysql]# chkconfig mysql on  
    [root@localhost mysql]# service mysql start  
    Starting MySQL.. SUCCESS!
    
    设置root登录密码

    /usr/local/mysql/bin/mysqladmin -u root password 'new-password'

    登录
    [mysql@localhost ~]$ mysql -uroot -p  
    Enter password:  
    
    设置登录权限
    mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;  
    Query OK, 0 rows affected (0.06 sec)  
    mysql> FLUSH PRIVILEGES;  
    Query OK, 0 rows affected (0.04 sec)
    

    相关文章

      网友评论

          本文标题:MySQL-5.6.30-linux-glibc2.5-x86_

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