MySQL与MariaDB安装(三)
来源:互联网 发布:淘宝聚划算真的便宜吗 编辑:程序博客网 时间:2024/05/04 08:33
第一部分 MariaDB 安装(Mac)
总体步骤:
1. xcode-select --install 下载最新xcode
2. 配置并检测Homebrew;
3. 下载MariaDB: brew install mariadb
4. 启动数据库下载器 mysql_install_db(前提: 切换至安装目录下)
5. 启动数据库服务: mysql.server start
6. mysql_secure_installation: 对基本的一些信息的配置
7. 连接数据库: mysql -u root -p
Mac 现在还没有 MariaDB 的官方安装工具。不过你可以用 Homebrew来 下载和安装所需的包(其中包括所需的库)。
第二部分 MariaDB 安装重要的几个步骤
#下载
$ brew install mariadb
. #链接数据库
To connect:
mysql -uroot
#如果想登陆启动数据库执行该语句
To have launchd start mariadb now and restart at login:
brew services start mariadb
#如果不想自启动执行该语句
Or, if you don't want/need a background service you can just run:
mysql.server start
==> Summary
� /usr/local/Cellar/mariadb/10.1.19: 574 files, 136.6M
*运行mysql_install_db安装程序
#与上一步的版本号匹配
$ cd /usr/local/Cellar/mariadb/10.1.19
$ mysql_install_db
.
.
.
.
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:
'/usr/local/Cellar/mariadb/10.1.19/bin/mysqladmin' -u root password 'new-password'
'/usr/local/Cellar/mariadb/10.1.19/bin/mysqladmin' -u root -h BWF-huanghaowei.local password 'new-password'
# 设置密码相关的内容, 可以使用如下命令
Alternatively you can run:
'/usr/local/Cellar/mariadb/10.1.19/bin/mysql_secure_installation'
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.
##启动demo数据表
You can start the MariaDB daemon with:
cd '/usr/local/Cellar/mariadb/10.1.19' ; /usr/local/Cellar/mariadb/10.1.19/bin/mysqld_safe --datadir='/usr/local/var/mysql'
You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/local/Cellar/mariadb/10.1.19/mysql-test' ; perl mysql-test-run.pl
Please report any problems at http://mariadb.org/jira
The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from MariaDB
Corporation Ab. You can contact us about this at sales@mariadb.com.
Alternatively consider joining our community based development effort:
http://mariadb.com/kb/en/contributing-to-the-mariadb-project/
BWF-huanghaowei:10.1.19 51Code$
- MySQL与MariaDB安装(三)
- 【MariaDB】安装MariaDB,与MySQL并存
- 安装MariaDB,与MySQL并存
- MySQL与MariaDB安装(四)
- LAMP、MySQL、MariaDB介绍与安装
- (三)centos7下安装MariaDB 10.0/MySQL数据库
- centos7 安装mysql(mariadb)
- Centos7安装mysql(mariadb)
- 一.MariaDB 与mysql
- MariaDB与MySQL
- mariadb与mysql
- mariadb安装与使用
- mariadb安装与使用
- CentOS 7下安装MySQL与mariadb冲突的解决办法
- Opensuse下安装MySQL / MariaDB
- centos7 安装mariadb(mysql)
- MariaDB(MySQL)二进制安装
- centos7安装mariadb替代mysql
- jdk1.5新特性之可变参数
- oracle学习之:查询当前SCN
- 二叉树的递归遍历与非递归遍历
- HTTP Status 406 - @ResponseBody 返回json报错
- 令scrollView不自己下移
- MySQL与MariaDB安装(三)
- 第三十八讲项目2——打豆豆
- mybatis 打印sql到控制台
- 前端h5 date类型的存放到实体类中date(基于springMVC)
- CSS的基本样式总结(一)
- git 常用操作
- android 使用MediaCodec 编解码总结(最全)
- [KinectWPF程序]单帧彩色图像获取
- 怎样确认linux系统中目前打开的文件句柄数