settingsAccountsettings
By using our mini forum, you acknowledge that you have read and understand our Cookie Policy and Privacy Policy
Menusettings

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

+7 votes

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?

asked in Other category by user john7

1 Answer

+6 votes

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.

answered by user icabe
...