Hello,
So i am trying to create a new database, and every time i try the
CREATE DATABASE database name;
I get the error below #1044 - Access denied for user ‘phpmyadmin’@‘localhost’
i tried the [‘AllowNoPassword’] = TRUE; method and i still wasn’t able to create a database within the installed phpmyadmin
i tried using root with the admin password but that didint work
Any ideas?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
When you create a database from the CLI, you should use two commands; one to create the db and one to create the user.
Creating the Database
create database mydb;
Creating the User
grant all on mydb.* to 'myuser'@'localhost' identified by 'mypassword';
The above grants all privileges to myuser on mydb using mypassword. Capitalization doesn’t matter in this case, though the single quotes do, so make you you keep those in place.
As far as phpMyAdmin, normally I recommend going with a solution that’s far easier to manage, and that would be Adminer. Instead of hundreds of files, it’s a single file:
https://github.com/vrana/adminer/releases/download/v4.3.0/adminer-4.3.0.php
You’ll download the above, upload it to any directory you wish, and then login as normal.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.