|
0
|
1 |
MYSQL
|
|
|
2 |
* Create a database
|
|
|
3 |
CREATE DATABASE dbname;
|
|
|
4 |
* Add a new user
|
|
|
5 |
- Connect to the database:
|
|
|
6 |
mysql -u root -p mysql
|
|
|
7 |
- Add the user:
|
|
|
8 |
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
|
|
|
9 |
(*.* can be database.table)
|
|
|
10 |
(omit WITH GRANT OPTION, if it should not grant)
|
|
|
11 |
Other privileges:
|
|
|
12 |
RELOAD,PROCESS,USAGE
|
|
|
13 |
- Flush privileges:
|
|
|
14 |
FLUSH PRIVILEGES;
|
|
|
15 |
|
|
|
16 |
* Change the password of a user:
|
|
|
17 |
- SQL:
|
|
|
18 |
UPDATE mysql.user SET Password=PASSWORD('newpwd')
|
|
|
19 |
WHERE User='username';
|
|
|
20 |
FLUSH PRIVILEGES;
|
|
|
21 |
- Shell:
|
|
|
22 |
mysqladmin -u username -h hostname password 'new-password'
|