IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    MySQL Cluster(ndb):初始化数据库的登录口令修改

    Adamhuan发表于 2017-02-21 09:56:16
    love 0

    这一部分没有太多可以说的内容,直接列代码:

    [root@mysql-manager ~]# cat /etc/my.cnf | grep --color log-error
    log-error=/var/lib/mysql/log_data/mysql-error.log
    [root@mysql-manager ~]# 
    [root@mysql-manager ~]# cat /var/lib/mysql/log_data/mysql-error.log  | grep "A temporary password"
    2017-02-21T08:23:22.195412Z 1 [Note] A temporary password is generated for root@localhost: sd:Fy-w 
    mysql> show databases;
    ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
    mysql> 
    mysql> set password = password('Abcd1@34');
    Query OK, 0 rows affected, 1 warning (0.01 sec)
    
    mysql> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | mysql              |
    | ndbinfo            |
    | performance_schema |
    | sys                |
    +--------------------+
    5 rows in set (0.00 sec)
    
    mysql> exit
    Bye
    [root@mysql-manager ~]# mysql -u root -p'sd:Fy-w exit
    Bye
    [root@mysql-manager ~]#

    ——————————————
    Done。



沪ICP备19023445号-2号
友情链接