What's wrong with that ?

[frenchcelt]

Hi,
As it seems my db are lost, i try to restore my last save of wordpress (exported from it).
Account name : celt
Remote host : int.boru.x10hosting.com
New db : wordpress2 - user added with all permissions : celt
http://celt.x10hosting.com/testbdd.php contains :
mysql_connect("localhost", "celt_celt", "******") or die(mysql_error());
echo "Connected to MySQL";
mysql_select_db("wordpress2") or die(mysql_error());
echo "Connected to Database";

result is :
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'celt_celt'@'10.33.248.75' (using password: YES) in /home/celt/public_html/testbdd.php on line 2
Access denied for user 'celt_celt'@'10.33.248.75' (using password: YES)

Could you help please please please ?

 

[Derek]

Did you give the user and database all permissions?

 

[frenchcelt]

hi Derek,
I gave the user all permissions, in case of i forgot, i did it again right now
all permissions to database ?

 

[Anna]

Hello,

Your site loads up just fine for me, so I guess you managed to sort it?

I did find three databases with your nametag on them, would you like us to restore them or are you good to go with your own backup?

 

[frenchcelt]

Hello Anna,
my backup isn't full, i lost data... i restored them on an external mysql host temporarely that doesn't run phpmyadmin
if you're able to restore my wordpress database it'd be really really great, don't bother with the other 2
i dunno how to thank you enough !!!

 

[Anna]

Hello,

I have restored the database. You'll need to re-created/re-add the user to it though.

 

[frenchcelt]

Thank you very much Anna !!!
Unfortunately, i still got a problem with access denied to mysql
I changed the test file that can be seen here :
http://celt.x10hosting.com/testbdd.php
I dont know where's the problem, but thanks to you i got my full db back

 

[Anna]

I added a couple entries to the remote host table, your test file now works.

 

[frenchcelt]

it now works with the 2 remote hosts you added
http://celt.x10hosting.com/?p=395
thank you for everything !!!

 

[Anna]

Hello,

Glad it works for you now. Since this has been resolved I'll close the thread.

You are welcome to submit a new support request if you need any further assistance.