RE: Very strange issue while trying to login remotely

en log out, and log back in with the root pw. Good luck. -Original Message- From: Ajay Garg [mailto:ajaygargn...@gmail.com] Sent: May-25-15 11:24 AM To: Mailing-List mysql Subject: Very strange issue while trying to login remotely Hi All. I have two servers, 1.2.3.4 and 5.6.7.8 I wish to

Re: Very strange issue while trying to login remotely

it will not prompt for a password with the '-p' try this: mysql --host 5.6.7.8 -uroot db_name -p I assume you do have a password set? On Mon, May 25, 2015 at 11:24 AM, Ajay Garg wrote: > Hi All. > > I have two servers, 1.2.3.4 and 5.6.7.8 > I wish to login remotely FROM 1.2.3.4 onto 5.6.7.8. >

Re: Very strange issue while trying to login remotely

Sorry, The user had multiple passwords set up in mysql.user table. Clearing the "other" passwords solved the issue. Sorry for the inconvenience. Thanks and Regards, Ajay On Mon, May 25, 2015 at 8:54 PM, Ajay Garg wrote: > Hi All. > > I have two servers, 1.2.3.4 and 5.6.7.8 > I wish to login

Very strange issue while trying to login remotely

Hi All. I have two servers, 1.2.3.4 and 5.6.7.8 I wish to login remotely FROM 1.2.3.4 onto 5.6.7.8. a) On 5.6.7.8, mysql> show grants for 'root'@'%'; +-+ | Grants for root@% | +

Re: very strange performance issue

Andrew Carlson said: > > I know this is basic, but check that you recreated the indexes after you > reloaded the snapshot. That has bit me before. I used myisamchk -r on the large table, and it has made a huge difference. I had used myisamchk before to check the table and got no complaints. M

Re: very strange performance issue

Perhaps some clues here: I started taking the problem query apart to see what slows things down. I found a culprit, but I don't understand: mysql> select count(*) from Crumb where customer_id=380 and Actual_Time BETWEEN '2009-06-01 00:00' AND '2009-06-02 00:00' and ErrorCode = 0; +--+ | c

very strange performance issue

I'm working in an environment where I have two similar servers, one running "production" the other for "development". They're not very dissimilar - both run 4.1.20-log, both run CentOS 4. The development server has a cut-down snapshot of the production database, and it's where we ... well, develop

Re: very strange slow plain select

At 03:49 PM 2/7/2008, [EMAIL PROTECTED] wrote: Thanks very much. The default mysql behavior is a little unusual. What is the parameter in my.cnf to control the cache size before forcing a flush. I waited for 2 mininutes second before the output came out without the -q option. My server is fast e

Re: very strange slow plain select

Thanks very much. The default mysql behavior is a little unusual. What is the parameter in my.cnf to control the cache size before forcing a flush. I waited for 2 mininutes second before the output came out without the -q option. My server is fast enough to read in more than 2 GB data during this

Re: very strange slow plain select

In the last episode (Feb 07), [EMAIL PROTECTED] said: > I just stumbled on this hard to explain problem. Below > > select * from BigTable  (BigTable has 5 million rows) > > takes forever to even print out the first row. as you could see from > the sql, it is supposed to print out some rows ri

very strange slow plain select

Hello: I just stumbled on this hard to explain problem. Below select * from BigTable  (BigTable has 5 million rows) takes forever to even print out the first row. as you could see from the sql, it is supposed to print out some rows right away regardless of server config in my.cnf.   What is

Re: Very Strange "command denied to user" errors

156 Oud wrote: > Hi, > > I've got a very strange problem with one of my MySQL servers. > I've got 2 dedicated servers with MySQL 4.0.21, all is fine there. > > My new server with MySQL-4.1.14 give me some headakes ! > Sometimes i've got errors like >

Very Strange "command denied to user" errors

