MySQL与MariaDB安装(四)

2019独角兽企业重金招聘Python工程师标准>>>

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

 

转载于:https://my.oschina.net/u/2971691/blog/807225