读书人

Qt连接MySql数据库有关问题

发布时间: 2012-08-03 00:12:14 作者: rapoo

Qt连接MySql数据库问题
Qt连接MySql数据库的时候,报这样的错误:
"Access denied for user 'root'@'LBDZ-08140011' (using password: YES) QMYSQL: Unable to connect"。

我上网查了一下,别人说的是密码用户名和密码有误。

我这里有点小疑惑,想问一下:

我在安装mysql的时候没有设置用户名这一项,网上说用户名是默认的root,密码就是自己设置的密码,是这样吗?

如果是的话那我在连接mysql数据库的时候,用户名和密码都没错啊,这个问题又该怎样解决?

[解决办法]
百度知道的结果,自己没有mysql,没法试希望对你有帮助。
http://zhidao.baidu.com/question/358079555.html
[解决办法]
MySQL的用户权限是分的很清的,
要新建一个用户,要为该用户赋予网络的权限才行。
[解决办法]
打开mysql:

use mysql;
select * from user where user='root'\G;

看一下host限制了谁。

C/C++ code
mysql> use mysqlDatabase changedmysql> describe user;+------------------------+-----------------------------------+------+-----+---------+-------+| Field                  | Type                              | Null | Key | Default | Extra |+------------------------+-----------------------------------+------+-----+---------+-------+| Host                   | char(60)                          | NO   | PRI |         |       || User                   | char(16)                          | NO   | PRI |         |       || Password               | char(41)                          | NO   |     |         |       || Select_priv            | enum('N','Y')                     | NO   |     | N       |       || Insert_priv            | enum('N','Y')                     | NO   |     | N       |       || Update_priv            | enum('N','Y')                     | NO   |     | N       |       || Delete_priv            | enum('N','Y')                     | NO   |     | N       |       || Create_priv            | enum('N','Y')                     | NO   |     | N       |       || Drop_priv              | enum('N','Y')                     | NO   |     | N       |       || Reload_priv            | enum('N','Y')                     | NO   |     | N       |       || Shutdown_priv          | enum('N','Y')                     | NO   |     | N       |       || Process_priv           | enum('N','Y')                     | NO   |     | N       |       || File_priv              | enum('N','Y')                     | NO   |     | N       |       || Grant_priv             | enum('N','Y')                     | NO   |     | N       |       || References_priv        | enum('N','Y')                     | NO   |     | N       |       || Index_priv             | enum('N','Y')                     | NO   |     | N       |       || Alter_priv             | enum('N','Y')                     | NO   |     | N       |       || Show_db_priv           | enum('N','Y')                     | NO   |     | N       |       || Super_priv             | enum('N','Y')                     | NO   |     | N       |       || Create_tmp_table_priv  | enum('N','Y')                     | NO   |     | N       |       || Lock_tables_priv       | enum('N','Y')                     | NO   |     | N       |       || Execute_priv           | enum('N','Y')                     | NO   |     | N       |       || Repl_slave_priv        | enum('N','Y')                     | NO   |     | N       |       || Repl_client_priv       | enum('N','Y')                     | NO   |     | N       |       || Create_view_priv       | enum('N','Y')                     | NO   |     | N       |       || Show_view_priv         | enum('N','Y')                     | NO   |     | N       |       || Create_routine_priv    | enum('N','Y')                     | NO   |     | N       |       || Alter_routine_priv     | enum('N','Y')                     | NO   |     | N       |       || Create_user_priv       | enum('N','Y')                     | NO   |     | N       |       || Event_priv             | enum('N','Y')                     | NO   |     | N       |       || Trigger_priv           | enum('N','Y')                     | NO   |     | N       |       || Create_tablespace_priv | enum('N','Y')                     | NO   |     | N       |       || ssl_type               | enum('','ANY','X509','SPECIFIED') | NO   |     |         |       || ssl_cipher             | blob                              | NO   |     | NULL    |       || x509_issuer            | blob                              | NO   |     | NULL    |       || x509_subject           | blob                              | NO   |     | NULL    |       || max_questions          | int(11) unsigned                  | NO   |     | 0       |       || max_updates            | int(11) unsigned                  | NO   |     | 0       |       || max_connections        | int(11) unsigned                  | NO   |     | 0       |       || max_user_connections   | int(11) unsigned                  | NO   |     | 0       |       || plugin                 | char(64)                          | YES  |     |         |       || authentication_string  | text                              | YES  |     | NULL    |       |+------------------------+-----------------------------------+------+-----+---------+-------+ 

读书人网 >C++

热点推荐