ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
来源:互联网 发布:维启网络 编辑:程序博客网 时间:2024/06/10 07:40
前两天装了mysql免安装版,但是没有设账户和密码,今天新建数据库时总不成功,上网查了一下,是因为没有设密码的原因。于是去设密码,设密码要使用 “mysql” 这个数据库,但是会报错。ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
后来发现解决办法,把my.ini中加入skip-grant-tables。
[mysqld]skip-grant-tables
# Remove leading # and set to the amount of RAM for the most important data就像这样,然后在去重启mysql,我是在服务中重启的。
接着打开mysql
<pre name="code" class="html"><pre name="code" class="html">Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.6.25 MySQL Community Server (GPL)Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
这时,便可以 use mysql了。
mysql> use mysqlDatabase changedmysql>然后修改密码
mysql> update user set password=password('12345') where user='root';Query OK, 3 rows affected (0.05 sec)Rows matched: 3 Changed: 3 Warnings: 0退出,将my.ini改过来,就可以了
0 0
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database
- ERROR 1044 (42000): Access denied for user ”@’localhost’ to database
- mysql root 进入出现ERROR 1044(42000):Access denied for user ''@'localhost' to database 'mysql'
- ubuntu mysql root 进入出现ERROR 1044(42000):Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- error 1044 (42000):access denied for user ''@'localhost' to database 'mysql'错误解决方案
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql' .
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- 功能(黑盒)测试
- 如何不进行逻辑判断来比较两个数的大小
- 【我们都爱Paul Hegarty】斯坦福IOS8公开课个人笔记41 Animation动画
- 主机虚拟机和开发板ping不通的问题
- jQuery攻略
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- 欢迎使用CSDN-markdown编辑器
- PID代码及注释
- 单链表的操作
- 设计模式之责任链模式
- 定位多线程内存越界问题实践总结
- Scala的react、loop代码编程
- poj2590steps数列递推
- OPENCV下SIFT算法使用方法笔记