ERROR 1045 (28000): Access denied for user
发表于:2025-01-21 作者:千家信息网编辑
千家信息网最后更新 2025年01月21日,mysqladmin本地登陆报错 ERROR 1045 (28000): Access denied for user 'root'@'localhost' 的解决方案如下:mysqladmin -u
千家信息网最后更新 2025年01月21日ERROR 1045 (28000): Access denied for usermysqladmin本地登陆报错 ERROR 1045 (28000): Access denied for user 'root'@'localhost' 的解决方案如下:
mysqladmin -u root password xxxx
#1.停止mysql数据库
/etc/init.d/mysql stop
#2.执行如下命令
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
#3.使用root登录mysql数据库
mysql -u root mysql
#4.更新root密码
mysql> UPDATE user SET Password=PASSWORD('mysql') where USER='root';
mysql>grant all on *.* to root@'%' identified by "mysql";
#5.刷新权限
mysql> FLUSH PRIVILEGES;
#6.退出mysql
mysql> quit
#7.重启mysql
/etc/init.d/mysql restart
#8.使用root用户重新登录mysql
mysql -uroot -p
Enter password: <输入新设的密码newpassword>
操作日志如下:
[root@mysqldb1 ~]# /etc/init.d/mysql stop
Shutting down MySQL..[ OK ]
[root@mysqldb1 ~]#
[root@mysqldb1 ~]# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
[1] 7384
[root@mysqldb1 ~]# 160606 15:23:44 mysqld_safe Logging to '/var/lib/mysql/mysqldb1.err'.
160606 15:23:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
[root@mysqldb1 ~]# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.31 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, 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> UPDATE user SET Password=PASSWORD('xxxxx') where USER='root';
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0
mysql> grant all on *.* to root@'%' identified by "xxxxxx";
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
[root@mysqldb1 ~]# /etc/init.d/mysql restart
Shutting down MySQL..160606 15:25:46 mysqld_safe mysqld from pid file /var/lib/mysql/mysqldb1.pid ended
[ OK ]
Starting MySQL.[ OK ]
[1]+ Done mysqld_safe --user=mysql --skip-grant-tables --skip-networking
[root@mysqldb1 ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.31
Copyright (c) 2000, 2016, 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>
mysql>
mysqladmin -u root password xxxx
#1.停止mysql数据库
/etc/init.d/mysql stop
#2.执行如下命令
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
#3.使用root登录mysql数据库
mysql -u root mysql
#4.更新root密码
mysql> UPDATE user SET Password=PASSWORD('mysql') where USER='root';
mysql>grant all on *.* to root@'%' identified by "mysql";
#5.刷新权限
mysql> FLUSH PRIVILEGES;
#6.退出mysql
mysql> quit
#7.重启mysql
/etc/init.d/mysql restart
#8.使用root用户重新登录mysql
mysql -uroot -p
Enter password: <输入新设的密码newpassword>
操作日志如下:
[root@mysqldb1 ~]# /etc/init.d/mysql stop
Shutting down MySQL..[ OK ]
[root@mysqldb1 ~]#
[root@mysqldb1 ~]# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
[1] 7384
[root@mysqldb1 ~]# 160606 15:23:44 mysqld_safe Logging to '/var/lib/mysql/mysqldb1.err'.
160606 15:23:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
[root@mysqldb1 ~]# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.31 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, 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> UPDATE user SET Password=PASSWORD('xxxxx') where USER='root';
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0
mysql> grant all on *.* to root@'%' identified by "xxxxxx";
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
[root@mysqldb1 ~]# /etc/init.d/mysql restart
Shutting down MySQL..160606 15:25:46 mysqld_safe mysqld from pid file /var/lib/mysql/mysqldb1.pid ended
[ OK ]
Starting MySQL.[ OK ]
[1]+ Done mysqld_safe --user=mysql --skip-grant-tables --skip-networking
[root@mysqldb1 ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.31
Copyright (c) 2000, 2016, 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>
mysql>
数据
数据库
登录
命令
密码
方案
日志
权限
用户
解决方案
更新
登陆
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
自己搭建服务器能翻墙吗
嵌入式软件开发的简历编写模板
迷你世界全部小游戏服务器
xctf网络安全
机房 服务器
数据库技术面向对象模型
深圳市德丰软件开发有限公司
软件开发成本估算核心
什么是公安y数据库
商丘网络技术哪个好
数据库登录密码为啥可以有几个
网络安全法那日实施
网络安全面临哪些问题
从数据库中调取序列
CA是常用的外文数据库吗
移动dns服务器地址无法获取
智能角球软件开发
计算机软件开发 算什么专业
对于网络安全的认识短句
福建财务软件开发有哪些
贵州省公安厅网络安全保卫总队
软件开发服务计量单位填什么
测试服务器的命令是
教师网络技术培训方案
数据库怎么给表加主键
常州人员服务管理软件开发
ibm服务器管理口默认密码
在家怎么访问学校的文件服务器
邯郸电商软件开发怎么样
京东聊天软件开发2020