常用命令

创建用户

创建普通用户

为了保证数据库的安全性，主机 IP 避免使用%，可以分配一个 IP 地址的网段

  1. create user  用户名@主机ip identified by ‘密码’，

创建只读用户

create user 'r_mq'@'10.201.56.%' identified by '123456';
grant select on activemq.* to 'r_mq'@'10.201.56.%' identified by '123456';
flush privileges;

此时navicat连上之后只能看到activemq库，执行增删改会报错ip地址为 允许连server的客户端的ip有哪些

创建读写用户

create user 'r_mq'@'localhost' identified by '123456';
grant select,insert,update,delete on activemq.* to 'r_mq'@'localhost' identified by '123456';
flush privileges;

事务

查看当前 session 的隔离级别
8.0之前：select @@tx_isolation;
8.0之后：select @@transaction_isolation;

mysql体系结构与存储引擎

1.启动命令
[root@xufeng Desktop]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
2.关闭命令
[root@xufeng ~]# service mysqld stop
Redirecting to /bin/systemctl stop mysqld.service
3.重启命令
[root@xufeng ~]# service mysqld restart
Redirecting to /bin/systemctl restart mysqld.service

4.查看服务状态
[root@xufeng ~]# service mysqld status
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
Active: active (running) since Wed 2018-07-18 22:34:06 EDT; 1min 11s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 4366 ExecStart=/usr/sbin/mysqld —daemonize —pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
Process: 4345 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 4370 (mysqld)
CGroup: /system.slice/mysqld.service
└─4370 /usr/sbin/mysqld —daemonize —pid-file=/var/run/mysqld/mysqld.pid

Jul 18 22:34:04 xufeng.goertek.com systemd[1]: Starting MySQL Server…
Jul 18 22:34:06 xufeng.goertek.com systemd[1]: Started MySQL Server.
5.查看MySql系统配置
[root@xufeng ~]# cat /etc/my.cnf