MySQL笔记整理

初步安装

apt-get install mysql-server

创建数据库并指定编码

CREATE DATABASE `mydb` CHARACTER SET utf8 COLLATE utf8_general_ci;

use mysql;

select host,user from user;

create user username identified by ‘xxxxx’;

create database dbname;

一定要记得设置utf-8编码

管理某个数据库的权限

grant all privileges on dbname.* to username@’host’;

查看用户权限

show grants for

重启服务

flush privileges