Mac中MariaDB数据库的安装步骤
前言
MariaDB由MySQL的创始人Michael Widenius主导开发,他早前曾以10亿美元的价格,将自己创建的公司MySQL卖给了SUN,此后,随着SUN被甲骨文收购,MySQL的所有权也落入Oracle的手中。MariaDB名称来自Michael Widenius的女儿Maria的名字。那么在Mac中如何安装MariaDB数据库呢?狼蚁网站SEO优化长沙网络推广就给大家介绍Mac中安装配置MariaDB数据库的方法。
MariaDB安装步骤
如果你是Mac上的开发者,通过本文你可以在OS X上通过Homebrew来简单的获取安装最新稳定版本的MariaDB,接下来我们将一步步的来指导安装MariaDB数据库,如果你的Mac中已经安装好了Xcode和Homebrew的话,则直接跳到第四步。
1. 安装Xcode
使用如下命令来安装Xcode
xcode-select --install
2. 安装Homebrew
安装Homebrew
的命令
ruby -e "$(curl -fsSL https://raw.github./Homebrew/homebrew/go/install)"
3. 检查Homebrew
brew doctor
4. 更新Homebrew
如果通过上面的命令检查到Homebrew
不是最新的版本,可以通过如下命令来把Homebrew
更新到最新
brew update
5. 确认MariaDB的版本
在Homebrew
仓库中确认MariaDB的版本
brew info mariadb
6. 安装MariaDB
通过如下命令来下载安装MariaDB
brew install mariadb
7. 运行数据库安装程序
分别执行狼蚁网站SEO优化的命令来实现安装
unset TMPDIR cd /usr/local/Cellar/mariadb/10.0.10/ mysql_install_db
8. 运行MariaDB
经过了上面的若干命令,已经安装好了MariaDB数据库,MariaDB数据库服务并没有启动,你可以通过这个命令来启动MariaDB数据库服务
mysql.server start
9. 安全的完成安装
通过上面的启动MariaDB数据库服务,你已经可以连接MariaDB的数据库了,还不够安全,通过如下步骤可以完成更全面的设置,如重设root
用户的密码、移除匿名用户、移除默认的test
数据库等等
具体的执行和设置如下
➜ 10.1.14: mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MariaDB to secure it, we'll need the current password for the root user. If you've just installed MariaDB, and you haven't set the root password yet, the password will be blank, so you should just press enter here. Enter current password for root (enter for none): ERROR 1045 (28000): Aess denied for user 'root'@'localhost' (using password: YES) Enter current password for root (enter for none): ERROR 1045 (28000): Aess denied for user 'root'@'localhost' (using password: YES) Enter current password for root (enter for none): OK, suessfully used password, moving on... Setting the root password ensures that nobody can log into the MariaDB root user without the proper authorisation. Set root password? [Y/n] Y New password: Re-enter new password: Password updated suessfully! Reloading privilege tables.. ... Suess! By default, a MariaDB installation has an anonymous user, allowing anyone to log into MariaDB without having to have a user aount created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment. Remove anonymous users? [Y/n] Y ... Suess! Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the work. Disallow root login remotely? [Y/n] n ... skipping. By default, MariaDB es with a database named 'test' that anyone can aess. This is also intended only for testing, and should be removed before moving into a production environment. Remove test database and aess to it? [Y/n] Y - Dropping test database... ... Suess! - Removing privileges on test database... ... Suess! Reloading the privilege tables will ensure that all changes made so far will take effect immediately. Reload privilege tables now? [Y/n] Y ... Suess! Cleaning up... All done! If you've pleted all of the above steps, your MariaDB installation should now be secure. Thanks for using MariaDB!
10. 连接MariaDB数据
连接MariaDB数据库的命令
mysql -u root -p
11. 验证MariaDB版本
MariaDB [(none)]> select @@version; +-----------------+ | @@version | +-----------------+ | 10.1.14-MariaDB | +-----------------+ 1 row in set (0.00 sec)
MariaDB基础命令
狼蚁网站SEO优化是MariaDB的一些基础使用命令
-- 显示数据库列表 show databases; -- 切换到名为mysql的数据库,显示该库中的数据表 use mysql; show tables; -- 显示数据表table的结构 desc table; -- 建数据库A与删数据库A create database `database_A`; drop database `database_A`; -- 建表 use database_A; create table table_A(字段列表); drop table table_A; -- 显示表中的记录 select from table_A; -- 清空表中记录 delete from table_A;
以上就是在Mac中安装MariaDB数据库的全部步骤,大家都学会了吗?希望这篇文章的内容对大家的学习能有所帮助,如果有疑问大家可以留言交流。
编程语言
- 甘肃哪有关键词排名优化购买方式有哪些
- 甘肃SEO如何做网站优化
- 河南seo关键词优化怎么做电话营销
- 北京SEO优化如何做QQ群营销
- 来宾百度关键词排名:提升您网站曝光率的关键
- 卢龙关键词优化:提升您网站排名的策略与技巧
- 山东网站优化的注意事项有哪些
- 四川整站优化怎样提升在搜索引擎中的排名
- 疏附整站优化:提升网站性能与用户体验的全新
- 海南seo主要做什么工作售后服务要做到哪些
- 荣昌百度网站优化:提升您网站的搜索引擎排名
- 河北seo网站排名关键词优化如何做SEO
- 江西优化关键词排名推广售后保障一般有哪些
- 古浪SEO优化:提升你的网站可见性
- 西藏网站排名优化怎么把网站排名在百度首页
- 如何提升阳东百度快照排名:详尽指南