数据库的相关语句
mysql的图形化管理工具从mysql下载 mysql tool 5.0;
在安装网站之前主要是创建好数据库;
请一句一句执行;
1 create database dp character set utf8;
2 create user dpuser identified by 'dpuser';
3 create user dpuser@localhost identified by 'dpuser';
4 insert into mysql.db(host,Db,User,Select_priv,Insert_priv, Update_priv,Delete_priv,Create_priv, Drop_priv) values('localhost', 'zte',
'zteuser', 'Y','Y','Y','Y','Y','Y')
5 insert into mysql.db(host,Db,User,Select_priv,Insert_priv, Update_priv,Delete_priv,Create_priv, Drop_priv) values('%', 'zte',
'zteuser', 'Y','Y','Y','Y','Y','Y')
6 grant all privileges on zte.* to 'zteuser'@'localhost'
7 grant all privileges on zte.* to 'zteuser'@'%';
OK 数据库建好了。