Mysql 安装

当前平台主要有四种，分别是Windows、Mac、Linux、Windows Server。对于Mac和Linux我更加推荐使用Docker进行安装，Windows及Windows Server 推荐使用StudyPHP，或者WAMP。

Windows、Windows Server

Mysql的下载连接

MySQL :: Download MySQL Installer (Archived Versions)

Please note that these are old versions. New releases will have recent bug fixes and features! To download the latest release of MySQL Installer, please visit MySQL Downloads. MySQL open source software is provided under the GPL License.

https://downloads.mysql.com/archives/installer/

源码安装

下载页面链接

MySQL :: Download MySQL Community Server

MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts. MySQL Cluster Community Edition is available as a separate download.

https://dev.mysql.com/downloads/mysql/

进入文件下载存放位置


cd [文件存放位置]

解压压缩包，并移动文件


tar -xvf [下载的文件]
mv [解压后的目录名称] /usr/local/mysql


mkdir -p /data/mysql

创建mysql的用户、组和目录，并禁止登录


groupadd mysql
useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql


chown -R mysql /usr/local/mysql
chgrp -R mysql /usr/local/mysql
chown -R mysql /data/mysql

配置参数


/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

💡

此处需要注意记录生成的临时密码，如上文结尾处的：YLi>7ecpe;YP

💡

如果报错”bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory“ 请执行 yum install libaio*

💡

如果报错“bin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory” 请执行 yum -y install numactl

设置RSA


/usr/local/mysql/bin/mysql_ssl_rsa_setup  --datadir=/data/mysql

修改系统配置文件


cd /usr/local/mysql/support-files
cp my-default.cnf /etc/my.cnf
cp mysql.server /etc/init.d/mysql
vim /etc/init.d/mysql
# 添加以下内容
basedir=/usr/local/mysql
datadir=/data/mysql

启动Mysql


# /etc/init.d/mysql start

--登陆

# mysql -hlocalhost -uroot -p

　　--如果出现：-bash: mysql: command not found

　　--就执行： # ln -s /usr/local/mysql/bin/mysql /usr/bin --没有出现就不用执行

--输入第6步生成的临时密码

--修改密码

mysql> set password=password('root');

--设置root账户的host地址（修改了才可以远程连接）

mysql>grant all privileges on *.* to 'root'@'%' identified by 'root';
mysql>flush privileges;

--查看表

mysql> use mysql;
mysql> select host,user from user;

--这里就可以使用远程连接测试了；

Docker 安装

创建存储卷


docker volume create mysql

💡

这里一定要创建存储卷，方便日后的数据存储及交换

创建并运行容器，并挂载存储卷


docker container run -p 3306:3306 --mount source=mysql,destination=/var/lib/mysql -v /etc/localtime:/etc/localtime -e MYSQL_ROOT_PASSWORD=liona..bnc --name mysql -d mysql:5.7