�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽT�ｿｽ[�ｿｽo�ｿｽ[�ｿｽ\�ｿｽz(MySQL)

�ｿｽﾅ終�ｿｽX�ｿｽV�ｿｽ�ｿｽ�ｿｽF 2014.02.19

[root@fedora ~]# yum -y install mysql-server�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@mysql-server�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽg�ｿｽ[�ｿｽ�ｿｽ

[root@fedora ~]# vi /etc/my.cnf�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@MySQL�ｿｽﾝ抵ｿｽt�ｿｽ@�ｿｽC�ｿｽ�ｿｽ�ｿｽﾒ集
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
character-set-server = utf8�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽﾇ会ｿｽ(MySQL�ｿｽT�ｿｽ[�ｿｽo�ｿｽ[�ｿｽﾌ包ｿｽ�ｿｽ�ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽ�ｿｽUTF-8�ｿｽﾉゑｿｽ�ｿｽ�ｿｽ)

[root@fedora ~]# /etc/rc.d/init.d/mysqld start�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@MySQL�ｿｽN�ｿｽ�ｿｽ
Starting mysqld (via systemctl):                           [  OK  ]

[root@fedora ~]# chkconfig mysqld on�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@MySQL�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽN�ｿｽ�ｿｽ�ｿｽﾝ抵ｿｽ

[root@fedora ~]# mysql_secure_installation�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@MySQL�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾝ抵ｿｽ




NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!


In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none): �ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽ�ｿｽENTER
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.

Set root password? [Y/n] �ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽ�ｿｽENTER(root�ｿｽp�ｿｽX�ｿｽ�ｿｽ�ｿｽ[�ｿｽh�ｿｽﾝ抵ｿｽ)
New password: �ｿｽ@�ｿｽ�ｿｽ�ｿｽ@root�ｿｽp�ｿｽX�ｿｽ�ｿｽ�ｿｽ[�ｿｽh�ｿｽ�ｿｽ�ｿｽ�ｿｽ
Re-enter new password: �ｿｽ@�ｿｽ�ｿｽ�ｿｽ@root�ｿｽp�ｿｽX�ｿｽ�ｿｽ�ｿｽ[�ｿｽh�ｿｽ�ｿｽ�ｿｽ�ｿｽ(�ｿｽm�ｿｽF)
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] �ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽ�ｿｽENTER(�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ[�ｿｽU�ｿｽ[�ｿｽ�除)
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] �ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽ�ｿｽENTER(�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ[�ｿｽg�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽroot�ｿｽ�ｿｽ�ｿｽO�ｿｽC�ｿｽ�ｿｽ�ｿｽﾖ止)
 ... Success!

By default, MySQL comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] �ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽ�ｿｽENTER(test�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽ�除)
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] �ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽ�ｿｽENTER
 ... Success!

Cleaning up...



All done!  If you've completed all of the above steps, your MySQL
installation should now be secure.

Thanks for using MySQL!

[root@fedora ~]# mysql -u root -p�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@MySQL�ｿｽ�ｿｽroot�ｿｽﾅ��ｿｽ�ｿｽO�ｿｽC�ｿｽ�ｿｽ
Enter password: �ｿｽ@�ｿｽ�ｿｽ�ｿｽ@MySQL�ｿｽ�ｿｽroot�ｿｽp�ｿｽX�ｿｽ�ｿｽ�ｿｽ[�ｿｽh�ｿｽ�ｿｽ�ｿｽ�ｿｽ
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.21

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


mysql> grant all privileges on test.* to fedora@localhost identified by 'fedorapass';
�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@test�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽﾖの全�ｿｽﾄのア�ｿｽN�ｿｽZ�ｿｽX�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽA�ｿｽV�ｿｽK�ｿｽ�ｿｽ�ｿｽ[�ｿｽUfedora�ｿｽ�ｿｽo�ｿｽ^
Query OK, 0 rows affected (0.00 sec)

mysql> select user from mysql.user where user='fedora';�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@fedora�ｿｽ�ｿｽ�ｿｽ[�ｿｽU�ｿｽo�ｿｽ^�ｿｽm�ｿｽF
+--------+
| user   |
+--------+
| fedora |
+--------+
1 row in set (0.00 sec)

mysql> exit�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽ�ｿｽ�ｿｽO�ｿｽA�ｿｽE�ｿｽg
Bye

[root@fedora ~]# mysql -u fedora -pfedorapass�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@fedora�ｿｽ�ｿｽ�ｿｽ[�ｿｽU�ｿｽ�ｿｽMySQL�ｿｽT�ｿｽ[�ｿｽo�ｿｽ[�ｿｽﾖ��ｿｽ�ｿｽO�ｿｽC�ｿｽ�ｿｽ
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.21

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database test;�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@test�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽ�成
Query OK, 1 row affected (0.00 sec)

mysql> show databases;�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽ�成�ｿｽm�ｿｽF
+--------------------+
| Database           |
+--------------------+
| information_schema |
| test               |
+--------------------+
2 rows in set (0.00 sec)

mysql> use test�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@test�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽﾖ接托ｿｽ
Database changed

mysql> create table test(num int, name varchar(50));�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@test�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽ�成
Query OK, 0 rows affected (0.01 sec)

mysql> show tables;�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽ�成�ｿｽm�ｿｽF
+----------------+
| Tables_in_test |
+----------------+
| test           |
+----------------+
1 row in set (0.00 sec)

mysql> insert into test values(1,'�ｿｽR�ｿｽc�ｿｽ�ｿｽ�ｿｽY');�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@test�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽﾖデ�ｿｽ[�ｿｽ^�ｿｽo�ｿｽ^
Query OK, 1 row affected (0.00 sec)

mysql> select * from test;�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽf�ｿｽ[�ｿｽ^�ｿｽo�ｿｽ^�ｿｽm�ｿｽF
+------+----------+
| num  | name     |
+------+----------+
|    1 | �ｿｽR�ｿｽc�ｿｽ�ｿｽ�ｿｽY |
+------+----------+
1 row in set (0.00 sec)

mysql> update test set name='�ｿｽR�ｿｽc�ｿｽ�ｿｽ�ｿｽY';�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@test�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽf�ｿｽ[�ｿｽ^�ｿｽX�ｿｽV
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from test;�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽf�ｿｽ[�ｿｽ^�ｿｽX�ｿｽV�ｿｽm�ｿｽF
+------+----------+
| num  | name     |
+------+----------+
|    1 | �ｿｽR�ｿｽc�ｿｽ�ｿｽ�ｿｽY |
+------+----------+
1 row in set (0.01 sec)

mysql> delete from test where num=1;�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@test�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽf�ｿｽ[�ｿｽ^�ｿｽ�除
Query OK, 1 row affected (0.03 sec)

mysql> select * from test;�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽf�ｿｽ[�ｿｽ^�ｿｽ�除�ｿｽm�ｿｽF
Empty set (0.00 sec)

mysql> drop table test;�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@test�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽ�除
Query OK, 0 rows affected (0.00 sec)

mysql> show tables;�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽ�除�ｿｽm�ｿｽF
Empty set (0.00 sec)

mysql> drop database test;�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽXtest�ｿｽ�除
Query OK, 0 rows affected (0.00 sec)

mysql> show databases;�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽ�除�ｿｽm�ｿｽF
+--------------------+
| Database           |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)

mysql> exit�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽ�ｿｽ�ｿｽO�ｿｽA�ｿｽE�ｿｽg
Bye

[root@fedora ~]# mysql -u root -p�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@MySQL�ｿｽ�ｿｽroot�ｿｽﾅ��ｿｽ�ｿｽO�ｿｽC�ｿｽ�ｿｽ
Enter password: �ｿｽ@�ｿｽ�ｿｽ�ｿｽ@MySQL�ｿｽ�ｿｽroot�ｿｽp�ｿｽX�ｿｽ�ｿｽ�ｿｽ[�ｿｽh�ｿｽ�ｿｽ�ｿｽ�ｿｽ
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.21

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> revoke all privileges on *.* from fedora@localhost;�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@fedora�ｿｽ�ｿｽ�ｿｽ[�ｿｽU�ｿｽ�ｿｽ�ｿｽ�ｿｽS�ｿｽﾄのデ�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽﾖのア�ｿｽN�ｿｽZ�ｿｽX�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�剥奪
Query OK, 0 rows affected (0.00 sec)

mysql> delete from mysql.user where user='fedora' and host='localhost';�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@fedora�ｿｽ�ｿｽ�ｿｽ[�ｿｽU�ｿｽ�除
Query OK, 1 row affected (0.01 sec)

mysql> select user from mysql.user where user='fedora';�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@fedora�ｿｽ�ｿｽ�ｿｽ[�ｿｽU�ｿｽ�除�ｿｽm�ｿｽF
Empty set (0.00 sec)

mysql> flush privileges;�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@fedora�ｿｽ�ｿｽ�ｿｽ[�ｿｽU�ｿｽﾌ削除�ｿｽ�ｿｽMySQL�ｿｽT�ｿｽ[�ｿｽo�ｿｽ[�ｿｽﾖ費ｿｽ�ｿｽf
Query OK, 0 rows affected (0.01 sec)

mysql> exit�ｿｽ@�ｿｽ�ｿｽ�ｿｽ@�ｿｽ�ｿｽ�ｿｽO�ｿｽA�ｿｽE�ｿｽg
Bye