MYSQL
* Create a database
CREATE DATABASE dbname;
* Add a new user
- Connect to the database:
mysql -u root -p mysql
- Add the user:
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
(*.* can be database.table)
(omit WITH GRANT OPTION, if it should not grant)
Other privileges:
RELOAD,PROCESS,USAGE
- Flush privileges:
FLUSH PRIVILEGES;
* Change the password of a user:
- SQL:
UPDATE mysql.user SET Password=PASSWORD('newpwd')
WHERE User='username';
FLUSH PRIVILEGES;
- Shell:
mysqladmin -u username -h hostname password 'new-password'