List:General Discussion« Previous MessageNext Message »
From:Aron Levy Date:June 7 2006 6:48pm
Subject:ERROR 1045 (28000): Access denied for user (Using password: YES)
from outside localhost
View as plain text  
Hi good afternoon, i am triying to connect with my company's mysql 
server using a client program from shell and I keep receiving the 
following answer:

[root@GWTServer ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user 'user1'@'200.93.42.209' 
(using password: YES)
[root@GWTServer ~]#

I already checked the user was configured for any host ("%"), the port 
3306 is open (checked with nmap), but i dont know what i need to do or 
see other variables.  I am 100% sure of the passwords i am using for 
this users, and i am attaching some info about the database.

Thank you in advance,


mysql> select * from user;
+-----------+--------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host      | User         | Password         | Select_priv | 
Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | 
Reload_priv | Shutdown_priv |Process_priv | File_priv | Grant_priv | 
References_priv | Index_priv | Alter_priv |
+-----------+--------------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| %         | user1  | 5804b8eebr456240 | N           | N           | 
N           | N           | N           | N         | N           | 
N             | N            | N         | N          | N               
| N          | N          |
| %         | user4 | 6f37d73jsdred201d | N           | N           | 
N           | N           | N           | N         | N           | 
N             | N            | N         | N          | N               
| N          | N          |

[root@CompanyServer ~]# nmap -A -T4 my.domain.com

Starting Nmap 4.03 ( http://www.insecure.org/nmap/ ) at 2006-06-07 09:57 VET
Interesting ports on xx.xx.xx.xx:
(The 1653 ports scanned but not shown below are in state: closed)
PORT     STATE    SERVICE        VERSION
21/tcp   open     ftp            ProFTPD 1.2.10
22/tcp   open     ssh            OpenSSH 3.9p1 (protocol 1.99)
25/tcp   open     smtp           netqmail smtpd 1.04
53/tcp   open     domain
80/tcp   open     http           Apache httpd 2.0.53 ((Fedora))
106/tcp  open     pop3pw         poppassd
110/tcp  open     pop3           Courier pop3d
111/tcp  open     rpcbind         2 (rpc #100000)
135/tcp  filtered msrpc
139/tcp  filtered netbios-ssn
143/tcp  open     imap           Courier Imapd (released 2004)
443/tcp  open     ssl/http       Apache httpd 2.0.53 ((Fedora))
445/tcp  filtered microsoft-ds
465/tcp  open     ssl/smtp       netqmail smtpd 1.04
593/tcp  filtered http-rpc-epmap
993/tcp  open     ssl/imap       Courier Imapd (released 2004)
995/tcp  open     ssl/pop3       Courier pop3d
1720/tcp filtered H.323/Q.931
3306/tcp open     mysql          MySQL 4.1.15
4444/tcp filtered krb524
8443/tcp open     http           Apache httpd 1.3.33 ((Unix) 
mod_ssl/2.8.22 OpenSSL/0.9.7e PHP/5.0.4)
Device type: general purpose
Running: Linux 2.6.X
OS details: Linux 2.6.5 - 2.6.11
Uptime 26.627 days (since Thu May 11 18:56:31 2006)
Service Info: OS: Unix

Nmap finished: 1 IP address (1 host up) scanned in 63.549 seconds

mysql

MySQL Support
Active Persistent Links
Active Links
Client API version 4.1.15
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
Thread
ERROR 1045 (28000): Access denied for user (Using password: YES)from outside localhostAron Levy7 Jun
  • Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhostJames Barros7 Jun
    • Re: ERROR 1045 (28000): Access denied for user (Using password: YES)from outside localhostAron Levy7 Jun
      • Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhostDaniel da Veiga7 Jun
      • Re: ERROR 1045 (28000): Access denied for user (Using password: YES) from outside localhostJames Barros7 Jun
        • Re: ERROR 1045 (28000): Access denied for user (Using password: YES)from outside localhostAron Levy8 Jun