Add a user :
create user 'user'@'%' identified by 'pass';
Grant privileges :
grant all privileges on *.* to 'user'@'localhost' with grant option;
flush privileges
flush privileges
Set root password for the first time :
mysqladmin -u root password NEWPASSWORD
0 comments:
Post a Comment