code:
#include <mysql/mysql.h>
#include <my_global.h>
int main(int argc, char **argv)
{
MYSQL *conn;
conn = mysql_init(NULL);
mysql_real_connect(conn, "localhost", "zetcode", "passwd", "testdb", 0, NULL, 0);
mysql_query(conn, "use vobd_db");
mysql_query(conn, "select * from obd_call_status limit 10")
this program works
Code:
#include <mysql++.h>
#include <iostream>
#include <iomanip>
using namespace std;
MYSQL *connection, mysql;
MYSQL_RES *result;
MYSQL_ROW row;
int query_state;
int main() {
mysql_init(&mysql);
Hi all
I am trying to access mysql through a c program, bt am stuck with a specific error.
The story:
A couple days ago I had created a new database and added a table to it using phpMyAdmin running on the Chrome browser. I then attempted to do something else, don't remember what, using the same software, when Chrome crashed.
I then could not get into the database using my name.
Hi all, I have a basic question on MySQL:
http://de.php.net/manual/en/ref.pdo-mysql.php
"Use --with-pdo-mysql[=DIR] to install the PDO MySQL extension, where the optional [=DIR] is the MySQL base install directory."
Which file should be used for that command?
edit: think it's mysql, but I'm getting "Access denied for user 'root'@'localhost' (using password: YES)".
Hello
I've just installed R for the first time, along with DBI, Rmysql packages - all from package manager (using Kubuntu at the moment).
I can't connect to mysql:
Code:
con1 <-dbConnect(MYSQL(), user="myname", password="mypassword", host="localhost", dbname="casualty")
error in evaluating the argument 'drv' in selecting a method fo
I'm trying to setup Simple Machines Forum which uses MySQL, which I had installed but it wasn't being used for anything.I forgot the passwords and what not and figured it would be easiest to just start fresh, so I purged all mysql stuff and installed again.It won't start now. It says "Starting MySQL database server: mysqld . . . . . . . . . . . . . .
Show the output from
$ mysql -u root -p -e "show variables" | grep -i conn
[by TrevorH]
Hi,
I moved my ubuntu server install from dynamic to static IP.
Email this page
