Today, I helped my brother install a new lnmp environment. After installation, I found that the root password of mysql is not the password that my brother wants. If it is necessary to change the root password before building the station. Log on to phpmyadmin, select mysql database, select the SQL tab, enter the following code to the command box, and click the execution button in the lower right corner. The Code is as follows: updateusersetpas
Today, I helped my brother install a new lnmp environment. After installation, I found that the root password of mysql is not the password that my brother wants. If it is necessary to change the root password before building the station. Log on to phpmyadmin, select mysql database, select the SQL tab, enter the following code to the command box, and click the execute button in the lower right corner. The Code is as follows: update user set pas
Today, I helped my brother install a new lnmp environment. After installation, I found that the root password of mysql is not the password that my brother wants. If it is necessary to change the root password before building the station.
Log on to phpmyadmin, select mysql database, select the SQL tab, enter the following code to the command box, and click the execute button in the lower right corner. The Code is as follows:
Update user set password = password ('new password') where User = 'root'
Modify/home/wwwroot/phpmyadmin/libraries/config. default. php, change $ cfg ['servers'] [$ I] ['Password'] = ''to $ cfg ['servers'] [$ I] ['Password'] =' new Password'
Finally, restart lnmp.
Original article address: Change the mysql Root Password under Lnmp. Thank you for sharing it.