 |
以前版本的linux都沒有自動創建此資料庫。
|
|
|
[octopus@pc5 ~]$ sudo service mariadb start
Redirecting to /bin/systemctl start mariadb.service
[octopus@pc5 ~]$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.0.20-MariaDB MariaDB Server
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 databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
MariaDB [(none)]>
|
|
|
MariaDB [(none)]> use test;
Database changed
MariaDB [test]> show tables;
Empty set (0.00 sec)
MariaDB [test]>
|
|
|
MariaDB [test]> SET PASSWORD FOR root@localhost = PASSWORD('newpas');
Query OK, 0 rows affected (0.00 sec)
MariaDB [test]>
|
|
|
MariaDB [test]> exit
Bye
[octopus@pc5 ~]$
|
|
|
[octopus@pc5 ~]$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[octopus@pc5 ~]$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 5
Server version: 10.0.20-MariaDB MariaDB Server
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)]>
|
|
|
MariaDB [(none)]> select PASSWORD('abc');
+-------------------------------------------+
| PASSWORD('abc') |
+-------------------------------------------+
| *0D3CED9BEC10A777AEC23CCC353A8C08A633045E |
+-------------------------------------------+
1 row in set (0.00 sec)
MariaDB [(none)]> select MD5('abc');
+----------------------------------+
| MD5('abc') |
+----------------------------------+
| 900150983cd24fb0d6963f7d28e17f72 |
+----------------------------------+
1 row in set (0.00 sec)
MariaDB [(none)]>
|
