MySQL - Sizuha/devdog GitHub Wiki

/usr/local/mysql/bin

sudo cp /usr/local/mysql/support-files/my-huge.cnf /etc/my.cnf

[mysqld]
character-set-server=utf8

[mysql]
default-character-set=utf8

mysql> show variables like "%character%";
mysql> show variables like "%collation%";

sudo /usr/local/mysql/support-files/mysql.server start

$ mysql -u root -pPASSWORD
mysql> use mysql;

mysql> insert into user (host, user, password) values ('localhost', 'dbuser', password('xxxxxxxx'));

mysql> insert into user (host, user, password) values ('%', 'dbuser', password('xxxxxxxx'));

mysql> show grants for USER@'%';

mysql> grant select, insert, update, delete on DB_Name.TableName to USER@'%';

mysql> grant select, insert, update, delete on DB_Name.* to USER@'%';

$ mysqladmin -u root -p password

$ mysql -u root 
mysql> update user set password = password('새로운_암호') where user = 'root';
mysql> flush privileges;

$ mysql -u root 
mysql> UPDATE mysql.user SET authentication_string=PASSWORD('my-new-password') WHERE User='root';
mysql> FLUSH PRIVILEGES;

mysql> set password for root = password('새로운_암호');

$ sudo /usr/local/mysql/support-files/mysql.server stop
$ sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables

$ mysql -u root

$ sudo /usr/local/mysql/support-files/mysql.server start

mysql> SET PASSWORD = PASSWORD('your_new_password');

$ mysql -u root -p

$ mysql -u 계정이름(ex. root) -p

mysql> show databases;

mysql> use DB이름;

mysql> create database DB이름;

mysql> CREATE DATABASE <dbname> CHARACTER SET utf8;

$ mysqldump -u {user} -p {database-name} > {dump-output}.sql

$ mysql -u {user} -p {database-name} < {dump-output}.sql

mysql> DESC 테이블이름;
mysql> DESCRIBE 테이블이름;
mysql> EXPLAIN 테이블이름;