Collections:
Connect to MySQL Server with User Account in MySQL
How To Connect to MySQL Server with User Accounts in MySQL?
✍: FYIcenter.com
If you want to connect a MySQL server with user account name and password, you need to call mysql_connect() with more parameters like this:
$con = mysql_connect($server, $username, $password);
If your MySQL server is provided by your Internet service company, you need to ask them what is the server hostname, port number, user account name and password. The following tutorial exercise shows you how to connect to a MySQL server, on host "localhost", at port "8888", with user account "dev", and with password "iyf":
<?php $con = mysql_connect('localhost:8888', 'dev', 'iyf'); if (!$con) { print("There is a problem with MySQL connection.\n"); } else { print("The MySQL connection object is ready.\n"); mysql_close($con); } ?>
If all parameters are correct, you should get a good connection object as shown in the following output:
The MySQL connection object is ready.
2017-11-25, 863👍, 0💬
Popular Posts:
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard ...