Skip to main content

Solve MYSQL Error 1045 (28000): Access denied

Most of mysql users will face with a login error, when they try to login with another user name into mysql db on localhost. I am one of them. Typically, these commands are run:

> GRANT ALL ON *.* TO 'fatih'@'%' IDENTIFIED BY 'istanbul';
> quit;

Then, we try 'mysql -u fatih -p'. This ends with an error : 'ERROR 1045 (28000): Access denied for user 'fatih'@'localhost' (using password: YES)' 

It doesn't seem reasonable at first look and to figure what is going on out, passwords and grants are usually checked as first action. However, both will not work, because granted from '%' behaves unexpectedly if you try to login a mysql db in your computer. Since localhost is resolved to 127.0.0.1 in /etc/hosts file, mysql interprets the login attempt from user 'fatih' as fatih@localhost which doesn't have permission to authenticate.

There are two ways to handle this issue.

Specify another ip address to which any domain name is resolved in /etc/hosts file. Call command 'ifconfig', and pick up eth0 ipv4 address. When you call the command 'mysql -u fatih -p -h 12.12.12.1', you will be able to login. When you run 'select user()' command, you will get 'fatih@12.12.12.1' The point there, there should not be any line which do resolving for this particular ip address in /etc/hosts file.

As second option, you can give grants for a user from specific domain name. In this case, this domain name is localhost.

  • Login mysql shell with root user <root@localhost privilege is defined as default>. 
  • Run mysql command : "grant all privileges on *.* to fatih@localhost identified by 'istanbul';"
  • Quit mysql console, then login with user fatih : 'mysql -u faith -p'. Once you login, if you type select user();, you will see that you have been logged in as fatih@localhost.
A user from other hosts will be able to login if they are granted with '%'. But this will not work if login attempt and mysql server are in the same host. This article is for explaining this ambiguity.

Easy to do, hard to discover ;)


Labels:
Location: Turkey

Comments

Post a Comment

Popular posts from this blog

Integration of MuPDF Project as a Library into an Android Studio Project

I have needed to use MuPDF library in my android project. After some research, I have seen that there are many integration tutorials but, but integrated projects are developed on Eclipse. For projects on AndroidStudio+Gradle, there is no example. I mean there is no specific example which exactly refers to this issue. So, after achieving my goal, I want to share the steps publicly so that it can be reused by others.
27 comments
Read more

A Way To Monetize Your Kivy Game

While I am building my game, I look for a way to monetize it. This will be my first game, so it is also the first to attempt earning money with an App. I am also not familiar to monetization companies. So, I have done a search to find an appropriate ads network which can be easily integrated with kivy . The first and only company who provides a sdk for kivy is RevMob . I integrated RevMob sdk and tested it. Unfortunately, it doesn't have a good performance and FullScreen Ads crashes. Just links will work. Therefore, RevMob option is not really preferable since ads need to be visually effective. You can also integrate android sdk of any ads network by using pyjnius . In this post, I will show how to use Adbuddiz sdk with kivy.
6 comments
Read more

Encoding multi-dimensional value into 1-D with preserving closeness

After a very long time, this will be my first post. I hope that it will not be the last, and the rest will come. For a project about taxi trajectory prediction, I have applied k-NN algorithm on coordinate sequence of taxi trips. Did I have promising results? Well, it is arguable, but I have discovered some good techniques. One of them is Z-order curve (Figure 1). Figure 1: Four levels of Z-ordering (taken from Wikipedia  page) I was looking for a technique to decrease dimensionality of 2-D coordinate representation (lat-lon) into 1-D . But on this 1-D value, I would like to apply k-NN algorithm. For this purpose, 1-D values must preserve the closeness of two different coordinates. If I do linear ordering of latitude and longitude values, I couldn't achieve this goal, because closeness will depend on only one value which is placed on the right-most. Let's assume I do linear ordering as lat-lon:
11 comments
Read more