Mariadb error 1045 28000

Error 1045 (28000) access denied for user root localhost

MySQL users often face an issue called Error 1045 (28000) access denied for user ‘root’@’localhost’ (using password: yes). This usually occurs when you enter an incorrect password or password for your database. Fixing these credentials can resolve this error in no time.

In this article, we will look at the ways to resolve this error.

How to fix “Error 1045 (28000) access denied for user ‘root’@’localhost’ (using password: yes)”?

The error looks something like this —

It arises when you perform a fresh installation of MySQL and try to login with a password. The default password of MySQL is blank () (i.e. empty string).

So, you can login to the MySQL server using the same password.

Example

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 9

Server version: 10.4.11-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

The best practice is to change the password after the new installation.

Set root user password

You must set the root user password after performing the new installation. Here is the code to set it –

Now the new password for root user is abc .

How to fix the Error 1045 (28000)?

Let us look at the ways to fix this problem –

Enter the correct credentials

The primary method to fix this error is to enter the correct username and password using the following command –

Ensure the user is correct

Sometimes, the user you might be trying to access does not exist on the MySQL server. You can check if the user exists using the following code-

If the user does not exist, create it with the desired username.

Enter the correct host name

You might be trying to access the server from a host that is different from the defined host name. You will encounter Error 1045 in this case. You can use this code to view details of the user –

To fix this, you can update the host name for the user using the code below –

You might encounter the error in due to the following scenarios –

This is a very common error that occurs while connecting to a remote database. While connecting to such a database we need to give access to the HOST IP ADDRESS to connect to it.

This is the IP Address of the source system which connects to the database server.

If access is not given, then run the given command –

CREATE USER ‘dbuser1’@’ ‘ IDENTIFIED VIA mysql_native_password USING ‘***’;GRANT ALL PRIVILEGES ON *.* TO ‘dbuser1’@’ ‘ REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;

Conclusion

Apart from all this, make sure the host contains the correct IP address and host name, to avoid the Error 1045 (28000) access denied for user ‘root’@’localhost’ (using password: yes).

Источник

MySQL — ERROR 1045 — Access denied

In some way I have managed to get this error when I try to access into MySQL via the command line:

I have tried resetting the password without any luck using this HowTo.

I have uninstalled mysql completley and reinstalled but I still get asked for a password. I have no idea why this is the case!

Can someone please help me get a default install of MySQL.

Environment

Fedora Core 10, Full Root Access, Apache and PHP installed

Thank you for any help!!

To all those that would like to save themselves a few hours of «blood coughing» — when you uninstall MySQl completely delete everything that is left behind. If you don’t do this, it will never be a FRESH install.

7 Answers 7

If you actually have set a root password and you’ve just lost/forgotten it:

Restart it manually with the skip-grant-tables option: mysqld_safe —skip-grant-tables

Now, open a new terminal window and run the MySQL client: mysql -u root

Reset the root password manually with this MySQL command: UPDATE mysql.user SET Password=PASSWORD(‘password’) WHERE User=’root’; If you are using MySQL 5.7 (check using mysql —version in the Terminal) then the command is:

Flush the privileges with this MySQL command: FLUSH PRIVILEGES;

(Maybe this isn’t what you need, Abs, but I figure it could be useful for people stumbling across this question in the future)

Источник

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)

I know that some users may say that this is a duplication but seriously I have combed the answers and those on the internet for over half a day and I am so frustrated i am going to explode.

Now that therapeutic explanation is done, I have installed MySql Server and MariaDb 10 from the Ubuntu repositories on Ubuntu 12.04 LTS and input the root password when it is installing[When the pink screen appears and prompts for the root password] and the installation goes through as smoothly as a knife through butter.

Now the real frustration begins in either of the below 2 scenarios:

1. When I enter the sudo /usr/bin/mysql_secure_installation command nd am prompted to enter the root password

2.When I enter the mysql -u root -p command and am prompted for the password.

Please I really need help on this — I have lost count of the number of times I have had to uninstall and reinstall either MySQL or MariaDb because this pain in neck erf an error.

4 Answers 4

Check the file: /etc/mysql/mariadb.conf.d/mysqld.cnf

verify if this line exists:

then go to MariaDB:

and make these modifications:

I didn’t have access to mysqlworkbench , but after I applied this solution, everything ruan well.

I think I may have figured out the issue — It has to do with the long password.I think that this should reported as a bug to MySQl and MariaDB developers because on installation you can create a password with over 100 characters but when you try to login to MySQl or MariaDB when it is in production you get the above error.

So glad I figured this out after so much pain — surprising really that this has not been identified as a bug considering how many years MySQL has been in production.

So basically one resolution is to go through the following steps to resolve the above issue:

