MySQL与MariaDB安装(四)

第一部分 MariaDB 安装(Mac)

*设置密码 测试数据相关的内容

 

#启动数据库

BWF-huanghaowei:10.1.19 51Code$ mysql.server start

 

SUCCESS!

 

#配置相关内容

BWF-huanghaowei:10.1.19 51Code$ mysql_secure_installation

 

Remove anonymous users? [Y/n] ... 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] ... Success! By default, MariaDB 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] - 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] ... Success! Cleaning up... All done! If you've completed all of the above steps, your MariaDB installation should now be secure. Thanks for using MariaDB! - See more at: https://mariadb.com/resources/blog/installing-mariadb-10116-mac-os-x-homebrew#sthash.5A9pcAbq.dpuf

*启动数据库, 默认数据库密码为空.

第二部分 MariaDB 链接数据库

#默认没有密码

$ mysql -uroot

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 7

Server version: 10.1.19-MariaDB Homebrew

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>