• MySQL二进制包安装


    mysql的安装有多种方法,这里就介绍一下二进制包安装。

    [root@node1 ~]# tar xvf mysql-5.7.27-linux-glibc2.12-x86_64.tar

    [root@node1 ~]# ll

    -rw-r--r--  1 root root  676577280 Sep  3 14:32 mysql-5.7.27-linux-glibc2.12-x86_64.tar
    -rw-r--r--  1 7161 31415 644916075 Jun 11 00:09 mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz
    -rw-r--r--  1 7161 31415  31651176 Jun 11 00:06 mysql-test-5.7.27-linux-glibc2.12-x86_64.tar.gz

    [root@node1 ~]# tar zxvf mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz -C /usr/local/src/

    [root@node1 ~]# ln -s /usr/local/src/mysql-5.7.27-linux-glibc2.12-x86_64/bin/* /usr/bin/

    [root@node1 ~]# useradd mysql

    [root@node1 ~]# mkdir /opt/mysql/

    [root@node1 mysql]# vim /opt/mysql/my.cnf

    [mysqld]
    datadir=/opt/mysql/data
    basedir=/opt/mysql
    socket=/opt/mysql/mysql.sock
    symbolic-links=0

     [root@node1 ~]# chown -R mysql.mysql /opt/mysql/

    初始化数据库:

    # mysqld --defaults-file=/opt/mysql/my.cnf --initialize --user=mysql
    2019-10-20T15:14:23.391761Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2019-10-20T15:14:23.391972Z 0 [ERROR] Can't find error-message file '/opt/mysql/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
    2019-10-20T15:14:23.647941Z 0 [Warning] InnoDB: New log files created, LSN=45790
    2019-10-20T15:14:23.705942Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
    2019-10-20T15:14:23.761481Z 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: 4c79a27e-f34c-11e9-a440-000c29641ef8.
    2019-10-20T15:14:23.762286Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
    2019-10-20T15:14:23.763231Z 1 [Note] A temporary password is generated for root@localhost: SbGi_Ld2M.0M

    启动数据库:

    # mysqld_safe --defaults-file=/opt/mysql/my.cnf --user=mysql &
    [1] 10083
    [root@node1 mysql]# Logging to '/opt/mysql/data/node1.err'.
    2019-10-20T15:26:05.609531Z mysqld_safe Starting mysqld daemon with databases from /opt/mysql/data

    [root@node1 mysql]# ps -ef|grep mysqld
    root      10083   4162  0 23:26 pts/2    00:00:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/opt/mysql/my.cnf --user=mysql
    mysql     10211  10083  3 23:26 pts/2    00:00:00 /usr/local/src/mysql-5.7.27-linux-glibc2.12-x86_64/bin/mysqld --defaults-file=/opt/mysql/my.cnf --basedir=/opt/mysql --datadir=/opt/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=node1.err --pid-file=node1.pid --socket=/opt/mysql/mysql.sock
    root      10248   4162  0 23:26 pts/2    00:00:00 grep --color=auto mysqld
    [root@node1 mysql]# netstat -tlunp|grep mysqld
    tcp6       0      0 :::3306                 :::*                    LISTEN      10211/mysqld      

    [root@node1 ~]# mysql -uroot -p -S /opt/mysql/mysql.sock

    Enter password:

    Welcome to the MySQL monitor.  Commands end with ; or g.

    Your MySQL connection id is 2 Server version: 5.7.27

    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

    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> show databases;
    ERROR 1820 (HY000): Unknown error 1820
    mysql> show databases;
    ERROR 1820 (HY000): Unknown error 1820
    mysql> alter user 'root'@'localhost' identified by 'Wpw303@123';
    Query OK, 0 rows affected (0.00 sec)

    关闭数据库:

    # mysqladmin -uroot -pWpw303@123 -S /opt/mysql/mysql.sock shutdown

  • 相关阅读:
    Delphi 的字符及字符串 Char、AnsiChar、WideChar、PChar、PAnsiChar、PWideChar
    C# DllImport的用法
    delphi 枚举类型与字符串的转换
    MSSQL2005不能用IP访问
    Delphi制作DLL
    Delphi接口的底层实现
    MacBook下每次SourceTree每次拉取代码都要输入密码解决办法
    因子分析AF
    蒲公英组网
    485通信
  • 原文地址:https://www.cnblogs.com/winter1519/p/11711542.html
Copyright © 2020-2023  润新知