4.2.5. MySQL connection

Example ¶

The following is a simple example of connecting to a mysql server from the command line:

[root@host]# mysql -u root -p Enter password:****** 

After a successful login, a mysql > command prompt window appears, on which you can execute any SQL statement.

After the above command is executed, the successful login output is as follows:

Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2854760 to server version: 5.0.9 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. 

In the above example, we use root users to log in to the mysql server, but you can also log in with other mysql users.

If the user permissions are sufficient, any user can SQL from the command prompt window of mysql.

You can use the exit command to exit the mysql > command prompt window, as follows:

mysql> exit Bye 

Grammar ¶

mysqli_connect(host, username, password, dbname,port, socket); 

参数说明：

You can use PHP. mysqli_close() Function to break the link to the MySQL database.

Only one argument to this function is mysqli_connect() The MySQL connection identifier returned after the function successfully created the connection.

Grammar ¶

bool mysqli_close ( mysqli $link ) 

This function closes the non-persistent connection to the MySQL server associated with the specified connection identity. If not specified link_identifier Closes the last open connection

提示： There is usually no need to use the mysqli_close() Because open non-persistent connections are automatically closed after the script is executed

Example ¶

You can try the following example to connect to your MySQL server:

Connect MySQL