Start with a blank password on a non-production server and is if it works

If you are successful with step 1 then proceed with securing your mysql installation by typing the follwing command: sudo /usr/bin/mysql_secure_installation and try entering a more complex password — comination of lowercase letters, numbers, symbols and uppercase letters of at least 8 characters should be fine.

I recommend starting with 8 and move upwards till you reach a ceiling with the number of characters you can enter.

The above should be a step in the right direction to getting your MySQL server secured.

Источник

MySql ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

I’ve tried multiple solutions from StackOverflow but haven’t had any success. I’m on Mac OSX (Sierra 10.12.3) trying to create a new database and user. From terminal I enter:

which outputs this error:

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

To try and resolve it I stopped mysql from ‘System Preferences’, then from terminal typed:

I opened a second tab and entered:

Then from in mysql:

I then restart the computer (killing the process with CMD + C doesn’t work). After restarting, trying mysql -u root still produces the same error.

I am able to access mysql via a MySQL client and a non-root user.

Any help is appreciated.

10 Answers 10

For security reason mysql -u root wont work untill you pass -p in command so try with below way

And mysql will ask for the password

Just to confirm: You are sure you are running MySQL 5.7, and not MySQL 5.6 or earlier version. And the plugin column contains «mysql_native_password». (Before MySQL 5.7, the password hash was stored in a column named password. Starting in MySQL 5.7, the password column is removed, and the password has is stored in the authentication_string column.) And you’ve also verified the contents of authentication string matches the return from PASSWORD(‘mysecret’). Also, is there a reason we are using DML against the mysql.user table instead of using the SET PASSWORD FOR syntax? – spencer7593

So Basically Just make sure that the Plugin Column contains «mysql_native_password».

Not my work but I read comments and noticed that this was stated as the answer but was not posted as a possible answer yet.

Источник

Enable remote MySQL connection: ERROR 1045 (28000): Access denied for user

MySQL 5.1.31 running on Windows XP.

From the local MySQL server (192.168.233.142) I can connect as root as follows:

From a remote machine (192.168.233.163), I can see that the mysql port is open:

But when trying to connect to mysql from the remote machine, I receive:

I have only 2 entries in mysql.user:

What more do I need to do to enable remote access?

EDIT

As suggested by Paulo below, I tried replacing the mysql.user entry for % with an IP specific entry, so my user table now looks like this:

I then restarted the machine, but the problem persists.

13 Answers 13

You have to put this as root:

where IP is the IP you want to allow access, USERNAME is the user you use to connect, and PASSWORD is the relevant password.

If you want to allow access from any IP just put % instead of your IP

and then you only have to put

Or restart mysql server and that’s it.

I was getting the same error after granting remote access until I made this:

In newer versions of mysql the location of the file is /etc/mysql/mysql.conf.d/mysqld.cnf

(comment this line: bind-address = 127.0.0.1 )

Then run service mysql restart .

By default in MySQL server remote access is disabled. The process to provide a remote access to user is.

1. Go to my sql bin folder or add it to PATH
2. Login to root by mysql -uroot -proot (or whatever the root password is.)
3. On success you will get mysql>
4. Provide grant access all for that user.

Here IP is IP address for which you want to allow remote access, if we put % any IP address can access remotely.

This for a other user.

Hope this will help

Paulo’s help lead me to the solution. It was a combination of the following:

• the password contained a dollar sign
• I was trying to connect from a Linux shell

The bash shell treats the dollar sign as a special character for expansion to an environment variable, so we need to escape it with a backslash. Incidentally, we don’t have to do this in the case where the dollar sign is the final character of the password.

As an example, if your password is «pas$word», from Linux bash we must connect as follows:

Do you have a firewall ? make sure that port 3306 is open.

On windows , by default mysql root account is created that is permitted to have access from localhost only unless you have selected the option to enable access from remote machines during installation .

creating or update the desired user with ‘%’ as hostname .

Try to flush privileges again.

Try to restart server to reload grants.

Try create a user with host «192.168.233.163». «%» appears to not allow all (it’s weird)

In my case I was trying to connect to a remote mysql server on cent OS. After going through a lot of solutions (granting all privileges, removing ip bindings,enabling networking) problem was still not getting solved.

As it turned out, while looking into various solutions,I came across iptables, which made me realize mysql port 3306 was not accepting connections.

Here is a small note on how I checked and resolved this issue.

Checking if port is accepting connections:

telnet (mysql server ip) [portNo]

Adding ip table rule to allow connections on the port:

iptables -A INPUT -i eth0 -p tcp -m tcp —dport 3306 -j ACCEPT

Would not recommend this for production environment, but if your iptables are not configured properly, adding the rules might not still solve the issue. In that case following should be done:

Источник