mariadb Setting the root password

Change root password
1. Login as root in the terminal, must
2. Enter mysqladmin-u root-p passwordRoot
The following root is the password to be set
3. Enter after carriage return password
Enter on the password, if not, enter directly

Create user
Create user
Mysql>INSERT INTO Mysql.user (Host,user,password) VALUES ("localhost", "admin", Password ("admin"));
Refresh System Permissions Table
Mysql>flush privileges;
This creates a user named Admin password: admin.

Create a database (under root privileges)
Create DATABASE MyDB;
The authorized Admin user has all the permissions of the MyDB database.
>grant all privileges in mydb.* to [e-mail protected] identified by ' admin ';
Refresh System Permissions Table
Mysql>flush privileges;

Delete the user.
@>mysql-u root-p
@> Password
Mysql>delete from user WHERE user= "admin" and host= "localhost";
Mysql>flush privileges;
Delete a user's database
Mysql>drop database mydb;

modifies the specified user password.
@>mysql-u root-p
@> Password
Mysql>update Mysql.user Set Password=password (' New password ') where user= "admin" and host= "localhost";

Mysql>flush privileges;

use the Web-based method to modify the root user's password:
# mysqladmin-uroot-p password ' newpassword '
Enter Password:
mysqladmin:connect to server at ' localhost ' failed
error: ' Access denied for user '' Root ' @ ' localhost '(using Password:yes) '
now I finally found the solution, as follows (please test method Three first, thank you!) ):
method One:
#/etc/init.d/mysql Stop
# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
# mysql-u Root MySQL
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit
#/etc/init.d/mysql Restart
# mysql-uroot-p
Enter Password: < Enter the newly set password newpassword>
mysql>
Method Two:
Use the user name and password provided directly in the [client] section of the/etc/mysql/debian.cnf file:
# mysql-udebian-sys-maint-p
Enter Password: < Enter the password for the [client] section >
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit
# mysql-uroot-p
Enter Password: < Enter the newly set password newpassword>
mysql>
Method Three:
This method I have not been tested, because my root user default password has been modified by me, the person has time to test, the results told me, thank you!
# mysql-uroot-p

Enter Password: < Enter the password provided in the [Client] section of the/etc/mysql/debian.cnf file >

Last note: Do not forget to turn off the firewall so that the external network cannot access the host's database port.

This article is from "Rain" blog, be sure to keep this source http://gushiren.blog.51cto.com/3392832/1687748

mariadb Setting the root password