origoni's Blog from Millky

origoni의 스프링 블로그 입니다.

MySQL 5.6 설치 (centos 6.5)

http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html


[root@hostname ~]# history

    1  yum localinstall mysql-community-release-el6-5.noarch.rpm

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

    3  yum -y install wget

    4  yum -y update

    5  ls

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

    7  yum localinstall mysql-community-release-el6-5.noarch.rpm

    8  yum repolist enabled | grep "mysql.*-community.*"

    9  yum install mysql-community-server

   10  service mysqld start

   11  mysql_secure_installation

   12  history

[root@hostname ~]# service mysqld status

mysqld (pid  11378)를 실행하고 있습니다..

[root@hostname ~]#


설치는 매우 간단하다.

웹페이지에 설명이 너무 자세하게 잘 나오있다.


이건 서버 처음 설치하고 바로 실행한것임




---- 다시 세팅~


1 yum -y update 

2 yum -y install wget 

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

4 yum localinstall mysql-community-release-el6-5.noarch.rpm 

5 yum repolist enabled | grep "mysql.*-community.*" 

6 yum install mysql-community-server 

7 service mysqld start 

8 mysql_secure_installation 

9 sed -i "/--dport 3306/ d" /etc/sysconfig/iptables 

10 sed -i "/lo -j ACCEPT$/ a -A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT" /etc/sysconfig/iptables 

11 /etc/rc.d/init.d/iptables restart 

12 ifconfig 

13 history


이렇게 하고보니 권한이...



[root@millky-db ~]# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 31

Server version: 5.6.19 MySQL Community Server (GPL)


Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> use mysql;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A


Database changed

mysql> select host, user, password from user;

+---------------+------+-------------------------------------------+

| host          | user | password                                  |

+---------------+------+-------------------------------------------+

| localhost     | root | * |

| millky-db     | root | * |

| 127.0.0.1     | root | * |

| ::1           | root | * |

+---------------+------+-------------------------------------------+

4 rows in set (0.00 sec)


mysql> grant all privileges on *.* to 'root'@'%' identified by 'password';

Query OK, 0 rows affected (0.00 sec)


mysql> select host, user, password from user;

+---------------+------+-------------------------------------------+

| host          | user | password                                  |

+---------------+------+-------------------------------------------+

| localhost     | root | * |

| millky-db     | root | * |

| 127.0.0.1     | root | * |

| ::1           | root | * |

| %             | root | * |

+---------------+------+-------------------------------------------+

5 rows in set (0.00 sec)


mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)


mysql> quit

Bye

[root@millky-db ~]# service mysqld restart

mysqld 를 정지 중:                                         [  OK  ]

mysqld (을)를 시작 중:                                     [  OK  ]

[root@millky-db ~]#


 



◀ 06/14 2014 13:37:52
Java(JDK) wget로 내려받기
03/22 2014 10:05:47
JDK 8 설치 (centos 6.5)
back to top