Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Connect to MySQL Severs with User Accounts
How To Connect to MySQL Severs with User Accounts? - MySQL FAQs - PHP Connections and Query Execution
✍: 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.
2007-05-10, 4773👍, 0💬
Popular Posts:
How To Control Table Widths? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells Usually, b...
What is a fish bone diagram ? Dr. Kaoru Ishikawa, invented the fishbone diagram. Therefore, it can b...
How To Create an Add-to-My-Yahoo Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS News ...
How do I force the Dispose method to be called automatically, as clients can forget to call Dispose ...
How To Write a Query with a Right Outer Join? - Oracle DBA FAQ - Understanding SQL SELECT Query Stat...