关于MySql

1、出现的错误提示：

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7
Failed to connect to root mysql admin
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open

查了一下数据库：

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| doorcontrolserver  |
| mydata             |
| mysql              |
| performance_schema |
+--------------------+
5 rows in set (0.00 sec)

数据库版本：

Server version: 5.6.10 MySQL Community Server (GPL)

如何解决？

C:\Windows\system32>mysqld --install
Service successfully installed.

编译后仍然报错。

在https://blog.csdn.net/imred/article/details/73732411看到只要将libmysql.dll拷贝到QT的BIN目录下编译即可。尝试了，成功了！下面是编译后的结果。编译关于数据库的测试程序参考http://www.qter.org/portal.php?mod=view&aid=51这里。

open
2 "xiaoming"
3 "xiaohong"