Solved

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

Posted on 2004-04-29
5
2,556 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
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

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…
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

679 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