Thank you very much James, i flush the privilegies and restart the mysql
service and all result fine :-)
I can access from anyhost
Aron L.
James Barros wrote:
> Can this use log in from localhost successfully?
> Try flushing privileges again?
> If that failed, I'd drop the user and recreate?
> ( Theres really not alot to this, sorry I don't have any more ideas :( )
>
> -- James
>
> On Jun 7, 2006, at 1:07 PM, Aron Levy wrote:
>
>> 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:
>>>>
>>>> [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
>>>>
>>>> --
>>>> MySQL General Mailing List
>>>> For list archives: http://lists.mysql.com/mysql
>>>> To unsubscribe: http://lists.mysql.com/mysql?
>>>> unsub=james@stripped
>>>>
>>>>
>>>
>>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?
>> unsub=james@stripped
>>
>>
>
>
