MySQL with Beziersql

Processing Libraries
1

Hi, I’m trying to use Processing with MySQL using the BezierSQL library but it isn’t working. I entered the password, user, database, and host correctly and it still says SQL.connect(): Could not connect to the database ( jdbc:mysql://127.0.0.1/lab8 )

import de.bezier.data.sql.*;

MySQL db;

void setup()
{
    size( 100, 100 );
    String host = "127.0.0.1";
    String user = "root";
    String pass = "penguin";
    String database = "lab8";
    db = new MySQL( this, host, database, user, pass  );  // open database file
    db.setDebug(false);

    if ( db.connect() )
    {
        String[] tableNames = db.getTableNames();
        
        db.query( "SELECT * FROM %s", tableNames[0] );
        
        while (db.next())
        {
            TableOne t = new TableOne();
            db.setFromRow( t );
            println( t );
        }
}
2

Welcome. Which version of Processing and what OS are you using? Did you run any of the MySQL example code and did it work correctly?