Thread: access denied!

i am starting to learn to connect a cprogram to a mysql database.

i have got this elementary program to connect to server , create a database and disconnect from it.

Code:

#include <stdio.h>
#include<windows.h>
#include <mysql.h>
static char *opt_host_name = NULL; /* server host (default=localhost) */
static char *opt_user_name =NULL; /* username (default=login name) */
static char *opt_password = NULL; /* password (default=none) */
static unsigned int opt_port_num = 0; /* port number (use built-in value) */
static char *opt_socket_name = NULL; /* socket name (use built-in value) */
static char *opt_db_name = NULL; /* database name (default=none) */
static unsigned int opt_flags = 0; /* connection flags (none) */
static MYSQL *conn; /* pointer to connection handler */
int
main (int argc, char *argv[])
{
/* initialize connection handler */
conn = mysql_init (NULL);
if (conn == NULL)
{
fprintf ( stderr,"mysql_init() failed (probably out of memory)\n");
exit (1);
}
/* connect to server */
if (mysql_real_connect (conn, opt_host_name, opt_user_name, opt_password,
opt_db_name, opt_port_num, opt_socket_name, opt_flags) == NULL)
{
fprintf (stderr, "mysql_real_connect() failed:\nError %u (%s)\n",
mysql_errno (conn), mysql_error (conn));
mysql_close (conn);
exit (1);
}

//create database
if (mysql_query(conn, "create database firstdata")) {
      printf("xxxError %u: %s\n", mysql_errno(conn), mysql_error(conn));
      exit(1);
  }

/* disconnect from server */
mysql_close (conn);
exit (0);
}

but, when i execute it there is error message

Code:

access denied for user ''@'localhost'to database firstdata.

please help!

Looks like you have something in there that needs either an actual IP Address or the name of the host computer.

Don't know about Linux but on Windows... a computer's name, a computer's IP address and Localhost are three different things.

I'm far from an expert on MySQL, but I would bet you haven't properly configured database users and/or permissions. Also note that you have an empty user name. That may not be equivalent to anonymous access, and/or you may not have anonymous access allowed.