首次改密碼：
- /etc/init.d/mysql stop
- mysqld_safe --skip-grant-tables &
- use mysql;
- update user set password=PASSWORD(”YOUR_PASSWORD”) where user=’root’;
- flush privileges;
- quit
- /etc/init.d/mysql stop
- /etc/init.d/mysql start
創(chuàng)建用戶
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
GRANT ALL PRIVILEGES ON database_name . * TO 'newuser'@'localhost';
其中database_name是數(shù)據(jù)庫的名稱震放。
請(qǐng)注意，它database_name.*包括數(shù)據(jù)庫中的所有表。您也可以使用來定位單個(gè)表database_name.table_name屋谭。
flush privileges
SHOW GRANTS FOR 'newuser'@'localhost';
