?
Solved

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

Posted on 2004-04-29
5
Medium Priority
?
2,593 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 172 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 164 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 164 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
Creating and Managing Databases with phpMyAdmin in cPanel.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

762 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