Why can't I connect to mysql with PHP

Question

1.00/5 (1 vote)

See more:

I am new to php/mysql and i want to simply connect to my database. When i run the code below on my server i get a http 500 error. I am hosting it on a Ubuntu server machine (not a virtual machine) with port 80 open. of course php and mysql server are installed.

What I have tried:

<?php
	$servername = "localhost";
	$username = "root";
	$password = "*******";


    mysql_connect($servername,$username,$password);
	echo "hi";
?>

Posted 1-Oct-18 5:21am

Member 13915301

Updated 1-Oct-18 7:31am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2018-10-01T06:20:00

Solution 1

See PHP: mysql_connect - Manual[^]. Port 80 is HTTP, MySQL uses port 3306 by default.

Posted 1-Oct-18 6:20am

Richard MacCutchan

Comments

Member 13915301 1-Oct-18 12:22pm

i have also forwarded 3337 (for mysql)

Richard Deeming 3-Oct-18 13:12pm

That sounds like a really bad idea. Do you really want every hacker on the planet trying to guess your MySQL root password?

The only thing that needs to talk to MySQL is the code running on the server. If the PHP code is running on the same computer as MySQL, there should be no need to open the MySQL port at all.

Member 13915301 3-Oct-18 16:54pm

ok i closed the port, do you know why my code doesn't work?

Richard MacCutchan 4-Oct-18 4:07am

Sorry no, how could I with so little information? You need to do some debugging to find out what is happening in your server code.

summiya1 · Answer 2 · 2018-10-01T07:32:00

Solution 2

use

mysqli_connect(host,username,password,db)

instead of mysql_connect

Posted 1-Oct-18 7:32am

summiya1