[larsen]

And it wouldn´t be more useful if it could?

Using the workaround I couldn´t select cell data from some cells of a column without also selecting the text of the rows inbetween.

[larsen]

Works as expected now. Thx!

[larsen]

Thanks a lot for that information!

[larsen]

So, I would need a thread (it´s a Java program) that continuously checks wether DST has started/ended and according to that change the connection´s timezone???

Any idea why MySQL doesn´t simply use the server´s time? I guess there must be some reason.

(and all this affirms me that I don´t like DST – time shouldn´t jump 😉

[larsen]

Thx a lot for the quick fix!

[larsen]

PS: SQLyog is 8.32 community on Windows XP SP3

[larsen]

“wait_timeout” is set to “28800”. It certainly is a Kaspersky issue as I can disable KAV and get rid of that annoying feature =)

[larsen]

'peterlaursen' wrote on '31:

But anyway please tell: Doesn't SQLyog reconnect seamlessly?  Does KAV prevent that or does it cause some slowness? 

SQLyog works just fine, it just needs around 45-60 seconds to reconnect according to my co-worker. “Feels” less at my PC, but still 15-30 seconds.

[larsen]

Ok, I already did that.

[larsen]

Hmm, it could be that we are not talking about the same thing:

The db itself is without a backslash. It´s the entry in the table mysql.db that has a backslash.

[larsen]

This too is not urgent.

[larsen]

No, certainly not urgent. Do as you like =)

And thanks for the quick support! I am repeatedly astonished about the response times 😉

[larsen]

yes, the username is limited to 16 chars so we have to abbreviate it, but this is sufficient to distinguish several domains.

I now tested with a 5.1.41 MySQL server on Windows and the “problem” still shows up. Umm, I just noticed that I forgot to mention the fieldname “Db” in my first post and that you were testing with the username. Could you please test it with an underscore in the db name and not in the username?

mysql.user:

Code:

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 Show_db_priv Super_priv Create_tmp_table_priv Lock_tables_priv Execute_priv Repl_slave_priv Repl_client_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Create_user_priv Event_priv Trigger_priv ssl_type ssl_cipher x509_issuer x509_subject max_questions max_updates max_connections max_user_connections
——— —— —————————————– ———– ———– ———– ———– ———– ——— ———– ————- ———— ——— ———- ————— ———- ———- ———— ———- ——————— —————- ———— ————— —————- —————- ————– ——————- —————— —————- ———- ———— ——– ———- ———– ———— ————- ———– ————— ——————–
localhost test *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx N N N N N N N N N N N N N N N N N N N N N N N N N N N N 0 0 0 0

mysql.db:

Code:

Host Db User Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Grant_priv References_priv Index_priv Alter_priv Create_tmp_table_priv Lock_tables_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Execute_priv Event_priv Trigger_priv
——— ———- —— ———– ———– ———– ———– ———– ——— ———- ————— ———- ———- ——————— —————- —————- ————– ——————- —————— ———— ———- ————
localhost my_db test Y Y Y Y Y N N N N N N N N N N N N N N

[larsen]

'peterlaursen' wrote on '24:

.. and next inspect the HEX pattern and see if the “” character is stored or not.

I did this and the backslash is not contained within the returned hex value.

Quote:

It may depend on server version.

MySQL server is 5.0.32-Debian_7etch12-LOG

Quote:

I have never observed such users created on our own PLESK managed servers.  Can you provide more details of this (when it does, why it does etc.)?

We create those users on our own and use the domain to which they belong as a username. Points are replaced with underscore by us. So, for a database on the domain “example.com” the username will be “example_com”.

[larsen]

I can live with it, now that I know the behaviour, and I don´t regularly use the mysql.user table either. What eventually means that I will forget the behaviour till next time I have to use it 😉

If I can help with testing, please let me know.

[Author]

Posts