Troubleshooting: MySQL/MariaDB Error #1044 & #1045 Access Denied for User
When using PhpMyAdmin, it’s essential to have the correct user permissions to create edits/writes to the database. Otherwise, insufficient permissions can lead to errors like the ones pictured below “#1044 – Access denied for user …[using password: YES]” and “#1045 – Access denied for user…[using password: YES]”. In our tutorial, we’ll show you how to correct this issue using the command line terminal. Let’s get started!
Pre-flight
- Root access to the server hosting PhpMyAdmin
Step 1: Connect to your server using SSH, from your computer’s terminal.
ssh root@yourhostname.com
Step 2: When the MariaDB was installed a default user was also created, for our Ubuntu install this details of this user can be found at /etc/dbconfig-common/phpmyadmin.conf. We’ll be talking our default user, phpmyadmin, and granting them permissions to create a database within PhpMyAdmin.
MySQL;
grant create on *.* to phpmyadmin@localhost;
Alternatively, if you are trying to delete a database you can use this command replacing username with the user in question.
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='username';
FLUSH PRIVILEGES;
GRANT ALL ON *.* TO 'username'@'localhost';
Step 3: Log into PhpMyAdmin, by going to http://yourhostname.com/phpmyadmin.
Step 4: Create a Database within PhpMyAdmin by selecting the SQL tab and running a command to create the database. Paste in the following command, replacing cooldb with the database name and selecting Go.
CREATE DATABASE cooldb;
Step 5: You’ll know the database was created by the success message and it’ll appear in the left-hand side menu bar.
Liquid Web server customer’s get the convenience of calling our support tech 24/7. Our technicians have a wealth of knowledge and can help with common issues like this. Make the switch and get free migration to your VPS server with round the clock support.
Related Articles:
About the Author: Echo Diaz
Throughout Echo's four year stint as a technical support specialist, her passion for breaking down complex concepts had to lead to a career in professional writing. As a former top tier support specialist, she added a distinctive element to her written work that spoke to customer feedback and concerns. Echo occasionally pops her head out from behind her computer to watch her dog energetically run around the yard and unabashedly shovels money into buying tickets to see her favorite musical artists.
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.
Latest Articles
How to Edit Your DNS Hosts File
Read ArticleHow to Edit Your DNS Hosts File
Read ArticleMicrosoft Exchange Server Security Update
Read ArticleHow to Monitor Your Server in WHM
Read ArticleHow to Monitor Your Server in WHM
Read Article