Practice makes perfect Practice makes perfect

Commands

• MySQL commands

  Computer/linux 2010. 2. 17. 23:53

  MySQL ROOT # access MySQL root account to mysql itself [] mysql -u root -p mysql # Show GRANT mysql> show grants; mysql> show grants for 'user'; mysql> show grants for 'user'@'localhost'; myslq> show grants for user@localhost; # Set priv_type (GRANT) types of priv ALTER Modify tables with ALTER TABLE CREATE Make new database, table, or index DELETE Remove rows from tables DROP Remove databases o..

  Read More