管理mysql数据库常用方式_MySQL管理_数据库常用命令

1.数据库赋权

进入mysql数据库：

mysql>use mysql;

给root用户设置新密码：

mysql> update user set password=password("新密码") where user="root";

刷新数据库

mysql>flush privileges;

nagios监控

mysql> GRANT PROCESS, REPLICATION CLIENT ON *.* TO 'nagiosshow'@'10.172.172.12' IDENTIFIED BY PASSWORD '*79B36E3D5F430AF5B15934D61D71C031B6502834';

查看用户信息

use mysql;

select User,Host,Password from user;

查看用户权限

show grantsfor root@'localhost';

删除用户

delete user form user where Host='xxxx' and User='xxxx';

查看用户与权限

GRANT ALL PRIVILEGES ON *.* TO 'midlis'@'%' IDENTIFIED BY 'midlis24' WITH GRANT OPTION;USEmysql;CREATE USER 'midlis@%' IDENTIFIED BY 'midlis24';CREATE USER 'midlis' IDENTIFIED BY 'midlis24';select User,Host,Password from user;

创建用户

2.新建数据库

查看已有用户：

mysql>use mysql;

mysql>select Host,User,Password from user;

新建数据库

CREATE DATABASE marketing_baseDEFAULTCHARACTER SET utf8 COLLATE utf8_general_ci;

新建用户并赋权

grant all privileges on marketing_base.* to dysql@'%' identified by '1Qaz2wsx';

mysql-uroot -p123456 --default-character-set=gb2312 test

mysql-uroot -p1qaz2wsx --default-character-set=utf8 ryp_production < cnapsbank.sql

新建数据库

3.导出数据库

导出数据时排除某些表的数据