How to set password for 'root' users on mysql
- Start mysqld with below option
- c:> mysqld --defaults-file=c:\mysqlc\my.ini --console --skip-grant-tables
- start mysql client
- use mysql
- update user set password=PASSWORD('newpassword') where user='root"
- FLUSH PRIVILEGES
restart mysqld without --skip-grant-tables option.. thats all
No comments:
Post a Comment