|
我发现,Fedora22下安装的mysql-server,默认创建了test数据库 |
一派護法 十九級 |
以前版本的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)]>
|