ﾛｰｶﾙ XAMPP の phpmyadmin で amazon ec2 MySQL に 接続

SQL

MySQL接続

mysql -h ホスト名 --p ポート -u ユーザー -p
パスワード

ポート確認

netstat
cat /etc/services |grep mysql
nmap localhost

ポート設定

　/etc/my.cnf
port=3306

amazon ec2 ポート開放

Security Groups → Inbound → ADD → Apply

mysqlﾕｰｻﾞｰ編集

update user set user.Host=%
FLUSH PRIVILEGES;

php.ini

　mbstring.language = uni
　mbstring.internal_encoding = utf-8
　mbstring.http_input = auto
　mbstring.http_output = utf-8

my.cnf

[mysqld]
init-connect = SET NAMES utf8
character-set-server = utf8
collation-server = utf8_general_ci
[mysqldump]
default-character-set = utf8
[mysql]
default-character-set = utf8

phpmyadmin config.inc.php

$cfg['DefaultLang'] = 'utf-8';
$cfg['DefaultCharset'] = 'utf-8';
$cfg['Servers'][$i]['host'] = ec2_ホスト名
$cfg['Servers'][$i]['user'] =
$cfg['Servers'][$i]['password'] =