Centos7 64bit 웹서버 만들기-mysql설치 CAP4

/*---------------------------------------------------------------------------------------*/

mysql을 설치하자.. 요건 좀 어려울라나~ 우선 고고~~~

그런데 이상하다. 아래처럼 설치하니 뭔가 이상함  항상 쓰던 mysql 접속에서

...그래서 우선 삭제 요점은 맨밑에

/*---------------------------------------------------------------------------------------*/

[root@localhost ~]# yum -y install mysql 

  --생략--  
  perl-podlators.noarch 0:2.5.1-3.el7                     perl-threads.x86_64 0:1.87-4.el7                  
  perl-threads-shared.x86_64 0:1.43-6.el7               

Complete!
 [root@localhost ~]# yum erase mysql
Loaded plugins: fastestmirror
Resolving Dependencies
--> Running transaction check
---> Package mariadb.x86_64 1:5.5.41-2.el7_0 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

=======================================================================================================
 Package                 Arch                   Version                          Repository             Size
=======================================================================================================
Removing:
 mariadb                 x86_64                 1:5.5.41-2.el7_0                 @base                  49 M

Transaction Summary
=======================================================================================================
--생략--

  Erasing    : 1:mariadb-5.5.41-2.el7_0.x86_64                                                           1/1
  Verifying  : 1:mariadb-5.5.41-2.el7_0.x86_64                                                           1/1

Removed:
  mariadb.x86_64 1:5.5.41-2.el7_0                                                                           

Complete!

/*---------------------------------------------------------------------------------------*/

mariadb?? 이게 뭐지.. 검색해보니 centos7에서 mysql은 다운받아서 써야됨 젠장

그럼 다운받아주지..아래 그림설명해놔야징..

/*---------------------------------------------------------------------------------------*/

/*---------------------------------------------------------------------------------------*/

mysql 홈페이지 다운로드->yum  들어가서 centos7이니까 linux7 다운로드 하자

그담에 받은 패키지를 올려볼까~~ 경로는 맘대로 /usr/etc 요기에 넣었당. 

/*---------------------------------------------------------------------------------------*/

/*---------------------------------------------------------------------------------------*/

자 올렸다.. 올리는 방법은 툴을 이용하는게 좋을듯. 하는김에 툴도 올려놓자 sshclient 아주 자주 사용하니까

그럼 다시 설치 시작

/*---------------------------------------------------------------------------------------*/

[root@localhost ~]# yum -y install /usr/etc/mysql-community-release-el7-5.noarch.rpm
Loaded plugins: fastestmirror
Examining /usr/etc/mysql-community-release-el7-5.noarch.rpm: mysql-community-release-el7-5.noarch
Marking /usr/etc/mysql-community-release-el7-5.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-release.noarch 0:el7-5 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=======================================================================================================
 Package                       Arch         Version        Repository                                   Size
=======================================================================================================
Installing:
 mysql-community-release       noarch       el7-5          /mysql-community-release-el7-5.noarch       4.3 k

Transaction Summary
=======================================================================================================
Install  1 Package

Total size: 4.3 k
Installed size: 4.3 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : mysql-community-release-el7-5.noarch                                              1/1
  Verifying  : mysql-community-release-el7-5.noarch                                             1/1

Installed:
  mysql-community-release.noarch 0:el7-5                                                                    

Complete!
[root@localhost ~]# yum -y install mysql-community-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: data.nicehosting.co.kr
 * extras: data.nicehosting.co.kr
 * updates: data.nicehosting.co.kr
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.6.24-3.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=======================================================================================================
 Package                          Arch             Version                 Repository                   Size
=======================================================================================================
Installing:
 mysql-community-server           x86_64           5.6.24-3.el7            mysql56-community            58 M

Transaction Summary
=======================================================================================================
Install  1 Package

Total download size: 58 M
Installed size: 244 M
Downloading packages:
mysql-community-server-5.6.24-3.el7.x86_64.rpm                                        |  58 MB  00:00:09    
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : mysql-community-server-5.6.24-3.el7.x86_64                                            1/1
  Verifying  : mysql-community-server-5.6.24-3.el7.x86_64                                           1/1

Installed:
  mysql-community-server.x86_64 0:5.6.24-3.el7                                                              

Complete!
[root@localhost ~]# systemctl start mysqld  <-(요건 뭐 mysql 실행하는거야) 

[root@localhost ~]# systemctl enable mysqld <-(요것도 뭐 당연히 해야 재부팅시 자동으로 올라온다)

/*---------------------------------------------------------------------------------------*/

여까지 했으면 재부팅 해보는것도 나쁘지 않을듯. 정말 작동되는지도 확인해보고..

그럼 이제 작동하는지 확인해 볼까~~! 시작.. 

/*---------------------------------------------------------------------------------------*/

[root@localhost ~]# mysql -u root -p <-(처음에는 비밀번호가 설정되어있지 않으니 설정해야 겠지)
Enter password:  <-요기서 엔터 치면 바로 넘어감
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.24 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, 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> update user set password=password('1111') where user='root';

(쿼리문 설명 user 테이블에서  root라는 유저를 찾아서 패스워드를 1111로 업데이트 해라.)

Query OK, 4 rows affected (0.01 sec)
Rows matched: 4  Changed: 4  Warnings: 0

mysql> flush privileges; <-(요거 해줘야 패스워드 업데이트 된다.)
Query OK, 0 rows affected (0.00 sec) 

mysql> quit <- (mysql query 종료 exit<-요명령도 됨)
Bye
[root@localhost ~]# mysql -u root -p
Enter password: <-(이제 아까 넣었던 패스워드 입력하고 엔터)
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.6.24 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, 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>  

/*---------------------------------------------------------------------------------------*/

