linux安装mysql

一、mysql下载

下载地址：https://dev.mysql.com/downloads/cluster/

cd ~
wget https://dev.mysql.com/get/Downloads/MySQL-Cluster-8.0/mysql-cluster-8.0.29-linux-glibc2.12-x86_64.tar.gz

二、mysql安装前置

为系统添加mysql用户和用户组

groupadd work    创建组
useradd -r -g work work  创建用户

解压

tar mysql-cluster-8.0.29-linux-glibc2.12-x86_64.tar.gz -C /home/work

进入解压目录

cd /home/work

创建目录

cd /home/work
mkdir data
mkdir relaylog
mkdir /home/work/mysql/run

授权

chown -R work:work /home/work/data
chown -R work:work /home/work/relaylog
chown -R work:work /home/work/mysql

添加/etc/my.cnf文件

[client]
default-character-set=utf8
socket=/home/work/mysql/run/mysql.sock

[mysqld]
user = work 
port = 3306
basedir=/home/work/mysql
datadir=/home/work/data
socket=/home/work/mysql/run/mysql.sock
pid-file=/home/work/mysql/run/mysqld.pid
#Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
lower_case_table_names = 1
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
server-id = 2         
log-bin = mysql-bin-1     
sync_binlog = 1
binlog_checksum = none
binlog_format = mixed
auto-increment-increment = 1
auto-increment-offset = 1    
slave-skip-errors = all
binlog-do-db=setdatabase

#--------password----------#
#plugin-load=validate_password.so
#validate_password_policy=1
#validate-password=FORCE_PLUS_PERMANENT

#--------max_connect----------#
#max_connect_errors=5
#max_connections=200
#max_user_connections=100


#-----slow_query_log-----#
slow_query_log=TRUE
slow_query_log_file=/home/work/log/mysql-slow.log
long_query_time=2

#-----general_log------#
#general_log=1

[mysqld_safe]
log-error=/home/work/data/err.log

########my.cnf内容结束

三、mysql初始化

初始化安装

cd /home/work/mysql
bin/mysqld --initialize --basedir=/home/work/mysql --lower-case-table-names=1 --datadir=/home/work/data/ --user=work

记住此密码，等会要登录用

拷贝启动文件

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

修改配置路径

vim /etc/init.d/mysqld
basedir=/home/work/mysql
datadir=/home/work/data

添加环境变量

echo 'export PATH=/home/work/mysql/bin:$PATH' >>/etc/profile
source /etc/profile

添加开机自启动

chmod +x /etc/init.d/mysqld 添加可执行权限
chkconfig --add mysqld 注册启动服务

启动服务

service mysql start

登录

mysql -uroot -p用初始化数据库时候的密码进入

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ABCD123457890*';
flush privileges; #刷新用户权限
exit:命令退出mysql，然后用修改后的新密码登录

初始化数据库

CREATE DATABASE database DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

使用数据库 use database;
导入数据库source /home/work/database.sql;

新增角色（只有增删改查权限）

创建新用户：testcjq 密码：ABC12345
CREATE USER 'testcjq'@'192.168.42.%' IDENTIFIED WITH mysql_native_password BY 'ABC12345';
授权
grant select,insert,update,delete on database.* to 'testcjq'@'192.168.42.%' with grant option;
刷新用户权限
flush privileges;