CentOS6 MySQL5.1.73 (バンドル)

cat /etc/redhat-release
arch
mysql --version

---

サンプルを探す

find /* -name my*.cnf 

cat /etc/my.cnf

ls /usr/share/mysql/my*.cnf

/usr/share/mysql/my-huge.cnf             
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/my-innodb-heavy-4G.cnf  
/usr/share/mysql/my-small.cnf
/usr/share/mysql/my-large.cnf

cp /usr/share/mysql/my-innodb-heavy-4G.cnf  /etc/my.cnf

---

vi /etc/my.cnf

[client]

default-character-set = utf8

[mysqld]
character-set-server = utf8

---

service mysqld start

---

mysql_secure_installation

---

mysql -uroot -p

---

Create Database testdb;
grant all privileges on *.* to usr1 identified by 'Passwd6';
FLUSH PRIVILEGES;
show grants;

---

SHOW variables like 'character_set%';

---

vi /etc/sysconfig/iptables
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

/etc/init.d/iptables restart

---