someone probably installed mysql for DHCP address e.g 192.168.fu.bar
then as luck would have it the IP address changed
if you pull all network connections everyone on that box should be able to
access mysql
Salutations de l'état du chômage
Martin Gainty
On Mon, 19 Oct 2009 16:30:47 -0700
John Oliver wrote:
> I have a problem with MySQL passwords... I set them, write them
> down... and they stop working. I have to go in and manually reset
> them.
>
> Right now, I have a database that, even after resetting the password,
> I still cannot access i
The type of password instability you are talking about is pretty much
unheard of in MySQL.. however, reverse DNS resolution is always
messing up depending on the network setup. From a console on your
database host, how easily can you resolve the hostnames that your
client is presenting? What is
I have a problem with MySQL passwords... I set them, write them down...
and they stop working. I have to go in and manually reset them.
Right now, I have a database that, even after resetting the password, I
still cannot access it.
/var/log/mysql.log doesn't give me any useful information. How
Dear all,
Benetl, a free ETL tool for files using MySQL, is out in version 3.2.
This new version is now supporting Java SE 6 and using memory arguments
for JVM.
You can freely download it at : www.benetl.net
You can learn more about ETL tools at:
http://en.wikipedia.org/wiki/Extract,_transf
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
>-Original Message-
>From: Scott Haneda [mailto:talkli...@newgeo.com]
>Sent: Friday, October 16, 2009 2:44 PM
>To: Jerry
At 05:40 AM 10/18/2009, John wrote:
Mike,
What behaviour you experience depends to some extent on what storage engine
you are using and on what other non-unique indexes you have on the tables.
With LOAD DATA INFILE on empty MyISAM tables all non-unique indexes are
created in a separate batch wh
Something in the ilk of
update *table* set *field* = concat("prefix_", *field*) where *condition *
should do the trick.
On Mon, Oct 19, 2009 at 4:56 PM, lejeczek wrote:
> dear all, a novice here
> quickie regarding query syntax - is it possible to take fields values from
> one column
> and updat
dear all, a novice here
quickie regarding query syntax - is it possible to take fields values
from one column
and update the same column with new values like this: prefix_OldValue
column: one, two, three -> column: prefix_one, prefix_two, ...
can this be done with one query and with on use of ab
