linux下安装mysql

mysql

1、检查是否安装
yum list installed | grep mysql

2、下载安装包
wget

3、解压并拷贝到安装目录
tar -xvf mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz
ln -s path-to-mysql /usr/local/mysql

4、创建data目录
mkdir /data/mysql

5、创建用户组及用户
groupadd mysql
useradd -r -g mysql -s /bin/false mysql

6、改变目录所有者
chown -R mysql:mysql /data/mysql
chown -R mysql:mysql /usr/local/mysql

7、拷贝配置文件
cp -a /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

# These are commonly set, remove the # and set as required.
basedir = /usr/local/mysql
datadir = /data/mysql
port = 3306
# server_id = .....
socket = /tmp/mysql.sock
character-set-server = utf8
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

8、初始化数据库
bin/mysqld --initialize --user=mysql

9、创建软连接
ln -s /usr/local/mysql/bin/mysql  /usr/local/bin/

10、创建系统服务
cp -a /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

11、创建systemctl服务
vi /usr/lib/systemd/system/mysqld.service
[Unit]
Description=MySQL Server
After=network.target
After=syslog.target

[Service]
User=mysql
Group=mysql
Type=forking
PermissionsStartOnly=true
ExecStart= /etc/init.d/mysqld start
ExecStop= /etc/init.d/mysqld stop
ExecReload= /etc/init.d/mysqld restart
LimitNOFILE = 5000

[Install]
WantedBy=multi-user.target

12、重新加载服务
systemctl daemon-reload

13、修改用户密码

SET PASSWORD = PASSWORD('root');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
use mysql;
select User,authentication_string,Host from user;
UPDATE user SET `Host` = '%' WHERE `User` = 'root' LIMIT 1;
FLUSH PRIVILEGES;