Ubuntu under the various methods to modify the root password, phpmyadmin empty password can not log on the solution

phpMyAdmin is not allowed to use a blank password by default, so if you do not set the password at the time of installation, it is a headache when landing phpmyadmin.

Method 1 is to modify the phpMyAdmin configuration file, which is not recommended here.

Method 2:

phpMyAdmin login account and password is actually MySQL's account and password, then we change the MySQL password can be

Open Terminal

Method 1: Use the Set password command

Mysql-u Root

mysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass ');

Method 2: Use Mysqladmin

mysqladmin-u root Password "Newpass"

If Root has already set a password, use the following method

mysqladmin-u root password Oldpass "Newpass"

Method 3: Edit the user table directly with update

Mysql-u Root

mysql> use MySQL;

mysql> UPDATE user SET Password = Password (' newpass ') WHERE user = ' root ';

mysql> FLUSH privileges;

This can be done when the root password is lost

Mysqld_safe--skip-grant-tables&

Mysql-u Root MySQL

mysql> UPDATE user SET Password=password ("New password") WHERE user= ' root ';

mysql> FLUSH privileges;

Ubuntu under the various methods to modify the root password, phpmyadmin empty password can not log on the solution