이제 몇가지 mysql query문을 해볼까~~ 자 해보자 위에문 연결하여 계속간다. 

/*---------------------------------------------------------------------------------------*/

mysql> show databases;
+--------------------+
| Database                    

+--------------------+
| information_schema      
| mysql                         
| performance_schema    
+--------------------+
3 rows in set (0.00 sec)

mysql>

/*---------------------------------------------------------------------------------------*/

위에 3개의 db는 직접적으로 사용하지 않는다. 그런데 내용이 보고싶다면??

한번 볼까? 그럼 아까 수정했던 mysql db를 한번 보자 

/*---------------------------------------------------------------------------------------*/

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> show tables;
+---------------------------+
| Tables_in_mysql

+---------------------------+
| columns_priv             
| db                       
| event                    
| func                     
| general_log            
| help_category         

| help_keyword             
| help_relation            
| help_topic               
| innodb_index_stats       
| innodb_table_stats       
| ndb_binlog_index         
| plugin                   
| proc                     
| procs_priv               
| proxies_priv             
| servers                  
| slave_master_info        
| slave_relay_log_info     
| slave_worker_info        
| slow_log                 
| tables_priv              
| time_zone                
| time_zone_leap_second    
| time_zone_name           
| time_zone_transition     
| time_zone_transition_type
| user                     
+---------------------------+
28 rows in set (0.00 sec)

mysql> desc user;
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Field                  | Type                              | Null | Key | Default               | Extra |
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Host                   | char(60)                          | NO   | PRI |                       |       |
| User                   | char(16)                          | NO   | PRI |                       |       |
| Password               | char(41)                          | NO   |     |                       |       |
| Select_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Insert_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Update_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Delete_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Create_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Drop_priv              | enum('N','Y')                     | NO   |     | N                     |       |
| Reload_priv            | enum('N','Y')                     | NO   |     | N                     |       |
| Shutdown_priv          | enum('N','Y')                     | NO   |     | N                     |       |
| Process_priv           | enum('N','Y')                     | NO   |     | N                     |       |
| File_priv              | enum('N','Y')                     | NO   |     | N                     |       |
| Grant_priv             | enum('N','Y')                     | NO   |     | N                     |       |
| References_priv        | enum('N','Y')                     | NO   |     | N                     |       |
| Index_priv             | enum('N','Y')                     | NO   |     | N                     |       |
| Alter_priv             | enum('N','Y')                     | NO   |     | N                     |       |
| Show_db_priv           | enum('N','Y')                     | NO   |     | N                     |       |
| Super_priv             | enum('N','Y')                     | NO   |     | N                     |       |
| Create_tmp_table_priv  | enum('N','Y')                     | NO   |     | N                     |       |
| Lock_tables_priv       | enum('N','Y')                     | NO   |     | N                     |       |
| Execute_priv           | enum('N','Y')                     | NO   |     | N                     |       |
| Repl_slave_priv        | enum('N','Y')                     | NO   |     | N                     |       |
| Repl_client_priv       | enum('N','Y')                     | NO   |     | N                     |       |
| Create_view_priv       | enum('N','Y')                     | NO   |     | N                     |       |
| Show_view_priv         | enum('N','Y')                     | NO   |     | N                     |       |
| Create_routine_priv    | enum('N','Y')                     | NO   |     | N                     |       |
| Alter_routine_priv     | enum('N','Y')                     | NO   |     | N                     |       |
| Create_user_priv       | enum('N','Y')                     | NO   |     | N                     |       |
| Event_priv             | enum('N','Y')                     | NO   |     | N                     |       |
| Trigger_priv           | enum('N','Y')                     | NO   |     | N                     |       |
| Create_tablespace_priv | enum('N','Y')                     | NO   |     | N                     |       |
| ssl_type               | enum('','ANY','X509','SPECIFIED') | NO   |     |                       |       |
| ssl_cipher             | blob                              | NO   |     | NULL                  |       |
| x509_issuer            | blob                              | NO   |     | NULL                  |       |
| x509_subject           | blob                              | NO   |     | NULL                  |       |
| max_questions          | int(11) unsigned                  | NO   |     | 0                     |       |
| max_updates            | int(11) unsigned                  | NO   |     | 0                     |       |
| max_connections        | int(11) unsigned                  | NO   |     | 0                     |       |
| max_user_connections   | int(11) unsigned                  | NO   |     | 0                     |       |
| plugin                 | char(64)                          | YES  |     | mysql_native_password |       |
| authentication_string  | text                              | YES  |     | NULL                  |       |
| password_expired       | enum('N','Y')                     | NO   |     | N                     |       |
+------------------------+-----------------------------------+------+-----+-----------------------+-------+
43 rows in set (0.00 sec)

mysql>  

/*---------------------------------------------------------------------------------------*/

너무 길어졌다. query문은 고만~

요점정리 하자.. 또 필요하거나 주석달일 생기면 계속업데이트 해놔야징... 

/*---------------------------------------------------------------------------------------*/

 1.  mysql.com에서 패키지 다운 받아서 /usr/etc에 저장
 2. [root@localhost ~]# yum -y install /usr/etc/mysql-community-release-el7-5.noarch.rpm

 3. [root@localhost ~]# yum -y install mysql-community-server
 4. [root@localhost ~]# systemctl start mysqld  <-(요건 뭐 mysql 실행하는거야) 

 5. [root@localhost ~]# systemctl enable mysqld <-(요것도 뭐 당연히 해야 재부팅시 자동으로 올라온다)

 6. [root@localhost ~]# mysql -u root -p mysql

 7. mysql> update user set password=password('알아서넣자') where user='root';

 8. mysql> flush privileges;

 9. mysql> exit​
10.[root@localhost ~]#