ubuntu测试mysql安装成功_Linux下（ubuntu 10.04）安装测试Mysql

Linux下(ubuntu 10.04)安装测试Mysql：

1.安装Mysql：

sudo apt-get install mysql-server mysql-client

2.安装Musql开发包：

sudo apt-get install libmysqlclient5-dev

3.重启Mysql服务器：

sudo /etc/init.d/mysql restart

4.授权普通用户操作数据库：

mysql -u root -p(回车输入密码后登录mysql)

mysql>create database mytestdb;

mysql>grant all privileges on *.* to xxx@localhost identified by '123456';(123456为密码，XXX为允许操作数据库的用户名)

mysql>quit;

5.测试代码(C)：

#include

#include

#include

#include

#define SQLMAX 1024

int main(void)

{

MYSQL mysql;

char sql[SQLMAX];

mysql_init(&mysql);

if(mysql_real_connect(&mysql,"localhost","XXX","123456","mytestdb",MYSQL_PORT,NULL,0)==NULL)

{printf("cannot connect");exit(1);}

snprintf(sql,SQLMAX,"create table student(num int,name char(20))");

if(mysql_real_query(&mysql,sql,strlen(sql)))

printf("create failure:%s\n",sql);

snprintf(sql,SQLMAX,"insert into student values(100,'xiaodong')");

if(mysql_real_query(&mysql,sql,strlen(sql)))

printf("insert failure%s\n",sql);

snprintf(sql,SQLMAX,"insert into student values(101,'xiaonan')");

if(mysql_real_query(&mysql,sql,strlen(sql)))

printf("insert failure%s\n",sql);

snprintf(sql,SQLMAX,"select * from student");

if(mysql_real_query(&mysql,sql,strlen(sql)))

printf("insert failure:%s\n",sql);

mysql_close(&mysql);

return 0;

}

编译命令：gcc test.c -o test $(mysql_config --cflags) $(mysql_config --libs)