최신판 |
당신의 편집 |
1번째 줄: |
1번째 줄: |
| {{다른뜻|CentOS MySQL 클라이언트 설치}}
| | {{테스트|CentOS 6.3}} |
| {{다른뜻|우분투 MySQL 서버 설치}}
| | ;리눅스 MySQL 설치 |
| {{테스트|CentOS 6.3 + MySQL 5.1.69}} | |
| ;CentOS MySQL 설치 | |
| ;CentOS MySQL 서버 설치
| |
| | |
| ==사전 확인==
| |
| <source lang='console'>
| |
| [root@zetawiki ~]# rpm -qa | grep ^mysql-server
| |
| </source>
| |
| :→ MySQL 서버가 설치되지 않았다.....
| |
|
| |
|
| ==yum으로 설치== | | ==yum으로 설치== |
| <source lang='console'> | | <source lang='dos'> |
| [root@zetawiki ~]# yum install mysql-server | | [root@jmnote ~]# yum install mysql |
| ... (생략) | | ... (생략) |
| =========================================================================================== | | =================================================================================================================================== |
| Package Arch Version Repository Size | | Package Arch Version Repository Size |
| =========================================================================================== | | =================================================================================================================================== |
| Installing: | | Installing: |
| mysql-server x86_64 5.1.73-8.el6_8 base 8.6 M | | mysql x86_64 5.1.66-2.el6_3 Daum 885 k |
| Installing for dependencies:
| |
| mysql x86_64 5.1.73-8.el6_8 base 895 k
| |
| perl-DBD-MySQL x86_64 4.013-3.el6 base 134 k
| |
| perl-DBI x86_64 1.609-4.el6 base 705 k
| |
| Updating for dependencies: | | Updating for dependencies: |
| mysql-libs x86_64 5.1.73-8.el6_8 base 1.2 M | | mysql-libs x86_64 5.1.66-2.el6_3 Daum 1.2 M |
|
| |
|
| Transaction Summary | | Transaction Summary |
| =========================================================================================== | | =================================================================================================================================== |
| Install 4 Package(s) | | Install 1 Package(s) |
| Upgrade 1 Package(s) | | Upgrade 1 Package(s) |
|
| |
|
| Total download size: 12 M | | Total download size: 2.1 M |
| Is this ok [y/N]: y | | Is this ok [y/N]: y |
| </source> | | </source> |
| <source lang='console'> | | <source lang='dos'> |
| ... (생략) | | ... (생략) |
| Installed: | | Installed: |
| mysql-server.x86_64 0:5.1.73-8.el6_8 | | mysql.x86_64 0:5.1.66-2.el6_3 |
| | |
| Dependency Installed:
| |
| mysql.x86_64 0:5.1.73-8.el6_8 perl-DBD-MySQL.x86_64 0:4.013-3.el6
| |
| perl-DBI.x86_64 0:1.609-4.el6
| |
|
| |
|
| Dependency Updated: | | Dependency Updated: |
| mysql-libs.x86_64 0:5.1.73-8.el6_8 | | mysql-libs.x86_64 0:5.1.66-2.el6_3 |
|
| |
|
| Complete! | | Complete! |
| </source>
| |
|
| |
| ==서비스 시작==
| |
| <source lang='console'>
| |
| [root@zetawiki ~]# service mysqld start
| |
| Initializing MySQL database: Installing MySQL system tables...
| |
| OK
| |
| Filling help tables...
| |
| OK
| |
|
| |
| To start mysqld at boot time you have to copy
| |
| support-files/mysql.server to the right place for your system
| |
|
| |
| PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
| |
| To do so, start the server, then issue the following commands:
| |
|
| |
| /usr/bin/mysqladmin -u root password 'new-password'
| |
| /usr/bin/mysqladmin -u root -h jmnote password 'new-password'
| |
|
| |
| Alternatively you can run:
| |
| /usr/bin/mysql_secure_installation
| |
|
| |
| which will also give you the option of removing the test
| |
| databases and anonymous user created by default. This is
| |
| strongly recommended for production servers.
| |
|
| |
| See the manual for more instructions.
| |
|
| |
| You can start the MySQL daemon with:
| |
| cd /usr ; /usr/bin/mysqld_safe &
| |
|
| |
| You can test the MySQL daemon with mysql-test-run.pl
| |
| cd /usr/mysql-test ; perl mysql-test-run.pl
| |
|
| |
| Please report any problems with the /usr/bin/mysqlbug script!
| |
|
| |
| [ OK ]
| |
| Starting mysqld: [ OK ]
| |
| </source>
| |
|
| |
| ==패스워드 지정==
| |
| * MySQL의 root계정<ref>OS계정이 아니라 DB계정임</ref> 패스워드를 P@ssw0rd로 지정하는 예시
| |
| <source lang='console'>
| |
| [root@zetawiki ~]#/usr/bin/mysql_secure_installation
| |
|
| |
|
| |
|
| |
|
| |
| 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):
| |
| 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]
| |
| </source>
| |
| <source lang='console'>
| |
| New password: P@ssw0rd
| |
| Re-enter new password: P@ssw0rd
| |
| 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]
| |
| </source>
| |
| <source lang='console'>
| |
| ... 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]
| |
| </source>
| |
| <source lang='console'>
| |
| ... 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]
| |
| </source>
| |
| <source lang='console'>
| |
| - 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]
| |
| </source>
| |
| <source lang='console'>
| |
| ... 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!
| |
| </source>
| |
|
| |
| ==로컬 접속 확인==
| |
| <source lang='console'>
| |
| [root@zetawiki ~]# mysql -uroot -p
| |
| Enter password: P@ssw0rd
| |
| </source>
| |
| <source lang='console'>
| |
| Welcome to the MySQL monitor. Commands end with ; or \g.
| |
| Your MySQL connection id is 4
| |
| Server version: 5.1.71 Source distribution
| |
|
| |
| Copyright (c) 2000, 2013, 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> show databases;
| |
| +--------------------+
| |
| | Database |
| |
| +--------------------+
| |
| | information_schema |
| |
| | mysql |
| |
| +--------------------+
| |
| 2 rows in set (0.00 sec)
| |
|
| |
| mysql> exit
| |
| Bye
| |
| </source>
| |
|
| |
| ==부팅시 자동시작 설정==
| |
| <source lang='console'>
| |
| [root@zetawiki ~]# chkconfig --list mysqld
| |
| mysqld 0:off 1:off 2:off 3:off 4:off 5:off 6:off
| |
| [root@zetawiki ~]# chkconfig mysqld on
| |
| [root@zetawiki ~]# chkconfig --list mysqld
| |
| mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
| |
| </source> | | </source> |
|
| |
|
| ==같이 보기== | | ==같이 보기== |
| *[[우분투 MySQL 설치]]
| |
| *[[윈도우 MySQL 설치]] | | *[[윈도우 MySQL 설치]] |
| *[[CentOS MySQL 클라이언트 설치]]
| |
| *[[리눅스 MySQL 최신버전 설치]]
| |
| *[[리눅스 phpMyAdmin 설치]]
| |
| *[[CentOS 5에 MySQL 5.5 설치 (yum)]]
| |
| *[[리눅스 APM 설치]]
| |
| *[[Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock']]
| |
| *[[리눅스 서비스 자동시작]]
| |
| *[[/var/log/mysqld.log]]
| |
| *[[리눅스 MariaDB 설치]]
| |
|
| |
| ==주석==
| |
| <references/>
| |
|
| |
|
| [[분류: MySQL]] | | [[분류: MySQL]] |
| [[분류: yum 설치]] | | [[분류: yum 설치]] |