MySQL使用笔记

rpm -ivh mysql-community-common-5.7.17-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.17-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.17-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.17-1.el7.x86_64.rpm

cp /usr/share/mysql/my-default.cnf /etc/my.cnf
vi /etc/my.cnf

[mysqld]datadir=/data/mysql/data/
socke=/data/mysql/mysql.sock
server_id=1
[mysql.server]
user=mysql

groupadd mysql
useradd -r -g mysql mysql

mkdir -p /data/mysql/data/
chown -r mysql:mysql /data/mysql/

mysqld --initialize --user=mysql --datadir=/data/mysql/data/

service mysqld start

让root用户可以远程访问
CREATE USER 'root'@'服务器IP' IDENTIFIED BY '123456';
CREATE USER 'root'@'%' IDENTIFIED BY '123456';
GRANT ALL ON *.* TO 'root'@'%';
GRANT ALL ON *.* TO 'root'@'localhost';

通过root用户新增一个数据库test

创建新用户，密码为123456
CREATE USER 'test'@'服务器IP' IDENTIFIED BY '123456';
CREATE USER 'test'@'%' IDENTIFIED BY '123456';
CREATE USER 'test'@'localhost' IDENTIFIED BY '123456';

赋予访问的test库下的所有权限
GRANT ALL ON test.* TO 'test'@'服务器IP';
GRANT ALL ON test.* TO 'test'@'%';
GRANT ALL ON test.* TO 'test'@'localhost';

生效权限
Flush privileges

即可通过Navicat for MySQL远程通过3306端口登陆并管理test数据库了


append these two lines to /etc/security/limits.conf

mysql hard nofile 65535
mysql soft nofile 65535
append this line to /usr/lib/systemd/system/mysqld.service (in the [service] section)

LimitNOFILE=65535

CentOS升级到7之后，使用firewalld代替了原来的iptables
1. Disable Firewalld Service.
# systemctl mask firewalld
2. Stop Firewalld Service.
# systemctl stop firewalld