Hi James i follow your recomendation and verify that the hash produced
matches the password field in user exactly.
-- Aron L.
James Barros wrote:
Well, for starters don't worry about ports being open. If you werent
able to connect, it would give you a different error message.
select password('yourpassword'); and verify that the hash produced
matches the password field in user exactly.
-- James
On Jun 7, 2006, at 11:48 AM, Aron Levy wrote:
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:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user 'user1'@'200.93.42.209'
(using password: YES)
[EMAIL PROTECTED] ~]#
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 |
[EMAIL PROTECTED] ~]# 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]