ensures that someonecannot guess at the root password from the network.
Disallow root loginremotely? [Y/n] y
... Success!
By default, MariaDBcomes with a database named 'test' that anyone can
access. This isalso intended only for testing, and should be removed
before moving into aproduction environment.
Remove test databaseand access to it? [Y/n] n
... skipping.
Reloading theprivilege tables will ensure that all changes made so far
will take effectimmediately.
Reload privilegetables now? [Y/n] y
... Success!
Cleaning up...
All done! If you'vecompleted all of the above steps, your MariaDB
installation shouldnow be secure.
Thanks for usingMariaDB!
[root@localhost ~]#
[root@localhost ~]#service mysqld restart
Shutting downMySQL.. SUCCESS!
Starting MySQL.SUCCESS!
[root@localhost~]# mysql -u root -p
Enter password:
Welcome to theMariaDB monitor. Commands end with ; or \g.
Your MariaDBconnection id is 5
Server version:10.0.19-MariaDB-log Source distribution
Copyright (c) 2000,2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h'for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>show tables
-> ;
ERROR 1046 (3D000):No database selected
MariaDB [(none)]>show databases;
+--------------------+
| Database |
+--------------------+
| information_schema|
| mysql |
| performance_schema|
| test |
+--------------------+
4 rows in set (0.04sec)
MariaDB [(none)]> //创建个测试库连接下
MariaDB [(none)]>create database r_test;
Query OK, 1 rowaffected (0.01 sec)
MariaDB [(none)]>grant all privileges on r_test.* to 'r_test'@'localhost' identifiedby 'r_test';
Query OK, 0 rowsaffected (0.00 sec)
MariaDB [(none)]>grant all privileges on r_test.* to 'r_test'@'%' identified by'r_test';
Query OK, 0 rowsaffected (0.00 sec)
用navicat连接下
Linux/2014-11/109049.htm