Skip to content

Instantly share code, notes, and snippets.

@letsspeak
Last active December 15, 2015 01:49
Show Gist options
  • Save letsspeak/5182427 to your computer and use it in GitHub Desktop.
Save letsspeak/5182427 to your computer and use it in GitHub Desktop.
mysql creating fuelphp user APPLICATION_NAME is your application name
mysql> select * INTO OUTFILE 'dump.txt' from テーブル名;
mysql> LOAD DATA INFILE 'dump.txt' INTO TABLE テーブル名;
CREATE USER 'APPLICATION_NAME'@'localhost' IDENTIFIED BY '***';
GRANT USAGE ON * . * TO 'APPLICATION_NAME'@'localhost' IDENTIFIED BY '***'
WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
CREATE DATABASE IF NOT EXISTS `APPLICATION_NAME` ;
GRANT ALL PRIVILEGES ON `APPLICATION_NAME` . * TO 'APPLICATION_NAME'@'localhost';
grant file on *.* to APPLICATION_NAME@localhost;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment