“unauthenticated user” problem in mysql logs?

By Gunjan · June 30, 2010

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.

root@server [~]# pico /etc/my.cnf

skip-networking
skip-name-resolve
skip-host-cache
skip-locking

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

delicious

|

digg

|

reddit

|

|

technorati

|

stumbleupon

|

savetheurl

You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

One Response

"unauthenticated user" problem in mysql logs? | Linux Servers … | Linux Affinity says:

June 30, 2010 at 8:47 pm

[...] posted here: "unauthenticated user" problem in mysql logs? | Linux Servers … Posted in: Server ADD [...]

The Perfect Forum
- .htaccess (10)
- Basic Linux (56)
- Browser problems (3)
- Common errors (10)
- cPanel + cPanel scripts (24)
- Cron jobs issue (4)
- Dedicated Server Issue (5)
- Definition / Explanation (5)
- E-mails issue (16)
- Enable private PHP (5)
- Few good queries and suggestions (12)
- FTP / Frontpage / Dreamweaver (10)
- General (3)
- HTML/PHP issue (1)
- Install server side software / script (14)
- Linux Administrator Interview Questions (61)
- Linux Permissions (8)
- Mailman (1)
- Mysql + phpmyadmin (15)
- NFS server (6)
- PHP (7)
- Plesk (10)
- scripts (3)
- Server Security (20)
- Third party script issue (13)
- Tomcat (1)
- Uncategorized (19)
- VPS (46)
Archives
Tag you need to know
.htaccess .htaccess file /etc/ssh/sshd_config /var/cpanel/cpanel.config Access denied for user 'root'@'localhost' AddHandler + Safari browser problem cgi script clear cache cPanel access logs cPanel error logs cPanel exim logs cPanel logs cPanel servers logs Create new FTP account from cPanel Disable directory listing exim logs find command mysql from WHM mysql has failed mysql service mysql service from WHM nameserver setup Network File System NFS Server php form phpmail() form phpmail function please contact the sysadmin plesk panel issue roundcube roundcube error roundcube error logs Safari browser Safari browser + AddHandler Safari browser + AddHandler application/x-httpd-php5 Safari browser downloading .html pages. Safari browser downloading pages Safari downloading pages simple php form simple phpmail() form simple phpmail function form sshd restart suexec trueuserdomains using the NFS Server