賦予權限：

grant 權限1,權限2,…權限n on 數據庫名稱.表名稱 to 用戶名@用戶地址 identified by ‘連接口令’;

grant all privileges on keyword.* to wanmei@10.3.254.90 identified by 'pwrd';

表示允許10.3.254.90上， -u wanmei -p pwrd發起的請求。

/usr/local/mysql5.5/bin/mysql -h mysql_server_host -u wanmei? -P 3307 -ppwrd 連接上。

插入

char *server = "10.3.254.18";char *user = "wanmei";char *password = "pwrd"; char *database = "keyword";int port=3307; conn = mysql_init(NULL);char *insert_sql = "insert into pre_forum_post(tid, subject, message) values(%u, \"%s\", \"%s\")";char *query_sql = "select pid, tid, subject, message from pre_forum_post";/* Connect to database */if (!mysql_real_connect(conn, server,user, password, database, port, NULL, 0)) {fprintf(stderr, "connect error: %s\n", mysql_error(conn));exit(0);}char *buf = new char[1024*1024];

查詢。。

/* Connect to database */if (!mysql_real_connect(conn, server.c_str(), user.c_str(), password.c_str(), dbname.c_str(), port, NULL, 0)) {fprintf(stderr, "connect error: %s\n", mysql_error(conn));exit(0);}char sqlbuf[256];int start = dealcount;while(1) {sprintf(sqlbuf, query_sql, tablename.c_str(), start, step);printf("get... %s\n", sqlbuf);if (mysql_query(conn, sqlbuf)){fprintf(stderr, "%s\n", mysql_error(conn));exit(0);}res = mysql_use_result(conn);

總結

以上是生活随笔為你收集整理的mysql notes的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。