Can't connect to MySQL server by php code

[beamblues50]

Hi. I have created a database and a user with their respective password. In my php code I have:

$link = mysql_connect('localhost', 'my_user_name', 'my_password');
if (!$link) {exit;}
echo 'Connected successfully<br>';
$db_selected = mysql_select_db('my_database_name', $link);
if (!$db_selected) {
die (mysql_error());}

Then the result is:

Connected successfully
Access denied for user 'my_user_name'@'localhost' to database 'my_database_name'

I'll tried add in cPanel Remote Database: 69.175.6.94, init.fris.x10hosting.com, and stoli.x10hosting.com, without improvement. The strangle is that by MyPHPadmin I can access and create/alter tables. Somebody can help me?

Thanks,

 

[descalzo]

Exactly what is the db name? Are you sure it is correct? Did you add the DB user to the DB with all privileges?

 

[beamblues50]

My database is "marnel_sd". In the cPanel icon MySQL databases, I didn't discovered the options for the setting privileges; where are there?

 

[descalzo]

cPanel --> MySQL Databases
When you add a DB user to a DB, a screen pops up and you must check ALL_PRIVILEGES

 

[beamblues50]

I have just created two new users. In no one I saw something with this for check this option..

 

[Dead-i]

So is your problem fixed?

Also, this was documented in the Wiki, plus the MySQL Database Wizard guides you through the process step-by-step
http://x10hosting.com/wiki/How_to_Create_a_MySQL_Database_and_User

 

[descalzo]

cPanel --> MySQL Databases
When you add a DB user to a DB, a screen pops up and you must check ALL_PRIVILEGES

Not when you create it.

 

[beamblues50]

Very extrangle. I have created other new user, this time using the Internet Explorer and not the Firefox. And again also never appear the options for ALL PRIVILEGES. Am I making a mistake in something??

 

[gomarc]

Hi beamblues50,

If you are using MySQL® Databases (not the Wizard)

At the bottom of the page, do you have the “Add User To Database”?

You need to click on the Add button to set the privileges, as descalzo pointed out.

 

[beamblues50]

Hi beamblues50,

If you are using MySQL® Databases (not the Wizard)

At the bottom of the page, do you have the “Add User To Database”?

You need to click on the Add button to set the privileges, as descalzo pointed out.

It's seems that already yet working!! Thanks you very much

---------- Post added at 05:34 PM ---------- Previous post was at 05:33 PM ----------

It's seems that already yet working!! Thanks you very much.