MySQL mariadb password settings

Original: https://my.oschina.net/uyunsky/blog/109532

First, the initial installation

Method 1:
Under the/usr/local/mysql/bin/:
./mysqladmin-u root password ' new_password '
This method is set for general installation.
If MySQL login error: mysqladmin:connect to server at ' localhost ' failed
Unable to change password


with service mysqld stop


Mysqld_safe--skip-grant-tables &


Enter Mysql-uroot-p return Enter


>use MySQL;
> Update user Set Password=password ("Newpass") where user= "root";
Change Password to Newpassord
> Flush Privileges; Update permissions
> Quit quitting



Service mysqld Restart
Mysql-uroot-p New Password entry


Method 2:
In MySQL state:
Mysql>update user SET Password=password (' New_password ') WHERE user= ' root ';
Mysql>flush privileges;


Method 3:
Mysql>set PASSWORD for Root=password (' New_password ');

MySQL mariadb password settings