看到mysql5.7.9发布了,下了windows的zip,解压后真的没有Data目录。手动建data目录,启动报错
2015-10-22T06:17:52.071875Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2015-10-22T06:17:52.073875Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2015-10-22T06:17:52.074875Z 0 [Note] Salting uuid generator variables, current_pid: 5788, server_start_time: 1445494669, bytes_sent: 0,
2015-10-22T06:17:52.082876Z 0 [Note] InnoDB: not started
2015-10-22T06:17:52.087876Z 0 [Note] Generated uuid: 'a00cc8aa-7884-11e5-ba54-f0def1613030', server_start_time: 1445500457, bytes_sent: 171092576
2015-10-22T06:17:52.089876Z 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: a00cc8aa-7884-11e5-ba54-f0def1613030.
2015-10-22T06:17:52.094876Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2015-10-22T06:17:52.095876Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2015-10-22T06:17:52.096876Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2015-10-22T06:17:52.097876Z 0 [Note] IPv6 is available.
2015-10-22T06:17:52.098877Z 0 [Note] - '::' resolves to '::';
2015-10-22T06:17:52.098877Z 0 [Note] Server socket created on IP: '::'.
2015-10-22T06:17:52.099877Z 0 [Warning] Failed to open optimizer cost constant tables
2015-10-22T06:17:52.102877Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2015-10-22T06:17:52.103877Z 0 [ERROR] Aborting
mysql根本没有启动成功,所以运行mysql_upgrade 并没有什么用。
是在windows下,配置文件是my-default.ini,没有改动过都是默认值 。 启动mysqld --console,会在data目录下创建系统默认的数据库文件。但是就会提示上述错误信息,并且abort。
创建的数据库文件一共只有5个,并没看到相关表的文件:auto.cnf,ib_buffer_pool,ib_logfile0,ib_logfile1,ibdata1
大神们,怎么弄?
我对mysql不熟,麻烦大家了。问题解决了。谢谢@Tuesday的帮助:
先将my.default.ini改名为my.ini放到bin目录 命令行执行: mysqld --initialize --user=mysql --console 先执行以上命令, 生成库. 注意有个临时密码, 要记下来. 然后启动服务. 然后再命令行: mysql -uroot -p 输入密码
先将my. default.ini改名为my.ini放到bin目录
命令行执行:mysqld--initialize--user=mysql--console
先执行以上命令,生成库.注意有个临时密码,要记下来.
然后启动服务.
然后再命令行:
mysql-uroot-p
输入密码,
再输入:
setpassword=password('root')
改密码成功,然后就可以phpmyadmin操作了.
http://www.fenanr.com/fxampps/112900.html
教程....
mysql根本没有启动成功,所以运行mysql_upgrade并没有什么用不要下那个91M的下载那个300多M,msi后缀的。版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。