MySQL 설치(CentOS)

rpm -qa | grep ^mysql-server

yum install mysql-server

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;

부팅시 자동시작 설정

chkconfig --list mysqld

chkconfig mysqld on

chkconfig --list mysqld