Solved

Access denied for user: 'nobody@localhost' (Using password: NO)

Posted on 2004-04-29
5
2,566 Views
Last Modified: 2007-12-19
Hi,

I'm running mysql Ver 12.22 Distrib 4.0.18, for pc-linux (i686), under redhat. Am getting the following exception message when i try to access my database:

Error creating connection (Invalid authorization specification: Access denied for user: 'nobody@EmiRes' (Using password: NO))

I have setup my database, and created the correct user/permissions for the connection string i am using. I can connect to the database using mysql-front, but when i try to access through the application i get the above error.

Below are the current contection details:

user: emires

An initial thought was that a conflict between the server name and the user name might be causing a problem, however, changing the user name and creating a new account still gives tha same error.

Any help with this would be very welcome.

Thanks

Chris
0
Comment
Question by:n0702897
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 17

Accepted Solution

by:
Aleksandar Bradarić earned 43 total points
ID: 10948881
>  Access denied for user: 'nobody@EmiRes'
[...skip...]
> user: emires

The error says that you are trying to connect with user `nobody` from machine `EmiRes`. Try to change the user to `emires` and see what happens...
0
 
LVL 6

Assisted Solution

by:andreif
andreif earned 41 total points
ID: 10950884
Hi,

look at your error message:

Access denied for user: 'nobody@EmiRes' (Using password: NO)

It says you are not using password and user nobody probably means that you do not supply username (nobody is user who owns process). So, check your connection settings in your app. Which language is that and what is that piece of code for connection to the dababase? May be we can help :)
0
 
LVL 16

Assisted Solution

by:DcpKing
DcpKing earned 41 total points
ID: 10951218
Your application isn't running as EmiRes, but was already running from system startup. At a guess, you're running something like a web server as a daemon and it's the web server's ID that's being used (and refused).
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS SQL Update query with connected table data 3 78
MySQL - need to join three tables 2 61
MySQL programmer starter 25 63
emailing registered email addresses in phpmyadmin 5 63
Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question