数据库使用&学习记录

权限

GRANT CREATE TABLE TO { PUBLIC | GROUP group | username }

GRANT ALTER TABLE

Grant的用法

忘记密码

一个窗口

mysqld --shared-memory --skip-grant-tables

另一个窗口

mysql -u root -p
//press enter
FLUSH PRIVILEGES
ALTER USER 'root'@'localhost' IDENTIFIED BY '你要设置的密码'
FLUSH PRIVILEGES

注释

#DELETE FROM SeatInformation  


/*DELETE FROM SeatInformation */
-- DELETE FROM SeatInformation