Create a password for the root user of mysql

Create a password for mysql root mysql> set password for 'root' @ 'localhost' = PASSWORD ('newpass '); # create a password for root mysql> mysqladmin-uroot password ab12 # Same as mysql> mysqladmin-u username-p old password new password; # modify root password www.2cto.com mysql> create database name; # create a database mysql> show databases; # view the database mysql> enter grant all privileges on DB. * to test @ localhost
Identified by "1234"; # Add a user test password to 1234 so that the user can only