Connection to MySQL DB problem

[drxela]

Hello, everyone... Well, I got a problem to... understand how work the connection of my MySql DB, I tried many things but nothing was good, got problem on sql connect, on db select, etc...

So I want to know what is the good username to use, and name of DB, for my SQL

I give you my connexion.php, maybe you can explain me my errors...

-----------------------------

<?php
$hostname = 'localhost';
$user = 'drxela_kamas';
$password = '******';
$nom_base_donnees = 'drxela_kamasBD';

$conn = mysql_connect($hostname, $user, $password) or die('Erreur de connexion '.mysql_error());

mysql_select_db($nom_base_donnees, $conn) or die('Erreur de selection '.mysql_error());
?>

----------------------------

Like you see here, I create a DB, named 'kamasBD' that x10 named 'drxela_kamasBD' on the cPanel.

It's same for the user, and I gave to him all privilieges.

And in my .php, I call this connexion.php like that :

include('connexion.php');

Something bad ? I must do require ?

Thanks for any help about this.

 

[drxela]

Someone can look if something is bad ? With this one, I got only a DB selection error (Acces denied error).

And now I have a strange bug :

#1129 - Host 'int.starka.x10hosting.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

Someone knows what this means ? And how fix it ?

Thanks for any help.

 

[includes]

I have same problem

 

[xtrain]

I have the same problem since this evening.

Warning: mysql_connect() [function.mysql-connect]: Host 'int.starka.x10hosting.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' in <path>/tr_sms_param.php on line 26

It seems the db is flushed away...
How could I use "mysqladmin flush-hosts"? I tried inside a perl file, but...

Are there any problems on servers?

Thank you.

Regards,
Alex

 

[mattaperry]

Hey, The SQL servers are being changed or something, either way best thing to do is just be patiant.

For confidence, I have exactly the same problem.
Starka server an all

 

[drxela]

More fear, I see no DB in my Cpanel, and my DB limit is back at 0/3

>.< That bad, I wish they got a save of all DB

Anyone can help about my personnal problem of connect (on the first message)?

 

[mattaperry]

Surfed the other posted, the DBs shud return once it sorts its-self out

 

[xtrain]

Hey, The SQL servers are being changed or something, either way best thing to do is just be patiant.

For confidence, I have exactly the same problem.
Starka server an all

Ok, thank you.
...I was just reading other on that.
Many servers seem involved...uhmmm!...

Alex

 

[drxela]

Help me, plz, It's really boring to be unable to continue my work cause of a stupid error...

I have do all things like it's needed and I get this errors :

Access denied for user 'drxela_kamas'@'int.starka.x10hosting.com' to database 'drxela_kamasBD'

 

[drxela]

I can have a answer ?

Thanks.

 

[zmstrike]

MySQL Error
Message: Can not connect to MySQL server
SQL:
Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Errno.: 2002​

also my connection speed is very low to the server
i hope db wont be lost

 

[Derek]

MySQL Error
Message: Can not connect to MySQL server
SQL:
Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Errno.: 2002​

also my connection speed is very low to the server
i hope db wont be lost

Db should not be lost.

 

[zmstrike]

Db should not be lost.

i hope and what is exactly wrong with server ? and when will it be fixed ?

 

[coolmark18]

I can have a answer ?

Thanks.

Its been said before. The MySQL server is done. You just need to wait till its fixed. Yes its annoying but its annoying for everyone. If you want 99.9% upkeep, head to a paid service.