基礎(chǔ)概念

dql -select
dml -insert update delete
ddl -create table create view
dcl -grant

安裝步驟（centos7）

• sudo yum install mysql mysql-server
  sudo yum -y install mysql-server(centos6)
• sudo vim /etc/my.cnf
• 修改文件增加，default-character-set = utf8
• 啟動(dòng)mysql
  systemctl start mysqld

centos6啟動(dòng)
service mysqld start

• 設(shè)置隨系統(tǒng)啟動(dòng)
  systemctl enable mysqld
  systemctl daemon-reload

centos6中設(shè)置隨系統(tǒng)啟動(dòng)
sudo chkconfig mysqld on
sudo chkconfig --list mysqld

• 登錄mysql
  mysql -u root

• 查看用戶
  select user,host from mysql.user;

• 刪除匿名用戶
  delete from mysql.user where user='';

• 刷新權(quán)限
  flush privileges;

• 防火墻開(kāi)放3306端口
  sudo vim /etc/sysconfig/iptables
  -A INPUT -p tcp -m tcp --dport 3306 -j ACCEPT

• 重啟防火墻
  sudo systemctl restart iptables.service
  sudo service iptables restart(centos6)

• 新建用戶(7會(huì)報(bào)錯(cuò)，原因未知)
  insert into mysql.user(Host,User,Password) values("localhost","qinxianyun",password("qinxianyun"));

• 創(chuàng)建數(shù)據(jù)庫(kù)(是數(shù)字鍵1左邊的小點(diǎn)，用單引號(hào)會(huì)報(bào)錯(cuò)) create databasemmall` default character set utf8 collate utf8_general_ci;

• 查看權(quán)限
  select * from mysql.user \G

• 授權(quán)
  grant all privileges on mmall.* to qinxianyun@'%' identified by 'qinxianyun' with grant option;

• 為root用戶設(shè)置密碼
  set password for root@localhost=password('admin123');
  set password for root@127.0.0.1=password('admin123');
  select user,host,password from mysql.user;
  set password for root@localhost.localdomain=password('admin123');

• 授權(quán)遠(yuǎn)程訪問(wèn)（能訪問(wèn)可以不設(shè)置）
  use mysql;
  grant all privileges on . to root@'%' identified by "root";
  FLUSH RIVILEGES;