How to solve MySQL said: Documentation #1044 - Access denied for user?

  

4
Topic starter

I have this error while trying to import my DataBase to another hiadting and domain name:

MySQL said: Documentation #1044 - Access denied for user 'vipozico'@'localhost' to database 'veseuwdr_veselka'

Please help!

What should I do?

1 Answer
3

Simply open your .sql file with Notepad++ or some IDE (I use PHPStorm)

Locate these lines (usually line numbers: 14 and 25) and delete them:

CREATE DATABASE IF NOT EXISTS `veseuwdr_veselka` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `veseuwdr_veselka`;

See the screenshot:

delete create database lines in sql file

You might also want to UNCHECK the

Allow the interruption of an import in case the script detects it is close to the PHP timeout limit. (This might be a good way to import large files, however it can break transactions.) Skip this number of queries (for SQL) starting from the first one

option when importing your .sql file

See the screenshot below:

Allow the interruption of an import in case the script detects it is close to the PHP timeout limit.

Share: