ERROR 1045 (28000): Access denied for user (Using password: YES)
from outside localhost
Aron Levy 7 June 2006 22:48:54
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 |
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
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 |>
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>
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 |>>
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>>
On 6/7/06, Aron Levy <alevy@globalwebtek.com> wrote:> Hi James i follow your recomendation and verify that the hash produced> matches the password field in user exactly.>
-- Aron L.>
Well, that's weird, should be working. A shot in the dark: try starting your server with "--old-passwords" as an option and see if it works.
-- Daniel da Veiga Computer Operator - RS - Brazil -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ ------END GEEK CODE BLOCK------
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>>>
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>>>>
If you would like to report an abuse of our service, such as a spam message, please . Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .
