soopajot
4/15/2013 - 2:10 PM

Mysql

Mysql

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
mysqladmin -u root password "newpass"
CREATE DATABASE dbname;
GRANT ALL PRIVILEGES ON dbname.* TO 'newuser'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;