数据库使用&学习记录
权限
GRANT CREATE TABLE TO { PUBLIC | GROUP group | username }
GRANT ALTER TABLE
忘记密码
一个窗口
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