MySQL创建仓库与删除仓库

MySQL创建仓库与删除仓库

MySQL如何创建数据仓库

CREATE DATABASE 数据仓库名;

数据库名称不要使用奇怪的或者特殊的符号，例如空格、路径符、引号

MySQL如何指派仓库权限给用户

GRANT 权限 ON databasename.tablename TO '用户名'@'范围'

删除库

DROP DATABASE 数据仓库名;

切换数据库

USE 数据仓库名;

用户、数据库、表等等，这些元素的创建，一般是不会有返回结果

仅仅有一个返回值，标明执行的结果是成功还是失败！

成功创建数据库之后，有了hello这个数据库

实例代码：

MYSQL* mysql = new MYSQL();

//MYSQL mysql;//占用的是栈上的内存

MYSQL* pDB = mysql_init(mysql);

if (pDB == NULL) {

std::cout << "mysql_init failed!" << std::endl;

return -1;

}

pDB = mysql_real_connect(pDB, "localhost", "root", "FengPan12#$56", "mysql", 3306, NULL, 0);

std::cout << pDB << std::endl;

if (pDB) {

std::string sql = "CREATE DATABASE hello";

int ret = mysql_real_query(pDB, sql.c_str(), (unsigned long)sql.size());

if (ret != 0) {

std::cout << "mysql error:" << mysql_error(pDB) << std::endl;

}

MYSQL_RES* result = mysql_use_result(mysql);

if (result != NULL) {

show_result(result);

std::cout << "===================================================" << std::endl;

mysql_free_result(result);

}

//授予权限

sql = "GRANT ALL ON hello.* TO 'hello'@'localhost';";

ret = mysql_real_query(pDB, sql.c_str(), (unsigned long)sql.size());

if (ret != 0) {

std::cout << "mysql error:" << mysql_error(pDB) << std::endl;

return -1;

}

result = mysql_use_result(mysql);

if (result != NULL) {

show_result(result);

std::cout << "===================================================" << std::endl;

mysql_free_result(result);

}

sql = "USE hello;";

ret = mysql_real_query(pDB, sql.c_str(), (unsigned long)sql.size());

if (ret != 0) {

std::cout << "mysql error:" << mysql_error(pDB) << std::endl;

return -1;

}

result = mysql_use_result(mysql);

if (result != NULL) {

show_result(result);

std::cout << "===================================================" << std::endl;

mysql_free_result(result);

}

sql = "DROP DATABASE hello;";

ret = mysql_real_query(pDB, sql.c_str(), (unsigned long)sql.size());

if (ret != 0) {

std::cout << "mysql error:" << mysql_error(pDB) << std::endl;

return -1;

}

result = mysql_use_result(mysql);

if (result != NULL) {

show_result(result);

std::cout << "===================================================" << std::endl;

mysql_free_result(result);

}

mysql_close(pDB);

}

delete mysql;

return 0;