0

I just installed a new server and tried to create a new database via phpmyadmin.

When I try to create a new database I get the below error message:

To be precise MYSQL said:

#1044 - access denied for use '"@ localhost'

Does anyone know what may be causing this error or what steps should I take to further troubleshoot?

| improve this question | | | | |
-1

Try to login again and then create db. Use the default username and password, root and empty password.

| improve this answer | | | | |
2

1. Try to login Login with any valid mysql user credentials.

If the root user of MySQL doesn't have a password (which is a bad pratice) ensure to set below in config.inc.php file (for eg path: /etc/phpMyAdmin/config.inc.php)

$cfg['Servers'][$i]['AllowNoPassword'] = True;

2.You can also create a new mysql user using below.

CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'new_password';

GRANT ALL privileges ON my_db.* TO 'new_user'@'localhost'; IDENTIFIED BY 'new_password';

flush privileges;
| improve this answer | | | | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.