CLI Databases Documentation

MDB CLI Databases Documentation

This guide will take you step by step on how to create and use databases using CLI


Create database - MySQL

Create database

1. Run the following command in the terminal:

        
            
              mdb database init
            
        
    

2. Choose mysql8

3. You will be asked to create new user. Hit Enter to accept.

4. Provide username, password, database name and description.

CLI will display your username, password, database name and connections string.

Note: Your final username and database name may differ from your inputs. MDB GO may add some characters to randomize username and database name.

5. Your database is ready to use.

Connect

PHP

        
            
              <?php
              $mysqli = new mysqli("mysql.db.mdbgo.com:3306","username","password","database_name");

              // Check connection
              if ($mysqli -> connect_errno) {
                echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
                exit();
              }
              ?>
            
        
    

Node.js

        
            
              var mysql = require('mysql');

              var con = mysql.createConnection({
                host: "mysql.db.mdbgo.com",
                port: "3306",
                user: "username",
                password: "password"
              });

              con.connect(function(err) {
                if (err) throw err;
                console.log("Connected!");
              });
            
        
    

Connect to MySQL using PHP

Connect to your database using PHP

Check following examples where you will find 3 different ways to connect to database using PHP using:

  • MySQLi - object-oriented
  • MySQLi - procedural
  • PDO (PHP Data Objects)

Each use case consist sample code for:

  • Database connection
  • Table creation
  • Data insertion
  • Data selection (SELECT statement)
  • Table deletion

Video tutorial:

        
            
                <!-- MySQLi  Object-Oriented -->

                <?php
                $servername = "mysql.db.mdbgo.com";
                $username = "your_username";
                $password = "your_password";
                $dbname = "db_name";

                // Create connection
                $conn = new mysqli($servername, $username, $password, $dbname);

                // Check connection
                if ($conn->connect_error) {
                  die("Connection failed: " . $conn->connect_error);
                }
                echo "Connected successfully  <br>";

                // Create Table 
                $sql = "CREATE TABLE MyGuests (
                  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
                  firstname VARCHAR(30) NOT NULL,
                  lastname VARCHAR(30) NOT NULL,
                  email VARCHAR(50),
                  reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
                )";

                if ($conn->query($sql) === TRUE) {
                  echo "Table MyGuests created successfully <br>";
                } else {
                  echo "Error creating table:  <br>" . $conn->error . "<br>";
                }

                // Insert data
                $sql = "INSERT INTO MyGuests (firstname, lastname, email)
                VALUES ('John', 'Doe', 'john@example.com')";

                if ($conn->query($sql) === TRUE) {
                  echo "New record created successfully  <br>";
                } else {
                  echo "Error: " . $sql . "<br>" . $conn->error;
                }

                // Query data
                $sql = "SELECT id, firstname, lastname FROM MyGuests";
                $result = $conn->query($sql);

                if ($result->num_rows > 0) {
                  // output data of each row
                  while ($row = $result->fetch_assoc()) {
                    echo "id: " . $row["id"] . " - Name: " . $row["firstname"] . " " . $row["lastname"] . "<br>";
                  }
                } else {
                  echo "0 results";
                }

                //Drop table
                $sql = "DROP TABLE MyGuests";

                if ($conn->query($sql) === TRUE) {
                  echo "Table MyGuests dropped successfully <br>";
                } else {
                  echo "Error dropping table:  <br>" . $conn->error . "<br>";
                }

                $conn->close();
              
        
    
        
            
                <!-- MySQLi  Object-Oriented -->

                <?php
                $servername = "mysql.db.mdbgo.com";
                $username = "your_username";
                $password = "your_password";
                $dbname = "db_name";

                // Create connection
                $conn = mysqli_connect($servername, $username, $password, $dbname);

                // Check connection
                if (!$conn) {
                  die("Connection failed: " . mysqli_connect_error() . "<br>");
                }
                echo "Connected successfully <br>";

                //Create table
                $sql = "CREATE TABLE MyGuests (
                  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
                  firstname VARCHAR(30) NOT NULL,
                  lastname VARCHAR(30) NOT NULL,
                  email VARCHAR(50),
                  reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
                )";

                if (mysqli_query($conn, $sql)) {
                  echo "Table MyGuests created successfully <br>";
                } else {
                  echo "Error creating table: " . mysqli_error($conn) . "<br>";
                }

                // Insert data
                $sql = "INSERT INTO MyGuests (firstname, lastname, email)
                VALUES ('John', 'Doe', 'john@example.com')";

                if (mysqli_query($conn, $sql)) {
                  echo "New record created successfully <br>";
                } else {
                  echo "Error: " . $sql . "<br>" . mysqli_error($conn) . "<br>";
                }

                // Query data
                $sql = "SELECT id, firstname, lastname FROM MyGuests";
                $result = mysqli_query($conn, $sql);

                if (mysqli_num_rows($result) > 0) {
                  // output data of each row
                  while ($row = mysqli_fetch_assoc($result)) {
                    echo "id: " . $row["id"] . " - Name: " . $row["firstname"] . " " . $row["lastname"] . "<br>";
                  }
                } else {
                  echo "0 results <br>";
                }

                //Drop table
                $sql = "DROP TABLE MyGuests";

                if (mysqli_query($conn, $sql)) {
                  echo "Table MyGuests dropped successfully <br>";
                } else {
                  echo "Error dropping table: " . mysqli_error($conn) . "<br>";
                }

                mysqli_close($conn);
              
        
    
        
            
                <!-- MySQLi  Object-Oriented -->

                <?php
                $servername = "mysql.db.mdbgo.com";
                $username = "your_username";
                $password = "your_password";
                $dbname = "db_name";

                try {
                  $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

                  // Create table

                  $sql = "CREATE TABLE MyGuests (
                    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
                    firstname VARCHAR(30) NOT NULL,
                    lastname VARCHAR(30) NOT NULL,
                    email VARCHAR(50),
                    reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
                  )";

                  if ($conn->query($sql)) {
                    echo "Table MyGuests created successfully <br>";
                  } else {
                    echo "Error creating table. <br> ";
                  }

                  //Insert data
                  $sql = "INSERT INTO MyGuests (firstname, lastname, email)
                  VALUES ('John', 'Doe', 'john@example.com')";
                  // use exec() because no results are returned
                  $conn->exec($sql);
                  echo "New record created successfully";

                  //Query data
                  $sql = "SELECT id, firstname, lastname FROM MyGuests";
                  $result = $conn->query($sql);
                  if ($result->rowCount() > 0) {
                    echo "<table><tr><th>ID</th><th>Name</th></tr>";
                    // output data of each row
                    while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
                      echo "<tr><td>" . $row["id"] . "</td><td>" . $row["firstname"] . " " . $row["lastname"] . "</td></tr>";
                    }
                    echo "</table>";
                  } else {
                    echo "0 results";
                  }

                  //Drop table
                  $sql = "DROP TABLE MyGuests";
                  if ($conn->query($sql)) {
                    echo "Table MyGuests dropped successfully <br>";
                  } else {
                    echo "Error dropping table. <br> ";
                  }
                } catch (PDOException $e) {
                  echo $sql . "<br>" . $e->getMessage();
                }

                $conn = null;
              
        
    

