Connect MySQL Database to Command-Line OR PHP Script

Connect MySQL Database to Command-Line OR PHP Script

In this article, You will learn how to connect mysql using command line (CMD) and also learn how to connect MySQL using php script.

You can use the MySQL command to quick and easy way to access your databases directly.

Table of Contents

  • MySQL Connect Using CMD
  • Using PHP Script For MySQL Connect

MySQL Connect Using CMD

To connect MySQL from the command line, Use the following steps :-

Log in to your Hosting account using SSH.

On the command line, write the following command, replace USERNAME to your USERNAME :-

mysql -u USERNAME -p

Enter Password

At the password prompt, type your password. When you type the correct password, mysql> prompts are displayed.

To See List of Database

To display a list of databases, Use the below command at the mysql> prompt :-

show databases;

Use Database

To access a specific database, use the following command at the mysql> prompt, and also replace the DBNAME with the database you your database name :-

use DBNAME;

Accessed Database

After accessing the database, you can run SQL queries, list tables and so on. apart from this :-

  • To see a list of MySQL commands, type help at mysql> prompt.
  • To exit the Mysql program, type \ q at mysql> prompt.

Using PHP Script For MySQL Connect

PHP provides mysql_connect() function to open a database connection. This function takes five parameters and returns a MySQL link identifier on success or FALSE on failure.

Syntax

mysql_connect(host,username,password,new_link,client_flag);

Host

The host name that runs the database server If not specified, the default value will be localhost.

username

Username accessing the database If not specified, the default will be the name of the user who is the owner of the server process.

password

The default value is defined by mysql.default_password. In SQL safe mode, this parameter is ignored and blank password is used.

new_link

If mysql_connect () is called with other arguments, then no new connection will be established; Instead, the identifier of the previously open connection will be returned.

client_flags

  • MYSQL_CLIENT_SSL – Use SSL encryption.
  • MYSQL_CLIENT_COMPRESS – Use Compression Protocol.
  • MYSQL_CLIENT_IGNORE_SPACE – Allow the location after the function names.
  • MYSQL_CLIENT_INTERACTIVE – Allow passive seconds of idle time before closing connection.
  • Example For MySQL Connection

Example of connection to a MySQL Database :−

<?php
$host= "localhost";
$username = "username";
$password = "password";

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

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

mysqli_close($conn);
?>

Leave a Reply

Your email address will not be published. Required fields are marked *