최신판 |
당신의 편집 |
88번째 줄: |
88번째 줄: |
| </source> | | </source> |
|
| |
|
| ==패스워드 지정== | | ==패스워드 변경== |
| * MySQL의 root계정<ref>OS계정이 아니라 DB계정임</ref> 패스워드를 P@ssw0rd로 지정하는 예시
| |
| <source lang='console'> | | <source lang='console'> |
| [root@zetawiki ~]#/usr/bin/mysql_secure_installation | | [root@zetawiki ~]# /usr/bin/mysqladmin -u root password 'P@ssw0rd' |
| | |
| | |
| | |
| | |
| 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> |
| | :→ MySQL의 root계정<ref>OS계정이 아니라 DB계정임</ref> 패스워드를 P@ssw0rd로 바꾸었다. |
| | :→ 이것은 최초 설치시만 된다. MySQL 삭제 후 재설치시에도 안되더라. |
| | :→ 만약 패스워드를 모른다면 '''[[MySQL root 패스워드 분실]]''' 참고 |
|
| |
|
| ==로컬 접속 확인== | | ==로컬 접속 확인== |