yum update升级以后的系统版本为

1. Mac Start Mariadb Command
2. Mac Start Mariadb Pro

AomeiTech is a data backup & restore software. It provides a disk partition manager that helps you with protecting data safe and managing hard drives. It supports various versions of Windows OS such as Windows 10, Windows 8.1, Windows 7, Vista, and XP for 32 or 64 bit. Creating a Data Source with MariaDB Connector/ODBC on Mac OS X. Mac OS X uses iODBC as a Driver Manager. To create a data source on Mac OS X, there are two primary ways to do it: You can create a data source with the iODBC Administrator GUI tool. You can create a data source by manually editing the iODBC configuration file.

Mar 08, 2021 Start working with your data source by creating a connection to it. Run a query: Connect an SQL file to a data source and run your code. View results: Connect an SQL file to a data source and run your code. Export/Import: Import and export your data to and from various formats with or without special tools like mysqldump, pgdump, pgrestore. The open-source MySQL, PostgreSQL, mariaDB, Embedded Apache Derby (Java DB), mSQL (mini-SQL), SQLite, Apache OpenOffice's Base, and mongoDB (non-relational). Structure Query Language (SQL) A high-level programming language, called Structure Query Language (SQL), is designed for interacting with the relational databases. This is a prerequisite for installing SQL Server on your Mac. Because the Mac runs SQL Server inside a Docker container, the first thing we need to do is download and install Docker (unless it's already installed). Once installed, we'll increase its memory allocation to a more suitable level for running SQL Server.

一般网上给出的资料都是

安装mysql和mysql-devel都成功，但是安装mysql-server失败，如下：

查资料发现是CentOS 7 版本将MySQL数据库软件从默认的程序列表中移除，用mariadb代替了。

有两种解决办法：

1、方法一：安装mariadb

MariaDB数据库管理系统是MySQL的一个分支，主要由开源社区在维护，采用GPL授权许可。开发这个分支的原因之一是：甲骨文公司收购了MySQL后，有将MySQL闭源的潜在风险，因此社区采用分支的方式来避开这个风险。MariaDB的目的是完全兼容MySQL，包括API和命令行，使之能轻松成为MySQL的代替品。

安装mariadb，大小59 M。

mariadb数据库的相关命令是：

systemctl start mariadb #启动MariaDB

systemctl stop mariadb #停止MariaDB

systemctl restart mariadb #重启MariaDB

systemctl enable mariadb #设置开机启动

所以先启动数据库

然后就可以正常使用mysql了

安装mariadb后显示的也是 MariaDB [(none)]> ，可能看起来有点不习惯。下面是第二种方法。

2、方法二：官网下载安装mysql-server

安装成功后重启mysql服务。

初次安装mysql，root账户没有密码。

设置密码

不需要重启数据库即可生效。

在mysql安装过程中如下内容：

所以安装完以后mariadb自动就被替换了，将不再生效。

1、编码

mysql配置文件为/etc/my.cnf

最后加上编码配置

这里的字符编码必须和/usr/share/mysql/charsets/Index.xml中一致。

2、远程连接设置

把在所有数据库的所有表的所有权限赋值给位于所有IP地址的root用户。

如果是新用户而不是root，则要先新建用户

此时就可以进行远程连接了。

本文作者starof,因知识本身在变化，作者也在不断学习成长，文章内容也不定时更新，为避免误导读者，方便追根溯源，请诸位转载注明出处：http://www.cnblogs.com/starof/p/4680083.html有问题欢迎与我讨论，共同进步。

Mac Start Mariadb Command

Mac Start Mariadb Pro