lamp

snippetSetting Mysql Access

To set the permissions for a mysql database

You need to be in a command line prompt and type
$mysql -u root -p password

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, 
DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
  ON database.*
  TO 'user'@'localhost' IDENTIFIED BY 'password';
  • Peter.Lord
  • Sat, 04/23/2011 - 17:04

Pages