access denied
Posted by: Aaron Kerti
Date: June 12, 2012 06:47PM

Hi, I'm using the c api and trying to access data off my mysql server(which is remote). When I try to connect it says access denied for user. How do I fix this? Is it something wrong with my server or code?

#include "stdafx.h"
#include <iostream>

#include <my_global.h>
#include <mysql.h>

using namespace std;

int main()
{
MYSQL *conn;
MYSQL_RES *result;
MYSQL_ROW row;

std::cout << "start" << std::endl;

conn = mysql_init(NULL);

if(conn == NULL)
{
std::cout << "failed to initialize connection" << std::endl;
}

mysql_real_connect(conn, "216.51.232.61", "username", "password", "a1298_userAccounts", 0, "2082", 0);
cout << mysql_error(conn) << endl;

int query_result = mysql_query(conn, "SELECT * FROM UserAccounts");
std::cout << query_result << std::endl;

result = mysql_store_result(conn);

while ((row = mysql_fetch_row(result)))
{
std::cout << row[2] << std::endl;

if(row[2] == "shadyvillian")
{
if(row[3] == "a")
{
std::cout << "login successful" << std::endl;
}
}

}

mysql_free_result(result);
mysql_close(conn);

}

Options: ReplyQuote


Subject
Written By
Posted
access denied
June 12, 2012 06:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.