Hi, I've got a very strange problem with one of my MySQL servers. I've got 2 dedicated servers with MySQL 4.0.21, all is fine there. My new server with MySQL-4.1.14 give me some headakes ! Sometimes i've got errors like UPDATE command denied to user 'MyUser'@'1

Re: Very strange database behavior

, 2004, at 11:43 AM, Paul McNeil wrote: Good morning to all. I have a very strange problem in my database and am trying to track down whether it is a JAVA problem or a mySQL problem. I have a table that is supposed to accept only unique data, however, at this time, the PK for that information is

RE: Very strange database behavior

7;MySQL General ' Subject: RE: Very strange database behavior Are you saying that you are not receiving an Unique key violation when you enter in duplicate data or you are relying on a value being present? If you are using the later, do you have query caching turned on? -Original Message-

RE: Very strange database behavior

Subject: Very strange database behavior Good morning to all. I have a very strange problem in my database and am trying to track down whether it is a JAVA problem or a mySQL problem. I have a table that is supposed to accept only unique data, however, at this time, the PK for that information is set

Very strange database behavior

Good morning to all. I have a very strange problem in my database and am trying to track down whether it is a JAVA problem or a mySQL problem. I have a table that is supposed to accept only unique data, however, at this time, the PK for that information is set to the auto incrementing ID field

Re: Very Strange data corruption

Michael Stassen wrote: This comes up frequently. MySQL's behavior is explained in the manual . It begins: That's interesting, and I guess one just has to accept it as part of the mysql philosphy. I don't agree, as I don't like the data

Re: Very Strange data corruption

This comes up frequently. MySQL's behavior is explained in the manual . It begins: | To be able to support easy handling of non-transactional tables, all | columns in MySQL have default values. | | If you insert an ``incorrect'' value i

RE: Very Strange data corruption

