 | |
Error 1045 when connecting via Query Browser
comp.databases.mysql comp.databases.mysql
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: Error 1045 when connecting via Query Browser -
11-24-2009
, 07:03 AM
|
On 23 Nov, 20:22, Robert Hairgrove <rhairgr... (AT) bigfoot (DOT) com> wrote: Ran Shenhar wrote: In MySQL, users are never identified solely by the user name, but by the combination of user + host (i.e., the machine or network address from which the user is coming). It is good for security reasons to have it this way. You need to have either a user/host combination of `user`@`*` or else a user `user`@`<your Windows machine's IP address>` in addition to `user`@`localhost`. Grant the appropriate permissions to the combination(s) you need. Now then, I completely agree with this, but... In cpanel there is a "Remote MySQL" option where ip addresses can be listed. These addresses do not appear to be directly related to specific users (as I would expect and hope them to be). So how is this enabled? |
their own abstractions. Probably, when you add an IP address Cpanel
simply duplicates existing users.
--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--
#12
| |||
| |||
|
|
Captain Paralytic escribió: On 23 Nov, 20:22, Robert Hairgrove <rhairgr... (AT) bigfoot (DOT) com> wrote: Ran Shenhar wrote: In MySQL, users are never identified solely by the user name, but by the combination of user + host (i.e., the machine or network address from which the user is coming). It is good for security reasons to have it this way. You need to have either a user/host combination of `user`@`*` or else a user `user`@`<your Windows machine's IP address>` in addition to `user`@`localhost`. *Grant the appropriate permissions to the combination(s) you need. Now then, I completely agree with this, but... In cpanel there is a "Remote MySQL" option where ip addresses can be listed. These addresses do not appear to be directly related to specific users (as I would expect and *hope them to be). So how is this enabled? Just a guess... Hosting control panels love to mask real stuff with their own abstractions. Probably, when you add an IP address Cpanel simply duplicates existing users. That was sort of my assumption too, but I wondered if anyone knew |
#13
| |||||||||||||
| |||||||||||||
|
|
On Monday, November 23, 2009 3:04 PM Ran Shenhar wrote: Hi, MySQL NB here. Got a MySQL on linux. When connecting from the local machine (mysql -u<user> -p<password>) I can log in. When trying from my Win machine to connect using Query Browser, I get error 1045 "Access denied for user '<user>'@'Windows Machine IP' (using password: YES). I tried various combinations of " grant ALL on <DB> to <user>@<IP>;", but nothing helped so far. Any hints (except for the obvious "do not use query browser")? Thanks, |
Quote:
|
On Monday, November 23, 2009 3:22 PM Robert Hairgrove wrote: Ran Shenhar wrote: In MySQL, users are never identified solely by the user name, but by the combination of user + host (i.e., the machine or network address from which the user is coming). It is good for security reasons to have it this way. You need to have either a user/host combination of `user`@`*` or else a user `user`@`<your Windows machine's IP address>` in addition to `user`@`localhost`. Grant the appropriate permissions to the combination(s) you need. |
Quote:
|
On Monday, November 23, 2009 3:33 PM Ran Shenhar wrote: Thanks - but no luck with the grant: mysql> grant ALL on *.* to 'root'@'10.1.2.15'; Query OK, 0 rows affected (0.00 sec) |
Quote:
|
On Monday, November 23, 2009 4:00 PM Jerry Stuckle wrote: Ran Shenhar wrote: Are these on the same intranet? Did you set up a password for root (AT) 10 (DOT) 1.2.15? It is a different user than root (AT) localhost (DOT) -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex (AT) attglobal (DOT) net ================== |
Quote:
|
On Monday, November 23, 2009 4:10 PM Ran Shenhar wrote: I he a Yes, machines are on same intranet and are accessible (ping works, I can see the connection request running tcpdump on the mysql machine). No I have not as I was not aware I needed to - how do I go about that? Also, since my Win is DHCP based, how do I make it general and not IP specific? Thanks, |
Quote:
|
On Monday, November 23, 2009 4:18 PM Ran Shenhar wrote: ) I et ", the m t e a Following your comment, I saw on mysql.user that my user has no password, I removed the password from Query Browser - it works. Thanks for the pointer! |
Quote:
|
On Monday, November 23, 2009 4:54 PM Jerry Stuckle wrote: Ran Shenhar wrote: There is a whole section in the manual about user account management. I suggest you read it closely: http://dev.mysql.com/doc/refman/5.4/...anagement.html -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex (AT) attglobal (DOT) net ================== |
Quote:
|
On Monday, November 23, 2009 6:08 PM Peter H. Coffin wrote: One thing that bears mentioning that the manual does not make very clear (mostly because everyone writing the manual is already familiar with this) is that, when talking about user ids and hosts and the need for adding them, 'localhost' is *special* and means "is connected through the local, on-machine unix-ish socket file", and that does *NOT* include connecting through the TCP loopback address frequently named "localhost". it is also important (slightly less weird, slightly more specialized) that it is vital to remember that the host connection specifies the closest connecting point to the db server. Stuff like phpMyAdmin needs the host to allow whatever user ID access from the webserver, not the browser's IP address. -- A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? A: Top-posting. [TOFU := text oben, Q: What is the most annoying thing on usenet? followup unten] |
Quote:
|
On Monday, November 23, 2009 10:54 PM gordonb.wpxs wrote: Another thing worth knowing is that 'Localhost', 'lOcAlHoSt', and similar names are *not* special and mean "is connected through the TCP loopback address frequently named "localhost"". |
Quote:
|
On Tuesday, November 24, 2009 7:35 AM Captain Paralytic wrote: Now then, I completely agree with this, but... In cpanel there is a "Remote MySQL" option where ip addresses can be listed. These addresses do not appear to be directly related to specific users (as I would expect and hope them to be). So how is this enabled? |
Quote:
|
On Tuesday, November 24, 2009 8:03 AM ?lvaro_G._Vicario wrote: Captain Paralytic escribi?: Just a guess... Hosting control panels love to mask real stuff with their own abstractions. Probably, when you add an IP address Cpanel simply duplicates existing users. -- -- http://alvaro.es - ?lvaro G. Vicario - Burgos, Spain -- Mi sitio sobre programaci?n web: http://borrame.com -- Mi web de humor satinado: http://www.demogracia.com -- |
Quote:
|
On Tuesday, November 24, 2009 10:24 AM Captain Paralytic wrote: On 24 Nov, 13:03, "=C1lvaro G. Vicario" he a That was sort of my assumption too, but I wondered if anyone knew definitively. |
Quote:
|
Submitted via EggHeadCafe SQL Operations on a Text File with ADO.NET http://www.eggheadcafe.com/tutorials...th-adonet.aspx |
#14
| ||||||||||||||
| ||||||||||||||
|
|
On Monday, November 23, 2009 3:04 PM Ran Shenhar wrote: Hi, MySQL NB here. Got a MySQL on linux. When connecting from the local machine (mysql -u<user> -p<password>) I can log in. When trying from my Win machine to connect using Query Browser, I get error 1045 "Access denied for user '<user>'@'Windows Machine IP' (using password: YES). I tried various combinations of " grant ALL on <DB> to <user>@<IP>;", but nothing helped so far. Any hints (except for the obvious "do not use query browser")? Thanks, |
Quote:
|
On Monday, November 23, 2009 3:22 PM Robert Hairgrove wrote: Ran Shenhar wrote: In MySQL, users are never identified solely by the user name, but by the combination of user + host (i.e., the machine or network address from which the user is coming). It is good for security reasons to have it this way. You need to have either a user/host combination of `user`@`*` or else a user `user`@`<your Windows machine's IP address>` in addition to `user`@`localhost`. Grant the appropriate permissions to the combination(s) you need. |
Quote:
|
On Monday, November 23, 2009 3:33 PM Ran Shenhar wrote: Thanks - but no luck with the grant: mysql> grant ALL on *.* to 'root'@'10.1.2.15'; Query OK, 0 rows affected (0.00 sec) |
Quote:
|
On Monday, November 23, 2009 4:00 PM Jerry Stuckle wrote: Ran Shenhar wrote: Are these on the same intranet? Did you set up a password for root (AT) 10 (DOT) 1.2.15? It is a different user than root (AT) localhost (DOT) -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex (AT) attglobal (DOT) net ================== |
Quote:
|
On Monday, November 23, 2009 4:10 PM Ran Shenhar wrote: I he a Yes, machines are on same intranet and are accessible (ping works, I can see the connection request running tcpdump on the mysql machine). No I have not as I was not aware I needed to - how do I go about that? Also, since my Win is DHCP based, how do I make it general and not IP specific? Thanks, |
Quote:
|
On Monday, November 23, 2009 4:18 PM Ran Shenhar wrote: ) I et ", the m t e a Following your comment, I saw on mysql.user that my user has no password, I removed the password from Query Browser - it works. Thanks for the pointer! |
Quote:
|
On Monday, November 23, 2009 4:54 PM Jerry Stuckle wrote: Ran Shenhar wrote: There is a whole section in the manual about user account management. I suggest you read it closely: http://dev.mysql.com/doc/refman/5.4/...anagement.html -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex (AT) attglobal (DOT) net ================== |
Quote:
|
On Monday, November 23, 2009 6:08 PM Peter H. Coffin wrote: One thing that bears mentioning that the manual does not make very clear (mostly because everyone writing the manual is already familiar with this) is that, when talking about user ids and hosts and the need for adding them, 'localhost' is *special* and means "is connected through the local, on-machine unix-ish socket file", and that does *NOT* include connecting through the TCP loopback address frequently named "localhost". it is also important (slightly less weird, slightly more specialized) that it is vital to remember that the host connection specifies the closest connecting point to the db server. Stuff like phpMyAdmin needs the host to allow whatever user ID access from the webserver, not the browser's IP address. -- A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? A: Top-posting. [TOFU := text oben, Q: What is the most annoying thing on usenet? followup unten] |
Quote:
|
On Monday, November 23, 2009 10:54 PM gordonb.wpxs wrote: Another thing worth knowing is that 'Localhost', 'lOcAlHoSt', and similar names are *not* special and mean "is connected through the TCP loopback address frequently named "localhost"". |
Quote:
|
On Tuesday, November 24, 2009 7:35 AM Captain Paralytic wrote: Now then, I completely agree with this, but... In cpanel there is a "Remote MySQL" option where ip addresses can be listed. These addresses do not appear to be directly related to specific users (as I would expect and hope them to be). So how is this enabled? |
Quote:
|
On Tuesday, November 24, 2009 8:03 AM ?lvaro_G._Vicario wrote: Captain Paralytic escribi?: Just a guess... Hosting control panels love to mask real stuff with their own abstractions. Probably, when you add an IP address Cpanel simply duplicates existing users. -- -- http://alvaro.es - ?lvaro G. Vicario - Burgos, Spain -- Mi sitio sobre programaci?n web: http://borrame.com -- Mi web de humor satinado: http://www.demogracia.com -- |
Quote:
|
On Tuesday, November 24, 2009 10:24 AM Captain Paralytic wrote: On 24 Nov, 13:03, "=C1lvaro G. Vicario" he a That was sort of my assumption too, but I wondered if anyone knew definitively. |
Quote:
|
On Friday, February 25, 2011 2:25 PM Mauricio wrote: Greetings, My solution to your problem is: 1- Run MySQL Configuration Wizzard. 2- Choose to remove any previous configuration. 3- Restart your MySQL service. 4- Use XAMPP to access your MySQL Database with user "root" and passwrd "" (empty). Consider getting a place online to host your MySQL database as I did. First just for a proof of concept, but now I'm running a business site after some try/error issues. Signup Now with Instant Activation - a href="http://www.000webhost.com/420083.html"> free MySQL online webhost</a |
Quote:
|
Submitted via EggHeadCafe Install Windows Updates using C# & WUAPI http://www.eggheadcafe.com/tutorials...-c--wuapi.aspx |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.