MySQL

-- Привелегии
GRANT ALL PRIVILEGES ON `svet-ptitsa` . * TO 'svet-ptitsa'@'localhost';
GRANT ALL PRIVILEGES ON `wedowhatwedo` . * TO 'wedowhatwedo'@'localhost';
GRANT ALL PRIVILEGES ON `becausewecan` . * TO 'becausewecan'@'localhost';
GRANT ALL PRIVILEGES ON `buketl` . * TO 'buketl'@'localhost';
-- Пользователь
CREATE USER 'rast1'@'localhost' IDENTIFIED BY 'rast1.ru';

-- Поменять кодировку всех таблиц mysql
SELECT CONCAT('ALTER TABLE `', t.`TABLE_SCHEMA`, '`.`', t.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') as sqlcode
FROM `information_schema`.`TABLES` t
WHERE 1
AND t.`TABLE_SCHEMA` = 'db_name'
ORDER BY 1

--Импорт:
mysql -uroot -ppicapica l2jdb < l2jdb.sql
/opt/lampp/bin/mysql -uexchangebook -pexchangebook.ru --default_character_set utf8 exchangebook < book.sql
"C:\Program Files (x86)\VertrigoServ\Mysql\bin\mysql" -uroot -pvertrigo --default_character_set utf8 aion < D:\aion7.sql