From: Steve Meyers [mailto:[EMAIL PROTECTED] > David Griffiths wrote: > > I'm not sure what the sql standard says on the matter, but > Oracle, DB2 > > and Postgres would through an exception. In fact, there is > a page on > > MySQL "gotachs" to document MySQL behaviour when it differs > > sig

Re: Very Strange data corruption

David Griffiths wrote: But the reason modern databases have foreign keys, primary keys, not-nulls, check constraints and data-metadata (char(5), INT, BIGINT, etc) is to prevent bad data from going in.. If no exception is thrown because you are trying to put a BIGINT into an INT, then why throw o

Re: Very Strange data corruption

[EMAIL PROTECTED] cc: Subject: Re: Very Strange data corruption It's best practice to write unit tests for all your code, with calculated data to show what you expect. That data then gets compared to what is actually generated and if there is a discrepency, then you have

Re: Very Strange data corruption

David Griffiths wrote: I'm not sure what the sql standard says on the matter, but Oracle, DB2 and Postgres would through an exception. In fact, there is a page on MySQL "gotachs" to document MySQL behaviour when it differs significnatly from other databases (like the first datetime field in a t

Re: Very Strange data corruption

The client software ought to be range-checking the data before sending it to the database. If the client isn't even doing that kind of minimal-effort check, how likely is it to be checking for exceptions? Not sure what you code in, but in Java, you *HAVE* to catch SQLExceptions (or throw them

Re: Very Strange data corruption

David Brodbeck wrote: The client software ought to be range-checking the data before sending it to the database. If the client isn't even doing that kind of minimal-effort check, how likely is it to be checking for exceptions? That's not to say that an error or exception is a bad idea, but MySQL

Re: Very Strange data corruption

It's best practice to write unit tests for all your code, with calculated data to show what you expect. That data then gets compared to what is actually generated and if there is a discrepency, then you have a bug somewhere. But the reason modern databases have foreign keys, primary keys, not-

(U) RE: Very Strange data corruption

CLASSIFICATION: UNCLASSIFIED who knows -Original Message- From: Mike Johnson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 12:26 PM To: David Griffiths; [EMAIL PROTECTED] Subject: RE: Very Strange data corruption From: David Griffiths [mailto:[EMAIL PROTECTED] > MySQL rea

Re: Very Strange data corruption

David Griffiths wrote: MySQL really should throw an exception/error rather than just quietly trim your data and accept it. When your data is critical, and your business depends on it, you can't have bad data quietly going into the database. David. Mike Johnson wrote: A value is not valid just

RE: Very Strange data corruption

> -Original Message- > From: David Griffiths [mailto:[EMAIL PROTECTED] > MySQL really should throw an exception/error rather than just quietly > trim your data and accept it. When your data is critical, and your > business depends on it, you can't have bad data quietly going > into th

RE: Very Strange data corruption

From: David Griffiths [mailto:[EMAIL PROTECTED] > MySQL really should throw an exception/error rather than just quietly > trim your data and accept it. When your data is critical, and your > business depends on it, you can't have bad data quietly going > into the > database. Someone correct m

Re: Very Strange data corruption

MySQL really should throw an exception/error rather than just quietly trim your data and accept it. When your data is critical, and your business depends on it, you can't have bad data quietly going into the database. David. Mike Johnson wrote: From: Jeff McKeon [mailto:[EMAIL PROTECTED] Que

RE: Very Strange data corruption

or all the explanations.. Jeff > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 25, 2004 2:41 PM > To: Jeff McKeon > Cc: [EMAIL PROTECTED] > Subject: Re: Very Strange data corruption > > > > Jeff, > > You are try

Re: Very Strange data corruption

05/25/2004 02:29 Subject: Very Strange data corruption

RE: Very Strange data corruption

From: Jeff McKeon [mailto:[EMAIL PROTECTED] > Query: > > insert into > MIS.simcard(ID,ShipID,Service_Provider,SN,v1,v2,f1,d1,puk1,puk > 2,pin1,pin > 2,TwoStage,Status,DateAssigned,DateDisabled,UserID) > VALUES('NULL', '6889927707', '1', '8988169214000421398', > '881621456175', > '', '', '88169

Re: Very Strange data corruption

Set the fieldtype to 'bigint' It's the limit on int "Jeff McKeon" <[EMAIL PROTECTED]> 05/25/2004 02:29 PM To: <[EMAIL PROTECTED]> cc: Subject:Very Strange data corruption Query: insert into MIS.simcard(ID,ShipID

Very Strange data corruption

Query: insert into MIS.simcard(ID,ShipID,Service_Provider,SN,v1,v2,f1,d1,puk1,puk2,pin1,pin 2,TwoStage,Status,DateAssigned,DateDisabled,UserID) VALUES('NULL', '6889927707', '1', '8988169214000421398', '881621456175', '', '', '881693156175', '62982149', '', '', '', '1307', '1', '1085508771',

Re: *very* strange...

At 01:30 AM 3/20/2004, you wrote: > insert into table (username, password) values ('username', 'password') > > Skip out the "username=" and "password=" part. What you are ending up > doing here is that the values portion of the insert statement, these two You may kick my ass... Royally. Sorry, I

Re: *very* strange...

Hi, - Original Message - From: "Chris Knipe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 20, 2004 12:33 PM Subject: *very* strange... > Lo everyone, > > I'm *baffled* completely I've never seen something like this befo

Re: *very* strange...

On Sat, 2004-03-20 at 01:03, Chris Knipe wrote: > Lo everyone, > > I'm *baffled* completely I've never seen something like this before. > : I tried this exact query from PHP, Perl, as well as the MySQL > thingy... They ALL give the same result - it must therefore be my table > ...

Re: *very* strange...

> insert into table (username, password) values ('username', 'password') > > Skip out the "username=" and "password=" part. What you are ending up > doing here is that the values portion of the insert statement, these two You may kick my ass... Royally. Sorry, I feel like a phrick to say the le

*very* strange...

Lo everyone, I'm *baffled* completely I've never seen something like this before. : I tried this exact query from PHP, Perl, as well as the MySQL thingy... They ALL give the same result - it must therefore be my table mysql> SELECT VERSION(); ++ | VERSION() | +-

Re: Very strange problem

On Fri, Nov 07, 2003 at 09:16:03AM -0800, Eric Anderson wrote: > > A little explaination: [snip] > The threads connecting from the 1U (192.168.0.2) all start to block up > as expected, but when the length query on the e450 stops running, the > threads from the 1U stay blocked, and all NEW thread

RE: Very strange problem

ever actually process, until the max_connections are hit. It's very strange.. :-/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Very strange problem

Is anything being logged in the error log? -Original Message- From: Eric Anderson [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 11:16 AM To: [EMAIL PROTECTED] Subject: Very strange problem A little explaination: We've got two servers, e450 (3.23.47) and 1U (4.0.14).

Very strange problem

A little explaination: We've got two servers, e450 (3.23.47) and 1U (4.0.14). These two machines have a private connection between them (192.168.0.1 and 192.168.0.2). The e450 is the master server, and the 1U has a copy (no replication) of some basic data, so it can run server-intensive pages.

Re: Very strange MySQL problem !

I'd double check this cronjob script... possible scenario.. kaibash idea if you can prove it's invalid. "> ServerB has a script that runs every 20 minutes, which does a very quick/simple select from DB1, then loops though the results and does updates/deletes on a different database server." run

Re: Very strange MySQL problem !

On Wed, 13 Aug 2003, Keith Bussey wrote: > > Are you sure all connection attempts fail? not just insert attempts? > > Yes, i have it write to my log if the sock is empty (mysql_connect > fails)...before it gets to the insert But you mention mysql reports no connection errors... perhaps wait for

Re: Very strange MySQL problem !

That's the problem, when the script runs, I can connect from serverA fine!...but seems the webpages can't ;/ -- Keith Bussey Wisol, Inc. Chief Technology Manager (514) 398-9994 ext.225 Quoting [EMAIL PROTECTED]: > > On Wed, 13 Aug 2003, Keith Bussey wrote: > > > Are you sure all connection a

Re: Very strange MySQL problem !

Possible? Are you sure all connection attempts fail? not just insert attempts? Server B does some updates/deletes... Chances are this causes some table locks, which makes Server A unable to perform it's inserts until Server B releases the lock. On Wed, 13 Aug 2003, Keith Bussey wrote: > Hi,

Re: Very strange MySQL problem !

Quoting [EMAIL PROTECTED]: > Are you sure all connection attempts fail? not just insert attempts? Yes, i have it write to my log if the sock is empty (mysql_connect fails)...before it gets to the insert > Server B does some updates/deletes... Chances are this causes some table > locks, which m

Very strange MySQL problem !

Hi, I am having a very weird problem with one of my database servers. Let's take the following setup: 10 load-balanced servers (I'll call them ServerA) 1 admin server (ServerB) 1 database server (DB1) Now ServerA has a function to insert a row into a table on DB1 whenever someone hits certain pa

Very strange behavior with mysql_pconnect()

Hi, I'm getting some very strange (and nerve-wracking) behavior and hope someone here has some ideas. The subject says mysql_pconnect, but I get the same problem using mysql_connect. I'm using PHP 4.2 & MySQL 3.23.44 on Red Hat 7.2 In PHP I have a simple db class that more or le

Re: Very Strange problem.

Hi, I do commit alright. This doesn't happen often. i insert into the tables from a java web app. The db and the data in it is fine when i stop and restart the web server(tomcat). sometimes when i restart the machine, data is all intact. I was using the mysql 4 max before. Same thing happene

Re: Very Strange problem.

On Fri, May 03, 2002 at 11:04:29AM +0530, TP R Murthy wrote: > > I have created only one database with 18 tables. Only one of these tables > is MyIsam table. rest are BDB tables. When the server is up, it works > fine. but when i reboot the machine, few of the tables loose all the > records th

Very Strange problem.

Hi, I am new to this list. i could find solution to this problem on the net. i have a RH7.1 512Mb single intel processor. I have installed mysql-3.23.49a-max (binary). I have included the mysql.server script in the init dir and created links to it in rc6, rc5,rc3 and rc1 dir. I have create

Re: very strange query behavior

select count(*) from members where country_id = 1 and read_array is NULL ; Daren Cotter wrote: > can anybody explain this to me? > > mysql> select count(*) from members where country_id = 1 and read_array not > like '%20270%'; > +--+ > | count(*) | > +--+ > |34884 | > +-

RE: very strange query behavior

I would have to guess that you have a broken index. bill -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 3:50 PM To: [EMAIL PROTECTED] Subject: very strange query behavior can anybody explain this to me? mysql> select count(*) f

very strange query behavior

can anybody explain this to me? mysql> select count(*) from members where country_id = 1 and read_array not like '%20270%'; +--+ | count(*) | +--+ |34884 | +--+ mysql> select count(*) from members where country_id = 1 and read_array like '%20270%'; +--+ | coun

Re: very strange but reproducable error in 3.23.35

Tim Bunce writes: > On Mon, Mar 19, 2001 at 02:24:52PM +0200, Sinisa Milivojevic wrote: > > > > Hi! > > > > I tested your test case and you are right ! > > We've just discovered a very similar sounding problem immediately after > upgrading to 3.23.35. In our case an update is reporting

Re: very strange but reproducable error in 3.23.35

On Mon, Mar 19, 2001 at 02:24:52PM +0200, Sinisa Milivojevic wrote: > > Hi! > > I tested your test case and you are right ! We've just discovered a very similar sounding problem immediately after upgrading to 3.23.35. In our case an update is reporting 0 zero rows updated which then triggers an

Re: very strange but reproducable error in 3.23.35

"Gerald L. Clark" wrote: > > This does not answer your problem, but 'timestamp' is a reserved word. > ...not the complete truth ;-) : 7.34 Is MySQL picky about reserved words? A common problem stems from trying to create a table with column names that use the names of datatypes or functions b

Re: very strange but reproducable error in 3.23.35

This does not answer your problem, but 'timestamp' is a reserved word. Jan Legenhausen wrote: > > Hi, > > i just upgraded from 3.23.33 to 3.23.35 and found that a little script of > mine which simply modifys a table went mad completly. > I figured out a testcase which shows at least one of the

Re: very strange but reproducable error in 3.23.35

Hi! I tested your test case and you are right ! Thank you for a reproducible test case. We will fix it shortly. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mail

Re: very strange but reproducable error in 3.23.35

Jan Legenhausen writes: > > No other messages at all - simply repeating the query _does_ show the > expected. > - no message in the error log (...would have mentioned this... ;-) > - no special thing in the normal log: > 010318 20:41:44 7 Query alter table t_webmaster change lfd

Re: very strange but reproducable error in 3.23.35

> > > Hi! > > I have tested your case and it works just fine for me. > > What error message do you get ?? What i wrote was all i got - so there's just > mysql> update t_webmaster set status=1 where type='Open'; > Query OK, 0 rows affected (0.01 sec) No other messages at all - simply repeating

Re: very strange but reproducable error in 3.23.35

Jan Legenhausen writes: > Hi, > > i just upgraded from 3.23.33 to 3.23.35 and found that a little script of > mine which simply modifys a table went mad completly. > I figured out a testcase which shows at least one of the strange things > which happen: > > Table definition and data: >

very strange but reproducable error in 3.23.35

Hi, i just upgraded from 3.23.33 to 3.23.35 and found that a little script of mine which simply modifys a table went mad completly. I figured out a testcase which shows at least one of the strange things which happen: Table definition and data: CREATE TABLE t_webmaster ( lfdnr int(10) unsigne