MySQL 5.6.29源码编译安装记录(2)

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.

You already have a root password set, so you can safely answer 'n'.

Change the root password? [Y/n] n  
... skipping.

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] y  
... 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] n  
... skipping.

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] y  
- 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] y  
... Success!

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

Thanks for using MySQL!

Cleaning up...

登录测试:

[root@test data]# mysql -uroot -p  
Enter password:    
Welcome to the MySQL monitor.  Commands end with ; or \g.    
Your MySQL connection id is 9    
Server version: 5.6.29-log Source distribution

Copyright (c) 2000, 2016, 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> \s  
--------------    
mysql  Ver 14.14 Distrib 5.6.29, for Linux (x86_64) using  EditLine wrapper

Connection id:          9  
Current database:    
Current user:          root@localhost    
SSL:                    Not in use    
Current pager:          stdout    
Using outfile:          ''    
Using delimiter:        ;    
Server version:        5.6.29-log Source distribution    
Protocol version:      10    
Connection:            Localhost via UNIX socket    
Server characterset:    utf8    
Db    characterset:    utf8    
Client characterset:    utf8    
Conn.  characterset:    utf8    
UNIX socket:            /tmp/mysql.sock    
Uptime:                9 min 36 sec

Threads: 1  Questions: 29  Slow queries: 0  Opens: 71  Flush tables: 1  Open tables: 64  Queries per second avg: 0.050  
--------------

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/1a78489fecd17902bf543cb79c276bae.html