Granting Privileges to users

After creating user. Privileges are granter to user to access specific database or to access all databases in mysql
GRANT ALL will give all privileges to user
To Grant All privileges to user following query is used

To provide all privileges on specific database following query is used

To provide all privileges on specific tabel following query is used

Read More

  1. Setting innodb_lock_wait_timeout
  2. Set time zone in mysql
  3. Show engine innodb status
  4. Finding all column name of table