Mysql reset root users to default

2019-08-20 03:08发布

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!

标签: mysql root
1条回答
我想做一个坏孩纸
2楼-- · 2019-08-20 03:21

This should do the trick:

grant all privileges on *.* to 'root'@'localhost' identified by "" with grant option;
查看更多
登录 后发表回答