Solved

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

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
update joined tables 2 55
PHP & MySQL - Rounding Results from a Select Query 3 34
Very Large data in MYSQL 7 73
SQL querys that gives me from one table into another. 2 23
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…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
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.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

792 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