Why can't I log in to phpMyAdmin?

phpMyAdmin is a MySQL database management tool based on PHP and based on Web-Base architecture on the website host, allowing administrators to use the Web interface to manage the MySQL database. This web interface can be a better way to input complex SQL syntax in a simple way, especially when it comes to importing and exporting large amounts of data. One of the greater advantages is that phpMyAdmin is executed on the web server like other PHP programs, but you can use the HTML pages generated by these programs anywhere, that is, to remotely manage the MySQL database, and easily create, modify, and delete Databases and data tables. You can also use phpMyAdmin to create the commonly used php syntax to facilitate the correctness of the SQL syntax required when writing web pages.

This article mainly introduces in detail the solution to PhpMyAdmin cannot log in

TodayinstallationphpStudy , the default password of mysql is empty, and the following error is reported when logging in to phpMyAdmin:

① Open the mysql console of phpStudy and prompt to enter the password , the starting password is empty, just press Enter

②Enter [use mysql], the console prompts [Database changed]

③Enter update user set password=PASSWORD('Password to be modified') where user='root';

Console prompts【Query OK,XXXXXXXXX】

④Finally enter【 flush privileges;], submit

and then you can visit happily.

The above is the detailed content of Why can't I log in to phpMyAdmin?. For more information, please follow other related articles on the PHP Chinese website!