With XAMPP, the password is empty, but cannot log on to the ROOT of mysql. It is strange to change the ROOT password.

When XAMPP is used, the password is empty, but cannot log on to the ROOT of mysql. It is strange to change the ROOT password. In this case, XAMPP shell can be used to log on to mysql directly... However, the default initial password of root is null, but mysql-u root-p cannot be used for logon. Only anonymous logon like mysql can be performed. (Note: You can use CMD in the bin directory of mysql and run XAMPP \ mysql \ bin instead of shell.) www.2cto.com found many methods on the Internet and finally succeeded. Run the command: mysql-u root mysql !!!!! Then, update user set password = password ('your password') where user = 'root. To log on to phpmyadmin, change phpmyadmin/config. inc. php to the same password as above. Attached MYSQL Chinese garbled problem: Find mysql \ bin \ directory to open my. ini is inserted under [mysqld]: character-set-server = utf8 is inserted under [mysql]: default-character-set = gbk