C++访问MySQL

1.安装mysql

  sudo apt-get install mysql-server mysql-client

安装过程中会提示设置用户名和密码

2.启动mysql
  sudo /etc/init.d/mysql restart

3.安装C++开发库
  sudo apt-get install libmysqlclient-dev

4.登录mysql，并创建表

mysql -u root -p

--表maxPromised

CREATE TABLE maxPromised(id BIGINT auto_increment primary key, lock_name varchar(128), instance_no BIGINT, ballot_no BIGINT, unique uniq_lock_num(`lock_name`,`instance_no`)) engine=innodb default charset=utf8;

--表maxAccepted

CREATE TABLE maxAccepted(id BIGINT auto_increment primary key, lock_name varchar(128), instance_no BIGINT, ballot_no BIGINT, usid char(37), val_len int, val_str varchar(128),unique uniq_lock_num(`lock_name`,`instance_no`)) engine=innodb default charset=utf8;

5.代码片段

#include <mysql/mysql.h>

//连接数据库