数据库学习（入门篇）

数据库学习（入门篇）

1. 入门资料

《SQL必知必会（第四版）》 <https://www.linuxidc.com/Linux/2017-03/141517.htm>、
《SQL学习指南（第二版）》 <https://download.csdn.net/download/bestsheng1996/9207525>、
《MYSQL必知必会》 <https://www.linuxidc.com/Linux/2016-04/129853.htm>

2. 安装使用

下载地址和安装指导

Download MySQL Community Server（官方）——下载
<https://dev.mysql.com/downloads/mysql/>
Installing MySQL on Unix/Linux Using Generic Binaries（官方）——安装指导
<https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html>

2.10 Postinstallation Setup and Testing
<https://dev.mysql.com/doc/refman/5.7/en/postinstallation.html>
2.10.1.1 Initializing the Data Directory Manually Using mysqld
<https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html>
2.10.1 Initializing the Data Directory
<https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html>
2.10.2 Starting the Server
<https://dev.mysql.com/doc/refman/5.7/en/starting-server.html>
2.10.3 Testing the Server
<https://dev.mysql.com/doc/refman/5.7/en/testing-server.html>
2.10.4 Securing the Initial MySQL Accounts
<https://dev.mysql.com/doc/refman/5.7/en/default-privileges.html>
2.10.5 Starting and Stopping MySQL Automatically
<https://dev.mysql.com/doc/refman/5.7/en/automatic-start.html>

4.9 MySQL Program Environment Variables
<https://dev.mysql.com/doc/refman/5.7/en/environment-variables.html>
6.3 MySQL User Account Management
<https://dev.mysql.com/doc/refman/5.7/en/user-account-management.html>

中文安装指导

MySQL5.7 linux二进制安装 <http://www.cnblogs.com/chenmh/p/5413881.html>
Linux下MySQL的安装、配置、使用（1） <https://www.linuxidc.com/Linux/2017-10/147460.htm>
Linux下MySQL的安装、配置、使用（2） <https://www.linuxidc.com/Linux/2017-10/147460p2.htm>

数据库的创建和导入

MySQL如何创建数据库并导入数据文件（Linux）
<https://blog.csdn.net/xiaoboliu0602/article/details/%5BDownload%20MySQL%20Community%20Server%E5%AE%98%E7%BD%91%5D%28https://dev.mysql.com/downloads/mysql/%29>
MySQL必知必会，执行create.sql脚本文件，用populate.sql文件填充各个新表
<https://blog.csdn.net/hukangqiang/article/details/79319525>

3. 问题解决

MySQL启动报file don’t existst错误
<http://www.talkwithtrend.com/Question/233281-1417989>
MySQL报错:–initialize specified but the data directory has files in it. Aborting.
<https://blog.csdn.net/QwQ_QAQ/article/details/73733150>

• « 上一篇：Python编写一个简单的百度搜索应用
• » 下一篇：CentOS7修改主机名的三种方法