Mysql 将 root 用户重置为默认值 [英] Mysql reset root users to default

问题描述

我将我的 mysql root 用户更改为有密码.现在我正在做一个项目，其中 shell 脚本为我们的一个团队动态创建数据库表.root 用户需要在不使用密码的情况下拥有完全访问权限.我无法在任何地方找到一个简单的答案来将 root 用户恢复到没有密码的默认状态?这都是本地的，安全不是问题.提前致谢！

I changed my mysql root user to have a password. Now I am working on a project where a shell script creates database tables dynamically for a team of us. The root user needs to have full access without using a password. I can't find an easy answer to this anywhere to revert the root user back to it's default state with no password? This is all local, security is not a concern. Thanks in advance!

推荐答案

这应该可以解决问题:

grant all privileges on *.* to 'root'@'localhost' identified by "" with grant option;

这篇关于Mysql 将 root 用户重置为默认值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！