• Centos7 安装MySql 5.7


    首先创建一个目录
    mkdir /usr/local/mysql
     
    首先将文件拷贝到Linux
    rz 点击回车后选择文件上传
     
    上传完成后通过:ll
    查看文件是否上传成功
     
    如果上传成功:
    通过“tar -zxvf”解压缩:
    tar -zxvf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
     
    由于文件夹名字太长,我们可以先给文件夹改个名字,将文件夹的名字更改成mysqlinstall
    mv mysql-5.7.25-linux-glibc2.12-x86_64 mysqlinstall
     
    创建一个mysql数据目录:
    mkdir /usr/mysql
     
    创建mysql用户组
    groupadd mysql
     
    创建mysql用户
    1,useradd mysql -g mysql
    2,useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql --创建mysql用户 禁止shell登陆
     
    将/usr/local/mysql的所有者及所属组更改为mysql
    chown -R mysql.mysql /usr/local/mysql
     
    mysql数据目录的所有者及所属组更改为mysql
    chown -R mysql.mysql /usr/mysql
     
    配置参数
    进入到目录:/usr/local/mysql/mysqlinstall
     
    执行命令:
    ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/mysqlinstall --datadir=/usr/mysql
     
    执行结果如下并得到初始密码:
    2019-04-19T13:13:13.957178Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2019-04-19T13:13:14.295738Z 0 [Warning] InnoDB: New log files created, LSN=45790
    2019-04-19T13:13:14.343463Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
    2019-04-19T13:13:14.403308Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: e3979a73-62a4-11e9-acc6-000c29ba09bd.
    2019-04-19T13:13:14.406459Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
    2019-04-19T13:13:14.407877Z 1 [Note] A temporary password is generated for root@localhost: !Dg5F;J9wh2d
     
    将配置文件拷贝到数据目录下
    进入到:/usr/local/mysql/
    cp ./mysqlinstall/support-files/mysql.server /etc/init.d/mysql
     
    回车后会打印:cp: overwrite ‘/etc/init.d/mysql’?
    输入:y 后拷贝完成
     
    编辑配置文件:
    输入命令:vim /etc/my.cnf
    打开后按”d”键将文件删除干净,将一下代码拷贝气中:
    [mysqld]
     
    erver-id = 1
     
    port = 3306
     
    basedir =/usr/local/mysql/mysqlinstall
     
    datadir = /usr/mysql
     
    transaction_isolation = READ-COMMITTED
     
    character-set-server = utf8mb4
     
    collation-server = utf8mb4_general_ci
     
    init_connect=‘SET NAMES utf8mb4‘
     
    lower_case_table_names = 1
     
    max_connections = 400
    根据自己的路径修改:basedir和datadir
     
    完成后,保存并且退出
     
    输入命令启动mysql
    /etc/init.d/mysql start
     
    启动成功后连接数据库:
    mysql -hlocalhost -uroot -p
    如果显示:-bash: mysql: command not found
    则执行以下语句
    ln -s /usr/local/mysql/mysqlinstall/bin/mysql /usr/bin
     
    在执行过程中,如果显示已建立:ln: failed to create symbolic link ‘/usr/bin/mysql’: File exists
    则执行以下语句:
    ln -b /usr/local/mysql/mysqlinstall/bin/mysql /usr/bin
     
    完成后,在连接数据库:
     
    mysql -hlocalhost -uroot -p
    输入密码登陆成功
     
    首次登陆需要先更改默认密码,
    set password=password('密码');
  • 相关阅读:
    VB程序逆向反汇编常见的函数(修改版)
    [反汇编练习] 160个CrackMe之009
    [反汇编练习] 160个CrackMe之008
    [反汇编练习] 160个CrackMe之007
    [反汇编练习] 160个CrackMe之006
    Delphi反汇编内部字符串处理函数/过程不完全列表
    [反汇编练习] 160个CrackMe之005
    [反汇编练习] 160个CrackMe之004
    新建Django配置
    mysql 常用命令大全
  • 原文地址:https://www.cnblogs.com/gskstudy/p/10791645.html
Copyright © 2020-2023  润新知