Question 2594 in Wordpress Question posted in
The official Wordpress documentation can be found here.

Can not create a new database on phpmyadmin because of this error – 1044 – Access denied for user 'xxx' to database 'zzz' – WordPress

I need to import a sql. database to WordPress through phpMyAdmin.
Anytime I want to create a new database this error happens (#1044 – Access denied for user ‘xxx’ to database ‘zzz’).

Thanks for your help.

Tags:

2

Answers


  1. 0

    You can check all privileges permission of database user and also check our sql file. May be mention there "CAEATE DATABASE ‘*******’" if you have that then you remove that. Most of this #1044 refer you to check your database user and permission of your database. I think this suggestion will help you.

    Login or Signup to reply.
  2. 0

    As the others have mentioned, shared hosting environments generally don’t allow you to create any arbitrary database name, sometimes you’re limited to only one database and sometimes it has to be a subset of your username or something. If that’s the case, you’ll need to edit the .sql file to force it to use the database name you’ve been assigned.

    If that’s not the case, it’s likely the user you are logged in as doesn’t have the privileges to create a new database, so you’ll need to log in as a user that does have privileges. Perhaps you’re not logged in as the user you think you are. Note that the username and host value need to match, otherwise you could be logged in as the anonymous user instead of one that has permissions (for instance, if your user account is mia with host field 127.0.0.1 but you’re logged in via the socket connection to ‘localhost’, it doesn’t match.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search