ubuntu系统中MysqlERROR1045(28000):Accessdeniedforuserroot@localhost问题的解决方法
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了ubuntu系统中MysqlERROR1045(28000):Accessdeniedforuserroot@localhost问题的解决方法,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4288字,纯文字阅读大概需要7分钟。
内容图文
第一种方式:
skip-grant-tables:非常有用的mysql启动参数
介绍一个非常有用的mysql启动参数—— --skip-grant-tables。顾名思义,就是在启动
mysql时不启动grant-tables,授权表。有什么用呢?当然是忘记管理员密码后有用。
以命令行参数启动mysql:# /usr/bin/mysqld_safe --skip-grant-tables &
3、修改管理员密码:
use mysql;
update user set password=password('yournewpasswordhere') where user='root'; flush privileges; exit;
4、杀死mysql,重启mysql.
然后就可以直接登录
方法2:
查看mysql安装的路径
然后我们更改root用户的密码,
查看默认密码先
然后直接登录
然后再更改root默认用户名和密码
GRANT ALL PRIVILEGES on *.* to 'root'@'localhost' identified by '密码'; flush privileges;
mysql>update mysql.user set password=password('新密码') where User="test" and Host="localhost";
mysql>flush privileges;
mysql>delete from user where User='root' and Host='localhost';
mysql>flush privileges;
mysql>grant select,delete,update,create,drop on *.* to test@"%" identified by "1234";
mysql> UPDATE user SET Host='127.0.0.1' WHERE User='root' AND Host='localhost';
mysql> flush privileges;
<img alt="" src="https://www.jb51.net/article/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAoEAAAHPCAIAAACji5duAAAgAElEQVR4nO2debRtR13njzTL1mhDWMjQsdPwlDBkQ4JIoF0YFBszh4Q8NgkiSNMooAuF7kUHUORIdzt0OywbE2xpFFuRZutSkaHRdgAcXiJD4OWIICIYTcCIefe+4b77hntP/3HO2aeG36921T7DPnXO57P2H/fWqV1Vu6p2fXeNv97b3va2l7/85UMAAABYLj00GAAAoBPQYAAAgG5AgwEAALph+Rpclb1eWS0xwgZWIz2DfrECqQAAgGWCBq9GetBgAIDNw9fgquyZxAhDkoythuZNWY30oMEAAJuHrMG1GlSlIcOWOo8dHcW2RFvyPwl/0C9G7kV/EPY/0qcaw7/1S5SASSGNn3cauf3wSvol/0bwRVkW4g9WOqfOZR8NBgDYOBo0eKQTY7UaDAa+o3BLfavofyRehgDWAen+RXUa9Iv6FydBIoN+0RM8jcXU/NCYBBpIv+DffBbz20VLp+YfAAA2hEYNljXQdmwezjV82J4V8TSVUJZO587msVxNpoVvDj8gNf1T//5zjf7T0qn5BwCATSFJg62h3AgNFv0HNFgL3/hFGen2h6k9tEQGNDgi/bV/R+JtrRXSqfoHAIBNIX4s2hxSjekHa/61WwPhW2mbCFfM8LObnpR+cFz6mzVYiRcNBgDYeOLXZLn61zSgrPnXpkoV/4OqGlhh1tFqg9Qao15tw7C6Pbaspb9Js0d93/BguuofAAA2hKa9SaZ2TH8p+pUtaMZN0ztk/1XZK/r9MjZ8ezzYkbLgjwLS4LI+Fq2mXxu7rm8YrfsW10Wb6VT9AwDAJpDPWZW9HhcX11IvAFgwaDAXF5dyAcCCQYO5uLiUCwAWzPI12JwbTVnXPGu70DZe2AQi5+M3pBKhwQDLort+cOreonm1C6nxwiYQpcEbU3XQYIBlgQa3YAYbFTOtf57FNkZVLmndtXMmSSaaFVUuq2HeYwmgwQDLwtNgY+vQxLJC0R8IwjV1Um0qGHYNylK/f/xfQ2vttwvtbDlIGqz592MI2aiQCWiwGXyDjYpZ4zU1OC3fdBsbEfFamZ1qk0Nwl6RyWnXE/AykP95mhr25zIohKnzrtBfh/UrJT7H6zFSO3vZ0NBhgWUgaPN2XW/QHo0ZjoB9hGTyoMnBMhaeFDQ2S2y60teUgxyv4188AmUs/2D+lU9yvPKd4pxqcmm+mjY3mL6XQEWppNjlk92ryLTc9QmX8ZKH8FNOfbjNDPTpdCl9Jj/Z+xUXq7F6fUzmiwQCdIfeDB/Z5Uf4Bx8Y/gWOgbNNKTVpYe5SV2G0XNIn0+tdOS+XGq/kPjFkna6HQgXKDr8MMHP81Fw1OzbfUAVhLde3z1ERPofT47pN0VWVRlsVYe4v+QM/POI1vPxathK+lR32/oiI1krnIckSDAZZFvAa7ZzvLg7bO0JcXrH2L2vgISiy2C368jbYcpMZR8r+Y/qh1FKY4rqA912zxOvPBCfnWRoOd7w0vVu8n+XmVelX0B1VZ9AejR6rKepIgZZzGqQZz12AtPXPT4Pr/BZQjGgywLFI0uG631GbDGN5beD9YibdxzVW4H9yYvkl0s2qw2m9z77UzcU4aLISvPe8s/WATq08cEC4tDUa9Kvv9YtwZ7lejP5P7wYvW4MX0gyPybR7liAYDLIskDR6/7IV1FLJmU8FpN+c9H9zaloMcrzYYqspJ47yomLbm+WD9uYLxCol1G+/xVGBqvoXbbj/e0NivNdU+zgYlPcF6NR22LwpzQVbK/Lr5TeBNiMqkaHBgPjhNg6fhjDu94XxrU47MBwN0RqIG+y+4Pb4or84cjRsGNbh5tY+rwXq84R8lIdP8q4OnxoBfkxgH5h3N4K0pVDVwNV7xgyE5fOnHeWmwmfgImxx6Ot25ZGEEv2d/fYS1p9frRdrMSNJgJT3JGjxNZjHanzD9hJtXOaLBAJ2Ruj84dWTSuC+65yhDuxBm9hzOK16YI84nMO8awLJI0+CkQVgLNHixRPXj1ihemCPehzXvGsCyiNXgyXhY2/YWDQbIBd41gGWRod0kAFgovGsAywINBgAb3jWAZZGhBnNxcS3nAoAFo2mweKRDp3TeHnFxbdoFsNEsQwfRYC4uLuUC2GjQ4NWF/FkPKEcA0OhCg60DduwzeNzD4O3DAzfDfUD+rIU75Yg77rhr7qH2Ye7QD24H+bMeUI4AoMFY9OpC/qwHlCMAaKDBqwv5sx5QjgCg0aUGAwAAwGJBgwEAALoBDQYAAOgGVYMdi6LgQP6sB2tejtiWBJiBJbQPaHBLyJ/1YM3LEQ0GmIEsNNg2AD7TO+/ZEl9hWuYPC3FXjKRyXMaO/fmCBgPMQO4abJ42YjQE1iEk40jcw0pWXoznoMFSPni/1LeOwql/yUQDVp525TjoF9MSsOpuQz1X3CWpnKZMfI8C9WHqv+yjwQDtyVqDrWZq0C8mvgKd3Y3qB6sPa+SVmYmjlr5ustHg+dCyHM3/BoPJ/Wad18pXdq/K8Y1V2Zv+NTk2T3uPxPowDWHsKZdXCmDlyEaDhR6s1XQMjaZn0C+0XtxGabCWD3bGTb9pcsqcjGhVjuZnkuYpVL6++6Scq7Ioy2KsvUV/oL9HcRrPWDTADGSjwcI77zYRvjd/xDknmZnPfLCQD/43zbSDlEvmZETLb02rJOwT3s2f5HouuY86wlVZ9AejKlKVRX8QeI+U+uBoNhoMMAM5a7D6/e7ea3jKSWbmuibLzAc345RwYD60LUczANsGi+DJqeeS+6Bf9Mp+vxh3hvvV6M/kfjAaDDA/ctZgbR5rUFWqMGvys4rEl431kPW8n54PyiAmGrwQZtZg9/tpUv2V8lXLfdTPnuhuUZgLslLWVZjfBEaYAJBO1ho8lNdz2uN2bhTGgN+Ki3FK2STng/QjGrwQZtZgs9IW/apfjApZK1+93N25ZGHmxhm8Dq1tHHumHwwwA1lo8IZC/qwHlCMAaKDBqwv5sx5QjgCg0aUGAwAAwEJBgwEAALoBDQYAAOgGNBgAAKAbNA3GvE8Y8mc9oBwBQGMZ7QMa3A7yZz2gHAFAAw1eXcif9YByBACNLjTYOsXHPsvHNSZgH7K3Ge4D8mct3ClH3HHHXXMPtQ9zh35wO8if9YByBAANxqJXF/JnPaAcAUADDV5dyJ/1gHIEA
内容总结
以上是互联网集市为您收集整理的ubuntu系统中MysqlERROR1045(28000):Accessdeniedforuserroot@localhost问题的解决方法全部内容,希望文章能够帮你解决ubuntu系统中MysqlERROR1045(28000):Accessdeniedforuserroot@localhost问题的解决方法所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。