Connect to OceanBase Database by using the EXT driver

sudo yum install php
sudo yum install php-mysql

[root]# php -v
PHP 5.4.16 (cli) (built: Dec 13 2015 00:05:14)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies

[root]# vim obtest.php
<?php
$servername = "172.30.xxx.xxx";
$port = "2881";
$username = "root@mysql";
$password = "xxxx";
$dbname = "test";

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

// Check whether the connection is successful
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connection succeeded";
?>

[root]# php obtest.php
PHP Warning:  mysqli_connect(): (42000/1045): Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES) in /home/admin/obtest.php on line 9
Connection failed: Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)

[root]# php obtest.php
Connection succeeded

[root]# vim obtest.php
<?php
$servername = "172.30.xxx.xxx"; // Server address
$port = "2881";
$username = "root@mysql001"; // Username
$password = "xxxxxxx"; // Password
$dbname = "test"; // Name of the database to connect to

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

// Check whether the connection is successful
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

// Create a 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 is created successfully";
} else {
    echo "Table creation error: " . mysqli_error($conn);
}

// Insert data
$sql = "INSERT INTO myguests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";
if (mysqli_query($conn, $sql)) {
    echo "New record is inserted successfully";
} else {
    echo "Data insertion error: " . mysqli_error($conn);
}

// Close the connection
mysqli_close($conn);
?>

[root]# php obtest.php
Table myguests is created successfully. New record is inserted successfully. id: 1 - Name: John Doe<br>Table myguests is deleted successfully.