CODEWITHSUNDEEP
mysql
Bertaud
Bertaud

Reputation: 2918

enter in mysql without password should not work

On windows, I have two root users.
I deleted one and kept the local one (root@localhost).
I set its password by :

set password for 'root'@'localhost'= password('new_password');

I exit and I do :

mysql -u root

and I am in mysql.
I was waiting for the password request.

Upvotes: 0

Views: 110

Answers (1)

Ray
Ray

Reputation: 41428

You have to restart mysql or run flush privilidges before the new password will take effect.

Also try setting root password for 127.0.0.1 as well as localhost.

Upvotes: 1

Related Questions