[AWS] MySQL 설치

[MySql설치]

wget http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm

sudo yum localinstall http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm

sudo yum install mysql-community-server

 sudo service mysqld start

root 패스워드 변경

/usr/bin/mysqladmin -u root password 'maxgauge'

또는 update user set password=password('new-password') where user='root';

mysql -uroot -p

원격접속 허용

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' identified by 'maxgauge';

FLUSH PRIVILEGES;

확인

Mysql –h (접속IP) –p(포트번호) –u root –p