Mysql没有初始密码(ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO))
来源:互联网 发布:python 冒号的作用 编辑:程序博客网 时间:2024/05/17 00:12
安装好了mysql后,链接,出现
->mysql -u root -p
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
说明密码不正确可以登录mysql 修改密码
没有密码怎样登录???
以下教程》》》》》》
关闭myspl数据库
killall -TERM mysqld
启动myspl数据库
mysqld_safe --skip-grant-tables
这样就可以不需要密码就可以进入myspl数据库了
(注:另开一个端口)进入myspl数据库
mysql
执行以下命令:(ps:分别键入)
use mysql;
update user set password=PASSWORD('密码自己改') where User='root';
flush privileges;
quit
这样密码就修改好了, 关闭 重新用新密码登录即可
0 0
- Mysql没有初始密码(ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO))
- mysql-->ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql Error 1045(28000) Access Denied for user 'root'@'localhost' (Using password:NO)
- [linux][mysql]ERROR 1045 (28000) : Access denied for user 'root'@'localhost' (using password:No)错误
- mysql解决ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- MySQL: Error 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: NO)
- centOS下mysql-ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql问题:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql提示ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql问题ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- 新安装mysql ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
- 解决MySQL 报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Linux mysql 5.6: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Linux mysql 5.6: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql GRANT with ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO
- MySQL:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Ubuntu下 MySQL的“ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)”
- centOS下mysql-ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- hihocoder 1122 : 二分图二•二分图最大匹配之匈牙利算法
- VMware扩展磁盘大小
- 关于支付宝分享集成
- 今天在做一个SSH整合测验时发现了一个异常(According to TLD or attribute directive in tag file)
- 在Unity世界里遇到的第一个错误!
- Mysql没有初始密码(ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO))
- spark安装、源码编译
- 点滴记录ExtJS练习——ComboBox的四种扩展
- 可视化学习之百度echarts工具(2)
- Hibernate无法创建表的原因分析
- NYOJ 325 zb的生日 && NYOJ 456 邮票分你一半
- 改写的两个mysql存储过程,用于判断主键外键
- HDU1598 find the most comfortable road【并查集】
- 【指导】Install Appium on Ubuntu in command line