Quick mysql commands

# configure mysql 1st time
mysql -u root --skip-password
mysql>  ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxx';
# create databases
mysqladmin -u root create wp_somename

CREATE USER wp_somename
@'localhost'   IDENTIFIED BY 'password123';
grant all on wp_somename
.* to wp_somename
@'localhost';
flush privileges;

Leave a Reply

Your email address will not be published. Required fields are marked *