I' ve converted mssql database to mysql database (locally). I ve created a free subdomain and found a free webhoster on 000webhost.com. I m trying to import my mysql database onto the server using phpmyadmin interface but am unable to do this. I get the following error-->#1044 - Access denied for user 'a1581119_ts1'@'localhost' to database 'world'
I must say that i googled all day and found numerous answers but was not able to fix my issue. Any help would be greatly apreciated.

3 Years
Discussion Span
Last Post by castajiz_2

Hi there,

I think you are trying to import your SQL data into the database 'world', which is highly unlikely yours.

With your web host you will have both MySQL username, MySQL password and MySQL database name. Your database name will probably something generic like your username is (a1581119_ts1).

If you are already trying to import into the right database (maybe through PHPMyAdmin) the problem could be that your .sql dump file is specifically asking for the database 'world' - maybe your old database was named this.

Edit your .sql file and replace occurrences of 'world' with your new database name. It is also possible to remove the specific reference to a given database, but that can be more complicated so try replacing first.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.