查看linux服务器上使用的端口：
netstat -aptn
安装前检查以下包：
[root@localhost bin]# rpm -qa|grep numactl
[root@localhost bin]# rpm -qa|grep libaio
检查是否安装了mysql：
[root@localhost /]# rpm -qa | grep mysql
[root@localhost /]# rpm -e mysql
1、添加系统mysql组和mysql用户
groupadd mysql
useradd -r -g mysql mysql （添加完成后可用id mysql查看）
2、创建目录和文件
mkdir -p /usr/local/mysql
mkdir -p /usr/local/mysql/data
mkdir -p /usr/local/mysql/log
3、将安装包解压到指定路径
tar -xzvf mysql-5.7.28-el7-x86_64.tar.gz -C /usr/local/mysql
mv mysql-5.7.28-linux-glibc2.12-x86_64/* /usr/local/mysql --要移动一下
4、更改mysql文件的用户和分组
cd /usr/local/mysql
chown -R mysql:mysql ./
5、修改/etc/my.cnf配置文件
ms11:
[mysqld]
character_set_server=utf8
init_connect=‘SET NAMES utf8’
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock
lower_case_table_names = 1
explicit_defaults_for_timestamp=true

Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0log-error=/usr/local/mysql/log/mysqld.log
pid-file=/usr/local/mysql/data/mysqld.pid

Group Replication

server_id = 1253306
gtid_mode = ON
enforce_gtid_consistency = ON
master_info_repository = TABLE
relay_log_info_repository = TABLE
binlog_checksum = NONE
log_slave_updates = ON
log_bin = binlog
binlog_format= ROW
transaction_write_set_extraction = XXHASH64
loose-group_replication_group_name = ‘ce9be252-2b71-11e6-b8f4-00212844f856’
loose-group_replication_start_on_boot = off
loose-group_replication_local_address = ‘192.168.1.11:33061’
loose-group_replication_group_seeds
=‘192.168.1.11:33061,192.168.1.12:33062,192.168.1.13:33063’
loose-group_replication_bootstrap_group = off
[client]
socket = /usr/local/mysql/mysql.sock
6、初始化MySQL
/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize-insecure –
basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/ --user=mysql
cat /usr/local/mysql/log/mysqld.log会生成一个临时密码，后面登录数据库时需要用
到。
7、添加开机启动
echo “PATH=$PATH:/usr/local/mysql/bin” >> /etc/profile
source /etc/profilecp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
8、启动MySQL(或者直接路径启动/usr/local/mysql/support-files/mysql.server start)
service mysqld start
9、登录后修改上面初始化时的密码(可跳过，可直接输入mysql)
mysql -uroot -p
–输入生成的临时密码
修改密码：
flush privileges; #刷新权限
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘Of123456’;
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘Of123456’ WITH GRANT
OPTION; #授权新用户
flush privileges; #刷新权限
修改root密码：
mysql> set password for root@localhost = password(‘Of123456’); 上面例子将用户
root的密码更改为root ；

命令启动/关闭/重启MySQL实例
service mysqld start/stop
service mysqld restart
查看mysql临时密码信息：
sudo grep ‘temporary password’ /usr/local/mysql/log/mysqld.log
TCP 连接(如果报错 /tmp/mysql.sock，你可以尝试这种方式连接)
mysql -uroot -h 127.0.0.1 -p
mysql免密登陆：
/usr/local/mysql/bin/mysqld_safe --user=mysql–datadir=/usr/local/mysql --skipgrant-tables --skip-networking &一、报错：ERROR 1862 (HY000): Your password has expired. To log in you must
change it using a client that supports expired passwords.
解决方法：
1、 用忽略授权表的方法进入mysql
vi /etc/my.cnf
[mysqld]
skip-grant-tables
:wq! #保存退出
2、重启mysql：
service mysqld restart
3、重新登录mysql：
mysql -uroot -p
4、修改密码：
flush privileges;
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘Of123456’;
5、进入mysql删除“skip-grant-tables”
6、重启mysql：
service mysqld restart
7、重新登录mysql：
mysql -uroot -p
基本查询
1、进入mysql数据库
root@test:/home# mysql -uroot -proot <uroot是用户名，proot是密码>
2、查询所有的库
mysql> show databases;
3、进入数据库“eduyun_2015_sp1”是库名
mysql> use eduyun_2015_sp1;
4、查询所有的表
mysql> show tables;
创建表：
mysql> create table lisi(id int);
创建数据库：
MySQL [(none)]> create database test;删除数据库：
MySQL [(none)]> drop database test;