Linux安装Mysql

1.下载安装包

wget http://dev.MySQL.com/get/Downloads/MySQL-5.7/mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz

2.新建目录

mkdir /usr/local/mysql

mkdir /usr/local/mysql/data

3.解压安装包并复制

tar -xvf mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz

mv mysql-5.7.11-linux-glibc2.5-x86_64/* /usr/local/mysql/

4.创建mysql用户及用户组

groupadd mysql

useradd -r -g mysql mysql

5.进入/usr/local/mysql/目录并初始化数据

./bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

6.先复制内容到/etc/my.cnf，再修改/etc/my.cnf配置文件为如下

cp -a ./support-files/my-default.cnf /etc/my.cnf (选择y)

[mysqld]

#datadir=/var/lib/mysql

#主要配置

basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
socket=/tmp/mysql.sock
character-set-server = utf8
#socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

 

 

 

[mysqld_safe]

 

 

 

#注释

#log-error=/var/log/mariadb/mariadb.log
#pid-file=/var/run/mariadb/mariadb.pid

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

#
# include all files from the config directory
#

!includedir /etc/my.cnf.d

7.创建软链接

ln -s /usr/local/mysql/  /usr/bin/

8.启动Mysql服务

cp -a ./support-files/mysql.server /etc/init.d/mysqld

service mysqld start

8.初始化密码

mysql5.7会生成一个初始化密码，在root中.mysql_secret文件中。

cat /root/.mysql_secret

9.登录并且修改密码

mysql -u root -p
alter user root@localhost identified by 'root';

flush privileges;

10.退出重新登录

11.让远程客户端连接数据库

更改加密方式：

ALTER USER 'root'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; 

更改密码：该例子中 123为新密码

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

刷新

FLUSH PRIVILEGES;

需要确认root用户的host是否为%，否则会报错。可以修改root用户的host为%，但需要刷新权限。

https://blog.csdn.net/q258523454/article/details/84555847

12.docker运行mysql数据库

docker run --name first-mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=A1B2c3d4 -v /data/mysql:/var/lib/mysql -d mysql

 

参考文章

1.Linux下安装MySQL数据库(压缩包方式安装)

https://www.cnblogs.com/xiaotao726/p/6562265.html

2.用命令创建MySQL数据库

https://www.cnblogs.com/jiangxiaobo/p/7089345.html