UnixServerAdmin

Server Administration & Management

“unauthenticated user” problem in mysql logs

While running following command.

# mysqladmin -i3 pr

We are getting result.

056 | unauthenticated user | localhost |    | Connect |      | Reading from net |

To avoid such problem add following lines in /etc/my.cnf file to avoid access for unauthenticated user.

# vi  /etc/my.cnf
==================
skip-networking
skip-name-resolve
skip-host-cache
skip-locking
==================

# /etc/init.d/mysql restart

Now restart the mysql service and check mysql process logs again.

Advertisements

August 14, 2011 - Posted by | MySQL |

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: