涉及到的错误代码:windows启动mysql服务1067、mysql error 1045
电脑安装过mysql,想再次安装的时候总会出些问题。一般我们会想到的就是删除安装目录中的数据、删除c盘application data等目录下的数据,以及删除注册表中关于mysql的数据。一番删除之后,你会发现再次安装的时候,会提示你:
所以说删注册表还是要慎重呀。
如果这个时候,你能一步一步安装成功,那当然最好。但是现实可能并没有那么好。下面看一下我们接着会遇见的问题。
每当安装快成功的时候,检测环境时:到启动服务,就一直出现未响应...
我们手动去启动,也会提示:无法启动 错误1067。
default-storage-engine=myisam
也许这个时候,你的mysql就可以使用了。但是更可能报:error 1045.
这里也可以在my.ini文件中[mysqld]后面增加:#登录时跳过权限检查
c:\users\administrator>mysql welcome to the mysql monitor. commands end with ; or \g. your mysql connection id is 30 server version: 5.5.62 mysql community server (gpl) copyright (c) 2000, 2018, 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; +--------------------+ | database | +--------------------+ | information_schema | | test | +--------------------+ 2 rows in set (0.00 sec) c:\users\administrator>mysql -uroot welcome to the mysql monitor. commands end with ; or \g. your mysql connection id is 31 server version: 5.5.62 mysql community server (gpl) copyright (c) 2000, 2018, 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; +--------------------+ | database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | +--------------------+ 4 rows in set (0.00 sec)
mysql> use mysql database changed mysql> update user set password=password('mysqladmin') where user='root'; query ok, 3 rows affected (0.00 sec) rows matched: 3 changed: 3 warnings: 0 # 刷新mysql权限相关的表(应该可以省略) mysql> flush privileges; query ok, 0 rows affected (0.03 sec) mysql> select user,password from user; +------+-------------------------------------------+ | user | password | +------+-------------------------------------------+ | root | *a5c34f28328751b780896836c8a565c5c130175e | | root | *a5c34f28328751b780896836c8a565c5c130175e | | root | *a5c34f28328751b780896836c8a565c5c130175e | | | | +------+-------------------------------------------+ 4 rows in set (0.00 sec) mysql> exit bye
终于安装成功!!!
如对本文有疑问, 点击进行留言回复!!
MySQL-关系代数-并、交、差、等值连接、自然连接、左连接。。。
【MySQL牛客】10.获取所有非manager的员工emp_no
网友评论