【Ubuntu16】apt-get安装MariaDB
来源:互联网 发布:怎样理解计算机端口 编辑:程序博客网 时间:2024/05/06 23:15
一、Mysql背景信息
Mysql在互联网早期就流行了,追求速度、简单、坚持开源、几乎支持所有操作系统。完全支持多用户、多线程,支持海量数据存储,采用MyISAM、InnoDB两大存储引擎优势互补。但随着InnoDB和Mysql自身被Oracle收购,促使Mysql的创始人开发了MariaDB。
MariaDB最大的特点就是采用XtraDB存储引擎,并和原生版本兼容,保留了Mysql的自由开放,XtraDB是Percona开发的高性能存储引擎,主要是为了替代InnoDB.除了XtraDB引擎,后起之秀TokuDB支持高性能、事务处理的存储引擎,性能比InnoDB高出很多,超高的insert性能、高压缩比、支持在线修改索引、添加字段。
安装时Mysql、MariaDB、Percona Server 不能共存,要部署MariaDB就必须卸载另外两个。否则出现“mysql service masked”错误。
二、安装MariaDB
1.安装数据库环境
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1 #注释掉这一行
Mysql在互联网早期就流行了,追求速度、简单、坚持开源、几乎支持所有操作系统。完全支持多用户、多线程,支持海量数据存储,采用MyISAM、InnoDB两大存储引擎优势互补。但随着InnoDB和Mysql自身被Oracle收购,促使Mysql的创始人开发了MariaDB。
MariaDB最大的特点就是采用XtraDB存储引擎,并和原生版本兼容,保留了Mysql的自由开放,XtraDB是Percona开发的高性能存储引擎,主要是为了替代InnoDB.除了XtraDB引擎,后起之秀TokuDB支持高性能、事务处理的存储引擎,性能比InnoDB高出很多,超高的insert性能、高压缩比、支持在线修改索引、添加字段。
安装时Mysql、MariaDB、Percona Server 不能共存,要部署MariaDB就必须卸载另外两个。否则出现“mysql service masked”错误。
二、安装MariaDB
1.安装数据库环境
dream361@ubuntu16:~$ sudo aptitude install -y mariadb-server mariadb-client2.安装数据库实例
dream361@ubuntu16:~$ sudo 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 currentpassword for the root user. If you've just installed MariaDB, andyou 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): 设置root的密码1OK, successfully used password, moving on...Setting the root password ensures that nobody can log into the MariaDBroot user without the proper authorisation.You already have a root password set, so you can safely answer 'n'.Change the root password? [Y/n] n 是否改变密码:n不改变 ... skipping.By default, a MariaDB installation has an anonymous user, allowing anyoneto log into MariaDB without having to have a user account created forthem. This is intended only for testing, and to make the installationgo a bit smoother. You should remove them before moving into aproduction environment.Remove anonymous users? [Y/n] y 是否移除测试用户:y是的 ... Success!Normally, root should only be allowed to connect from 'localhost'. Thisensures that someone cannot guess at the root password from the network.Disallow root login remotely? [Y/n] y 是否允许root远程登录:n不允许 ... Success!By default, MariaDB comes with a database named 'test' that anyone canaccess. This is also intended only for testing, and should be removedbefore moving into a production environment.Remove test database and access to it? [Y/n] y 删掉测试数据库test:y删掉 - Dropping test database... ... Success! - Removing privileges on test database... ... Success!Reloading the privilege tables will ensure that all changes made so farwill take effect immediately.Reload privilege tables now? [Y/n] y 重新加载权限表:y重新加载 ... Success!Cleaning up...All done! If you've completed all of the above steps, your MariaDBinstallation should now be secure.Thanks for using MariaDB
3.查看MariaDB数据库服务状态 (这里也说明了MariaDB与其他Mysql数据库不能共存在同一操作系统)
dream361@ubuntu16:~$ sudo systemctl status mysql4.启动MariaDB数据库服务
dream361@ubuntu16:~$ sudo systemctl start mysql
3.设置mysql随系统服务启动
dream361@ubuntu16:~$ sudo update-rc.d mysql defaults4.撤销随系统服务启动
dream361@ubuntu16:~$ sudo update-rc.d -f mysql remove5.与之前版本mysql不同,需要获得操作系统管理员权限,才能登录MariaDB的root用户,普通操作系统用户不能登录MariaDB数据库root用户
dream361@ubuntu16:~$ sudo mysql -u root -p6.备份mysql数据库 也需要获得操作系统管理员才能执行备份
dream361@ubuntu16:~$ sudo mysqldump -uroot -p mysql >mysql.sql7.创建普通数据库用户 (登录普通数据库用户则不需要获得操作系统管理员权限)
create user 'henry'@'%' identified by '1';8.登录远地数据库(需要henry@'%')
dream361@ubuntu16:~$ mysql -h localhost -u henry -p1
9.修改MariaDB配置文件,监听外网访问
dream361@ubuntu16:~$ sudo vim /etc/mysql/mariadb.conf.d/50-server.cnf# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1 #注释掉这一行
10.重启数据库服务,使配置生效
dream361@ubuntu16:~$ sudo systemctl restart mysql
11.MariaDB版本
dream361@ubuntu16:~$ mysql -Vmysql Ver 15.1 Distrib 10.0.29-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
0 0
- 【Ubuntu16】apt-get安装MariaDB
- Ubuntu16.04安装mariadb
- ubuntu16.04下安装mariadb
- ubuntu16.04 apt-get 速度慢问题
- ubuntu16.04apt-get错误解决
- Ubuntu16.04:sudo apt-get update
- Ubuntu16 apt 安装mysql5.7
- apt-get 安装QT4
- apt-get 安装 sunjdk
- apt-get安装卸载
- apt-get安装opencv
- centos 安装 apt-get
- apt-get安装jdk
- apt-get安装mysql
- centos 安装apt-get
- Ubuntu16.04下Mongodb(离线安装方式|非apt-get)安装部署步骤(图文详解)
- Debian Oracle apt-get 安装
- 安装JDK1.6: apt-get
- 科普:手机的各种传感器原理及用途
- 并查集--hdu1272(并查集的应用)
- java常用集合总结
- 深入理解拉格朗日乘子法(Lagrange Multiplier) 和KKT条件
- AVD Manager 加载虚拟设备出错-Error: User nexus10.1 no longer exists as a device。
- 【Ubuntu16】apt-get安装MariaDB
- GYM 101086 M.ACPC Headquarters : AASTMT (Stairway to Heaven)(map)
- 使用ssm框架 通过ajax异步提交数据具体实现方法
- AndroidStudio2.2以上支持lambda
- GO channel类型
- linux下构建虚拟环境(virtualenv )安装tensorflow
- 彪悍的职业不惧阿尔法狗
- 关于rtmp中数据类型为0x16的封包
- 集合