[RESOLVED] how to "create" or "make" Schema

[micha_eleric]

i thought setSchema("mydatabase"); create mydatabase, but it does not.
what c++ code will create mydatabase?
everything i find, just connects to mydatabase.

[VictorN]

CREATE DATABASE

[micha_eleric]

CREATE DATABASE

create database using cpp?

[VictorN]

create database using cpp?

Again: you have to send SQL command with "CREATE DATABASE ..." to your DBMS.
See also https://www.google.com/search?q=CREA...t=gws-wiz-serp

[micha_eleric]

one of the videos somehow ran, but did not have a type before function def, guessing it was suppose to be void.

const char* database = "cppdb";
conn = mysql_real_connect(conn, hostname, username, password, database, port, unixsocket, clientflag);

but database is not created until after mysql_real_connect is called. based on function not having type before def, maybe video is missing something.

createdatabase(MYSQL* conn) is called using conn from mysql_real_connect.

[micha_eleric]

001 Create a Database from the ground up in C++, is so blurry, no clue what code is, all the way to the end

[micha_eleric]

answer to question is: mysql_query(conn, "CREATE DATABASE mydatabase"); , but has to have a database to create a database. mysql is there by default

#include <iostream>
#include <mysql.h>

const char* hostname = "localhost";
const char* username = "root";
const char* password = "";
const char* database = "mysql"; // has to have a database to create a database. mysql is there by default
unsigned int port = 3306;
const char* unixsocket = NULL;
unsigned long clientflag = 0;

MYSQL* connectdatabase()
{
MYSQL* conn;
conn = mysql_init(0);
conn = mysql_real_connect(conn, hostname, username, password, database, port, unixsocket, clientflag);
if(conn)
{
std::cout << "Connected " << conn << std::endl;
return conn;
}
else
{
std::cout << "not connected " << conn << std::endl;
return conn;
}
}


int main(int argc, char *argv[])
{
MYSQL* conn = connectdatabase();
mysql_query(conn, "CREATE DATABASE mydatabase");
return 0;
}

[micha_eleric]

found

int mysql_create_db(MYSQL *mysql, const char *db)

highlights like development environment recognizes it, but is not found by compiler

[VictorN]

... has to have a database to create a database.

You probably meant "has to have a DBMS to create a database". Didn't you?

[micha_eleric]

You probably meant "has to have a DBMS to create a database". Didn't you?

only if database named "mysql" is a DBMS.
"mysql" was shown when "MariaDB [(none)]> SHOW DATABASES;"

[VictorN]

only if database named "mysql" is a DBMS.
"mysql" was shown when "MariaDB [(none)]> SHOW DATABASES;"

[micha_eleric]

MariaDB [(none)]> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mydatabase |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.001 sec)