mysql 命令

查看字符集 show variables like 'collation_%'; 


创建数据库
    CREATE DATABASE test2 DEFAULT
    
    CHARACTER SET utf8 COLLATE utf8_general_ci;


查看当前数据库

select database();


  授权
CREATE USER 'larry'@'%' IDENTIFIED BY '123456'
GRANT ALL ON *.* TO 'larry'@'%' WITH GRANT OPTION;

  sudo /etc/init.d/mysql stop 停止
  sudo /etc/init.d/mysql start 启动