LNMP Environment modification phpMyAdmin default root username

After the general LNMP installation package is installed, the phpMyAdmin Default user name is root. If you want to change the default root username is also very simple, modify the MySQL root user name can be. It's clear from here. Know phpMyAdmin is just a management tool that can easily manage MySQL data. The following is a procedure.

Login MySQL

Mysql-u root-p

Enter Password: Enter the MySQL password

Choose MySQL Database

Use MySQL;

Change the default root user name to Www.111cn.net

Update user set user= "www.111cn.net" where user= "root";

Refresh Permissions

Flush privileges;

Modify password

mysql> use MySQL;
Database changed
mysql> Update user set user= ' Yeer ', Password=password (' 123456 ');
Query OK, 1 row affected (0.02 sec)
Rows matched:1 changed:1 warnings:0

Exit MySQL

Exit