文档介绍：测试服务器
$ mysql –u root mysql
如果得出mysql>提示符，服务器就正常运行了。
修改管理员密码:
$ mysqladmin –u root password newpassword
登入管理员帐号
创建新用户
创建来自192168181网段的登入
5．创建并使用数据库
6创建表格
7 添加信息到表格里
二 c语言访问mysql数据库
1以用户名neusoft和密码neusoft来连接本机服务器上名为neusoftdb的数据库
例程1：
#include <stdlibh>
#include <stdioh>
#include “mysqlh”
int main(int argc, char *argv[])
{
MYSQL *conn_ptr;
conn_ptr = mysql_init(NULL);
if (!conn_ptr) {
fprintf(stderr, “mysql_init failed\n”);
return EXIT_FAILURE;
}
conn_ptr = mysql_real_connect(conn_ptr, “localhost”, “neusoft”, “neusoft”, “neusoftdb”, 0, NULL, 0);
if (conn_ptr)
{
printf(“Connection success\n”);
}
else
{
printf(“Connection failed\n”);
}
mysql_close(conn_ptr);
return EXIT_SUCCESS;
}
编译命令为 $gcc –I /usr/include/mysql connect1c –lmysqlclient –o connect1
执行： $ /connect1
Connection success
$
2 反馈连接失败错误
例程2：
#include <stdlibh>
#include <stdioh>
#include “mysqlh”
int main(int argc, char *argv[])
{
MYSQL my_connection;
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, “localhost”, “neusoft”, “ “, “neusoftdb”, 0, NULL, 0))
{
printf(“Connection success\n”);
mysql_close(&my_connection);
}
else
{
fprintf(stderr, “Connection failed\n”);
if (mysql_errno(&my_connection))
{
fprintf(stderr, “Connection error %d: %s\n”, mysql_errno(&my_connection), mysql_error(&my_connection));
}
}
return EXIT_SUCCESS;
}
执行：
$ /connect2
Connection filed
Connection error 1045: Access denied for user: ‘******@localhost’ (Using password: YES)
$
3 插入数据操作
#include <stdlibh>
#include <stdioh>
#include “mysqlh”
int main(int argc, char *argv[])
{
MYSQL my_connection;
int res;
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, “localhost”, “neusoft”, “neusoft”, “neusoftdb”, 0, NULL, 0))
{
printf(“Connection success\n”);
res = mysql_query(&my_connection, “INSERT INTO children(fna