常见MySQL操作

$ mysql -u root -p Here are some sample SQL statements for creating the user and database:
CREATE USER 'zodbuser'@'localhost' IDENTIFIED BY 'mypassword';CREATE DATABASE zodb;
GRANT ALL ON zodb.* TO 'zodbuser'@'localhost';
FLUSH PRIVILEGES;


mysql> SET PASSWORD FOR 'xtcs'@'Localhost' = PASSWORD('thispassword');
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql>