第一步:安装 qt 开发环境
xhy@xhy-desktop:~$sudo apt-get install qt4-dev-tools qt4-doc qt4-qtconfig qt4-demos qt4-design
er
第二步:安装 mysql 开发环境
xhy@xhy-desktop:~$sudo apt-get install mysql-server mysql-client
xhy@xhy-desktop:~$sudo apt-get install libmysqlclient15-dev
xhy@xhy-desktop:~$sudo apt-get install libqt4-sql-mysql
xhy@xhy-desktop:~$sudo /etc/init.d/mysql restart
第三步:给普通用户授权操作数据库
xhy@xhy-desktop:~$ mysql -u root -p (root登录数据库 )
mysql> create database mydb; (创建一个数据库 )
mysql> grant all privileges on *.* to username@localhost
identified by 'password';
mysql> quit;
给特定用户分配数据操作权限的格式是 :
grant 权限 1,权限 2,...权限 n on 数据库名称 .表名称 to 用户名 @用户 ip地址 identified by '密
码';
第四步:测试环境
#include <QApplication>
#include <QtSql>
#include <QTableView>
#include <iostream>
using namespace std;
int main(int argc, char *argv[])
{
QApplication app(argc, argv);
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setDatabaseName("mydb");
db.setUserName("username");
db.setPassword("password");
db.open();
QSqlQuery query;
query.exec("create table hello(id bigint not null auto_increment,name varchar(255),age
bigint,primary key (id))");
/*query.exec("insert into hello(name, age) values('xiaoxi', 18)");
query.exec("insert into hello(name, age) values('xiaonan', 19)");
query.exec("insert into hello(name, age) values('xiaobei', 20)");