ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
来源:互联网 发布:淘宝里实名认证在哪 编辑:程序博客网 时间:2024/06/10 20:46
在网上下载了一个免安装包的mysql,准备自己create database jhp_test,使用的时候出现报错,如下:
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'jhp_test'
经观察和百度,发现是用户权限和密码等错误造成的。并且show databases并没有发现mysql库。
解决方法:
1、在文件my安装包根目录下有文件my.ini(也有可能不存在my.ini而是my-default.ini,此时将文件名改为my.ini);
2、在文件my.ini中添加如下代码:
skip-external-lockingskip-name-resolveskip-grant-tables
3、关闭mysql服务器,重新启动mysql;
4、这时候show databases会发现有名为mysql的库存在,进入库mysql;
5、运行sql改变密码:UPDATE user SET Password=PASSWORD(‘newpassword’) where USER=’root’;
6、继续如下两步:
mysql> FLUSH PRIVILEGES;//记得要这句话,否则如果关闭先前的终端,又会出现原来的错误;
mysql> \q;//退出
7、关闭服务器并重启,此时就可以创建自己的库了;
8、对mysql进行环境变量配置,这样就可以直接在cmd命令里使用“mysql -uroot -pnewpassword”进行登录了;
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'
- 第七届山东省省赛总结
- 金融科技 Startups (Top 50)(转)
- 【C++笔记】可变参数函数
- 首次使用Android Studio应该做的事
- Android configChanges
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- FastJson.API详解
- 清华组合数学第一章经典复习题,用六种算法计算839647521后999种排列
- 关于ifndef的认识
- 去除[WARNING] Using platform encoding (GBK actually) to copy filtered resources, i.e. build is platfor
- C++实现图片的base64编码
- Hadoop 2.6.0集群搭建(伪分布式+分布式)
- 使用Mybatis向MySQL批量插入数据
- hdu 1106 排序