sterndata on "Import SQL - error #1044 Access denied for user - what to do?"

Hi,
I want to transfer my WP website to another server. Befor I downloaded files from my previous website I wanted to import SQL file to the database at the new site. When I tried to do that I got this error:

Error in query (1044): Access denied for user 'dbo516153407'@'%' to database 'lechiron'

I read on this forum that some people had similar problem, but nowhere could I find a solution that would work for me.

Thanks in advance for your help.

You're not logging into the database with the right credentials. Try resetting your database user's password via the hosting control panel.

You have this error in PhpMyAdmin, when you try to import your database?

Open your SQL dump whot Notepad++ or something, and nearly the 22-23 lines, you will see this:

CREATE DATABASE30335820_bredatdent` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE 30335820_bredatdent;`

Please remove the CREATE DATABASE line. You need this:
USE30335820_bredatdent;

Save As the modified SQL dump, and try to import again.

Thanks a lot, this helped. But I got one more question. After I imported the database I changed URL address in 'wp-options', so the main page loads correctly. But the other pages don't load as the should (there is a message such page doesn't exist). How can I solve this?
Do I need to change something in SQL in database or is there a plugin for it?

reset your permalinks from settings->permalinks. Just go there and click "save". Please do not follow hehehuhu's advice.

Also, read this on moving WordPress:
https://codex.wordpress.org/Moving_WordPress