Chinaunix首页 | 论坛 | 博客
  • 博客访问: 5525488
  • 博文数量: 1005
  • 博客积分: 8199
  • 博客等级: 中将
  • 技术积分: 13067
  • 用 户 组: 普通用户
  • 注册时间: 2010-05-25 20:19
个人简介

脚踏实地、勇往直前!

文章分类

全部博文(1005)

文章存档

2020年(2)

2019年(93)

2018年(208)

2017年(81)

2016年(49)

2015年(50)

2014年(170)

2013年(52)

2012年(177)

2011年(93)

2010年(30)

分类: Mysql/postgreSQL

2016-12-10 09:12:09

版本:社区版 5.7.11
1.采用mysqld --initialize的方式安装数据库
[mysql@host02 bin]$ ./mysqld --initialize --user=mysql--basedir=/db/mysqlmha --datadir=/db/mysqlmha/data
2016-12-09T16:14:41.803286Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2016-12-09T16:14:41.803680Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2016-12-09T16:14:41.803988Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-12-09T16:14:41.804143Z 0 [ERROR] Can't find error-message file '/usr/local/mysql/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2016-12-09T16:14:41.805283Z 0 [Warning] One can only use the --user switch if running as root


2016-12-09T16:14:45.420977Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-12-09T16:14:45.544907Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-12-09T16:14:45.744649Z 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: 99aba79c-be2a-11e6-87c3-080027705c2d.
2016-12-09T16:14:45.767874Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-12-09T16:14:45.769002Z 1 [Note] A temporary password is generated for root@localhost: IjNes%oNs7eZ

2.使用初始化密码登陆mysql
./mysql -h localhost uroot -p -S /db/mysqlmha/data/mysql.sock
mysql> show databases;
ERROR 1820 (HY000): Unknown error 1820
mysql> set password=password('mysql');
Query OK, 0 rows affected, 1 warning (0.03 sec)


解决办法就是登陆进去后里面采用set password 的方式修改密码。

阅读(2541) | 评论(0) | 转发(0) |
0

上一篇:递归层次表使用

下一篇:mysql.servers(5.7.11)

给主人留下些什么吧!~~