配置MySQL数据库

22312312

yum -y install mysql-server

#用yum安装MySQL数据库
rpm -qa | grep mysql
#确认已经安装的MySQL

mysql-5.1.73-7.el6.x86_64
mysql-libs-5.1.73-7.el6.x86_64
mysql-server-5.1.73-7.el6.x86_64
#已经安装MySQL的RPM包
service mysqld start
#启动服务
chkconfig mysqld on

#把该服务加入开机自启
mysql -u root -p
#用root用户登录到数据库


mysql>
show databases; #显示数据库列表
create database mydata; #建立数据库mydatainsert into mysql.user(Host,User,Password) values('localhost','admin',password('123456')); #新建账户admin，密码123456grant all on mydata.* to 'admin'@'%' identified by '123456' with grant option; #允许账户admin从任何主机连接到数据库mydata


flush privileges; #刷新系统授权表



至此，账号admin对数据库mydata具有完全管理权限。
mysql>









========================================================================
扩展：
grant all on mydata.* to 'admin'@'192.168.1.1' identified by '123456' with grant option;
#账户admin只能从192.168.1.1连接到数据库mydata
grant all on mydata.* to 'admin'@'localhost' identified by '123456' with grant option;
#账户admin只能从本机连接到数据库mydata
update mysql.user set password=password(1234) where User="admin" and Host="localhost";
#修改账号admin密码为1234
revoke all on mydata.* from 'admin'@'%';
#禁止用户admin从任何主机访问数据库mydata
revoke all on mydata.* from 'admin'@'192.168.1.1';
#禁止用户admin从192.168.1.1访问数据库mydata
daletefrom mysql.user whereuser="admin" and Host="localhost";
#删除用户admin
======================================================================