MySQL
MYSQL - CREATE DB & USER
17/09/2011
Crea un db e un utente con tutti i privilegi sul db (MYSQL)
Create a DB & relative user privileges on MYQL DB
MYSQL QUERY:
CREATE USER 'youruser'@'localhost' IDENTIFIED BY 'youruserpassw';
GRANT USAGE ON * . * TO 'youruser'@'localhost' IDENTIFIED BY 'youruserpassw' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
CREATE DATABASE `yourdb` ;
GRANT ALL PRIVILEGES ON `yourdb` . * TO 'youruser'@'localhost';
FLUSH PRIVILEGES ;