第一部分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 theMariaDBmonitor. 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)]>