ruchit.devil Posted July 23, 2013 Share Posted July 23, 2013 I am trying to migrate my shop from localhost to live host. I had transferred all the files from my local drive to the host server via FTP file manager in the public_html folder. I had exported the database and imported it back to the live server and changed the settings.inc.php file. After doing all this, when i try to open up my site i get the following error. Link to database cannot be established: SQLSTATE[HY000] [1130] Host '119.18.50.60' is not allowed to connect to this MySQL server can someone please help me with this. Link to comment Share on other sites More sharing options...
vekia Posted July 23, 2013 Share Posted July 23, 2013 well, it looks like issue with database, maybe host address? try to use "localhost" as a host of your DB where you've got hosting? Link to comment Share on other sites More sharing options...
ruchit.devil Posted July 24, 2013 Author Share Posted July 24, 2013 where should i put 'localhost'?? i am using Hostgator. Link to comment Share on other sites More sharing options...
ruchit.devil Posted July 24, 2013 Author Share Posted July 24, 2013 i had put localhost in the db server. but now iam getting a new error: Link to database cannot be established: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: NO) i think it is pointing at my local server on my pc and not at the live server. the user root is the user in local server. Link to comment Share on other sites More sharing options...
vekia Posted July 24, 2013 Share Posted July 24, 2013 hello you have to use correct username and password (username and password for your mysql database on your server) make sure that you use correct values coz from error code mentioned above it looks like you use root mysql account when the script trying to connect to database. Link to comment Share on other sites More sharing options...
rambabuy Posted January 2, 2014 Share Posted January 2, 2014 i had put localhost in the db server. but now iam getting a new error: Link to database cannot be established: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: NO) i think it is pointing at my local server on my pc and not at the live server. the user root is the user in local server. Hello Try to use same database name and username password. It should be same as localhost and live server. Error shows, Live server is not using root as username and no password. Best practice is create a database name in localhost which is same as local host, then uploading easy Link to comment Share on other sites More sharing options...
benjamin utterback Posted January 2, 2014 Share Posted January 2, 2014 You should create another database in your Cpanel, without changing anything. Make a new username and password and try that. Also, try the localhost ip, 127.0.0.1 that also could work. Link to comment Share on other sites More sharing options...
NemoPS Posted January 4, 2014 Share Posted January 4, 2014 If this can help: http://nemops.com/prestashop-migration-local-live/ Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now