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.
⇒ Accessing MySQL Server through Firewalls in MySQL
⇐ Connect to MySQL Server with Port Number in MySQL
2017-11-25, 1744🔥, 0💬
Popular Posts:
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...