Calendars
- Before Christ (B.C.) 代表纪元前,Anno Domini (A.D.) 代表纪元后。
- 联合国采用公元Before the Common Era (B.C.E.) 和 Common Era (C.E.)
- 公元525年,基督教神学家狄奥尼修斯·伊希格斯建议将耶稣生年定为纪元元年,以取代当时罗马教廷所采用的“戴克里先历”
Equator
Ecliptic
Equinox
A solar equinox is a moment in time when the Sun crosses the Earth’s equator, which is to say, appears directly above the equator, rather than north or south of the equator.
- 3月20日
- 9月23日
Solstice
A solstice is an event that occurs when the Sun appears to reach its most northerly or southerly excursion relative to the celestial equator on the celestial sphere.
- 6月21日
- 12月22日
安装 MySQL
Linux yum 安装
1 | wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm |
Linux rpm 安装
1 | cd ~/download |
启动
1 | mysqld --user=root --init-file=/etc/my.cnf |
常见问题
Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
加上--force --nodeps
选项
/usr/sbin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
安装libaio即可yum install libaio -y
[ERROR] –initialize specified but the data directory has files in it. Aborting.
rm -rf /var/lib/mysql/
注意
- 安装之前查看是否存在已安装的mysql rpm,如果已安装需要移除
- 此方法安装的mysql目录是分散的
Linux 源码安装
Installing MySQL on Microsoft Windows Using a noinstall ZIP Archive
https://dev.mysql.com/doc/refman/5.7/en/windows-install-archive.html
MySQL 5.6 for Windows 解压缩版配置安装_百度经验
https://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html
How to Install MySQL on CentOS 7
https://www.linode.com/docs/databases/mysql/how-to-install-mysql-on-centos-7
Linux 源码编译安装MySQL 5.7
https://itbilu.com/database/mysql/VJVOut01M.html
Windows 安装
下载
MySQL5.7 32位
https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.20-win32.zip
MySQL5.7 64位
https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-winx64.zip
步骤
解压mysql-5.7.20-win32.zip文件到安装目录
创建选项文件,推荐存放于C:\etc\mysql5.7.ini,内容如下
1 | [mysqld] |
- 初始化数据库
1 | mysqld --defaults-file=c:\usr\mysql\mysql5.7\my.ini --initialize |
- 启动
1 | mysqld --defaults-file=c:\usr\mysql\mysql5.7\my.ini |
注册服务(不推荐)
1 | cmd进入mysql bin文件夹 |
启动bat
1 | cd C:\aneat\usr\mysql\mysql5.7\bin |
注意
- 如果缺少 msvcr120.dll、msvcp120.dll,复制缺少文件至c:\windows\system32(64位程序)和c:\windows\syswow64(32位程序),jdk1.8下有这两个文件
- mysql5.6不需要创建选项文件my.ini、初始化数据库这些操作(可以直接解压后运行)
- mysql5.7默认创建数据库无初始化用户参考 [2.配置MySQL —— MySQL5.7启动服务成功后无用户可登录]