Re: SSH tunnels and non root accounts get the server service or the configuration file could not be found

In my email I state quite clearly that tunnel is working with the root account so it's not a matter of ports. The error message shows that is trying to get some configuration from the user account that is not working. Under root account I have found a file called .my.cnf with a [client] entry

Re: SSH tunnels and non root accounts get the server service or the configuration file could not be found

Miguel, Probably your non-root user is connecting as the anonymous account. Try this: Connect as your (problematic) non-root account and do this: mysql SELECT USER(); mysql SELECT CURRENT_USER(); What do you see? If it's as I imagine you should see different values and so just delete the

Re: SSH tunnels and non root accounts get the server service or the configuration file could not be found

I'm confused. Where should I issue those commands? I have connected in the linux box with that user and when I start the mysql client I issue those commands and I get the same result. Do I have to issue those commands (where?) in the mysql administrator? When I log in through the mysql

Re: SSH tunnels and non root accounts get the server service or the configuration file could not be found

Hi Miguel, I'm confused. Where should I issue those commands? Yes from the MySQL Administrator. From what you say it seems that you end up being authenticated as the ''@'localhost' user. Connect again with the MySQL Administrator and the non-root account and issue: mysql SHOW GRANTS;

Editing existing Trigger MySQL 5.6

Hi, Using Workbench with MySQL 5.6 how do I edit a existing Trigger. Do I need to DROP the Trigger and create a new one ? If that is the case how can you run start command in a live environment ? Thanks Neil

Temporary Tables with Triggers Problem

Hi, I've a trigger that writes some data to a temporary table; and at the end of the trigger writes all the temporary table data in one insert to our normal Innodb table. However, for some reason the trigger isn't copying the table from the temporary table to the Innodb table. If I write in the

Re: Temporary Tables with Triggers Problem

can you please share the code of the trigger. Any kind of error your getting On Wed, May 29, 2013 at 6:49 PM, Neil Tompkins neil.tompk...@googlemail.com wrote: Hi, I've a trigger that writes some data to a temporary table; and at the end of the trigger writes all the temporary table data

Re: Temporary Tables with Triggers Problem

This is my Trigger which doesn't seem to work; but doesn't cause a error DROP TEMPORARY TABLE IF EXISTS tempHotelRateAvailability; CREATE TEMPORARY TABLE tempHotelRateAvailability(AuditTrailId varchar(36),UserId bigint(20),ActionType enum('INSERT','UPDATE','DELETE'),TableName

Re: Editing existing Trigger MySQL 5.6

2013/05/29 10:39 +0100, Neil Tompkins Using Workbench with MySQL 5.6 how do I edit a existing Trigger. Do I need to DROP the Trigger and create a new one ? If that is the case how can you run start command in a live environment ? Whatever appearance Workbench adds (I do not know it),

Re: Temporary Tables with Triggers Problem

did u check if data is getting inserted into tempHotelRateAvailability On Wed, May 29, 2013 at 7:21 PM, Neil Tompkins neil.tompk...@googlemail.com wrote: This is my Trigger which doesn't seem to work; but doesn't cause a error DROP TEMPORARY TABLE IF EXISTS tempHotelRateAvailability;

Re: Temporary Tables with Triggers Problem

I took the following lines of code slightly modified and it returned some data using a normal Query Editor CREATE TEMPORARY TABLE tempHotelRateAvailability(AuditTrailId varchar(36),UserId bigint(20),ActionType varchar(36),TableName varchar(36),RowKey varchar(255),FieldName varchar(36),OldValue

Re: Temporary Tables with Triggers Problem

But, does it work inside the trigger. If not, then based on the logic, there will not be any data, and data goes not get inserted from temp table to innodb table On Wed, May 29, 2013 at 7:29 PM, Neil Tompkins neil.tompk...@googlemail.com wrote: I took the following lines of code slightly

Re: Temporary Tables with Triggers Problem

OK, the data is going into the temp table. But when I run the command INSERT INTO AuditTrail SELECT tempHotelRateAvailability.* FROM tempHotelRateAvailability; from the TRIGGER it does not copy the data. However if I run this query INSERT INTO AuditTrail SELECT tempHotelRateAvailability.* FROM

Re: Temporary Tables with Triggers Problem

2013/05/29 14:51 +0100, Neil Tompkins This is my Trigger which doesn't seem to work; but doesn't cause a error DROP TEMPORARY TABLE IF EXISTS tempHotelRateAvailability; CREATE TEMPORARY TABLE tempHotelRateAvailability(AuditTrailId varchar(36),UserId bigint(20),ActionType

RE: Bug in BETWEEN same DATETIME

(To ramble in a slightly different direction...) I claim that the world gained half a second when we went from round time to square time a few decades ago. Before then, announcers on radio/tv would look at their round-shape analog clock to see what time it was; they would perform a ROUND()