You can create a mysql database by using the php script.<\/p>\n
Example:<\/strong><\/p>\n [php]<?php \/\/ Create connection \/\/ Create database $conn->close(); Code explanation:<\/strong><\/p>\n In the code first, we are connecting php to the server by using server login details.<\/p>\n \/\/ Create connection Once the server is connection we have used the mysql query statement to create a database on the server.<\/p>\n To verify it we are using if statement. The if statement checks whether the connection to the server is successfully achieved by using the In the end, we are closing the php script with the closing function.<\/p>\n You can create a mysql database by using the php script. Example: [php]<?php $servername = "localhost"; $username = "username"; $password = "password"; \/\/ Create connection<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-371","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts\/371","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/comments?post=371"}],"version-history":[{"count":1,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts\/371\/revisions"}],"predecessor-version":[{"id":372,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/posts\/371\/revisions\/372"}],"wp:attachment":[{"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/media?parent=371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/categories?post=371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mddir.com\/how-to\/wp-json\/wp\/v2\/tags?post=371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n$servername = "localhost";
\n$username = "username";
\n$password = "password";<\/p>\n
\n$conn = new mysqli($servername, $username, $password);
\n\/\/ Check connection
\nif ($conn->connect_error) {
\n die("Connection failed: " . $conn->connect_error);
\n} <\/p>\n
\n$sql = "CREATE DATABASE myDB";
\nif ($conn->query($sql) === TRUE) {
\n echo "Database created successfully";
\n} else {
\n echo "Error creating database: " . $conn->error;
\n}<\/p>\n
\n?>[\/php]<\/p>\n$servername = \"localhost\";
\n$username = \"username\";
\n$password = \"password\";<\/p>\n
\n$conn = new mysqli($servername, $username, $password);
\n\/\/ Check connection
\nif ($conn->connect_error) {
\n die(\"Connection failed: \" . $conn->connect_error);
\n} <\/code><\/p>\n$sql = \"CREATE DATABASE myDB\";<\/code><\/p>\n$conn<\/code> variable. Then it checks the $sql<\/code> query with the operator identical check ===<\/code> is true. If everything is run ok the echo statement “Database created successfully” is proceed to the browser else the error message “Error creating the database: ” with the connection error. The $conn->error<\/code> is shown to the browser.<\/p>\nif ($conn->query($sql) === TRUE) {
\n echo \"Database created successfully\";
\n} else {
\n echo \"Error creating database: \" . $conn->error;
\n}<\/code><\/p>\n$conn->close();<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"