Unanswered: set mysql root password to password=""
i wanted to to change my sql root password from linux cli. so i enter these command in command line:
mysql>update user set password=PASSWORD("") where User='root';
as you see i forgot to set the new password in update statement, so i think root password became null. & now i cant login into mysql! i tried space, "", nothing, but neither of them worked out.
i know one solution is reset mysql password, but it seems weird that i cant log in.
anyone have any idea?
Are you running mysql under Windows or UNIX? You will need to perform some system admin type operations to reset this password. If you can let me know the environment in which your database is running and whether you have permissions to start and stop the database?