PHPMyAdmin access

MDB GO allows you to access your database using Graphical User Interface (GUI) - PHPMyAdmin.

1. In order to use it navigate to: phpmyadmin.mdbgo.com

2. Provide your username and password for the database you want to connect.

Note: You can check your username in your databases panel. If you forget your password you can also reset it here.

Video tutorial:


Create database - Mongo

Create database

1. Run the following command in the terminal:

        
            
              mdb database init
            
        
    

2. Choose mongodb

3. You will be asked to create new user. Hit Enter to accept.

4. Provide username, password, database name and description.

CLI will display your username, password, database name and connections string.

Note: Your final username and database name may differ from your inputs. MDB GO may add some characters to randomize username and database name.

5. Your database is ready to use.

Connect

Node.js

        
            
              async function main(){
                /**
                * Connection URI. Update <username>, <password>, and <your-cluster-url> to reflect your cluster.
                * See https://docs.mongodb.com/ecosystem/drivers/node/ for more details
                */
                const uri = "mongodb://username:password@mongo.db.mdbgo.com:port/database_name";
                const client = new MongoClient(uri);
            
                try {
                  // Connect to the MongoDB cluster
                  await client.connect();
          
                  // Make the appropriate DB calls
                  await  listDatabases(client);
                } catch (e) {
                  console.error(e);
                } finally {
                  await client.close();
                }
              }

              main().catch(console.error);
            
        
    

Reset database password - GUI

If you forget password your database you can easily set a new one.

1. Navigate to: databases panel

2. Find database which you want to update and click Edit button next to it

3. Provide a new password (and re-type new password), then submit.

Video tutorial:


Reset database password - CLI

If you forget password your database you can easily set a new one.

1. Open terminal and type the following command:

        
            
            mdb database config password
      
        
    

2. Choose a database from the list

3. Provide a new password (and re-type new password), then submit.

Video tutorial: