RE: secure host and user name for non static ip address

> QUESTION: What are the most secure permissions settings for > administrator > access to connect to my server without using a static IP address? Assuming a unix server (or even a windows server running SSH), use an SSH tunnel, and then connect to 127.0.0.1:whatever_port_you_chose. You get the e

open_files_limit problem.

I am trying to change this value and it doesn't seem to work. Looking at the processes I have: mysql 21752 0.0 0.1 1652 1092 p3 I 3:50PM 0:00.01 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysq

Re: Trigger

Michael, im converting the unixtime to "normal" time with from_unixtime. So after i did the convertion i write the result to the table. It works ok when i write to a varchar column, but not to a date column - "Michael Dykman" <[EMAIL PROTECTED]> escribió: > That is a common symptom of some con

Trigger

Hi, I have a problem with a trigger which should conver a unix timestamp to a MySQL date datatype. The trigger works if the column is varchar, but when the column is date type, it write the date of 1969-31-12. Any ideas? DROP TABLE IF EXISTS `visitas`; CREATE TABLE `visitas` ( `id` int(1

RE: need advice on how to design tables for recurring events

This and Frederic Wenzel's suggestions were exactly what I was looking for. Thanks! Bob > -Original Message- > From: Erich C. Beyrent [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 11, 2007 6:10 AM > To: mysql@lists.mysql.com > Subject: Re: need advice on how to design tables for re

sequential numbering in Auto_Increment Field across two tables

I have two tables. TableA is current data. TableB (created with 'Create Table A like Table B' ) is an archive where deleted data is inserted from Table A before being deleted from table B with "INSERT INTO TableA Select * , Null, NOW (), 'ACTION', 'USER' from TableA. The null column in TableB

Re: Unbiased opinion needed on access control procedure

Dont trust anything, The more secure you can be the better, What happens if you have not patched a single server (maybe you are testing) then someone gets into it and then has unrestricted access to all the DB's.. Never trust your own users even, If the data is worth money to you it is worth more

Re: secure host and user name for non static ip address

My take on this never have no password.. At no time any data you have someone else will also want therefore running a open query with nopasword on the system for a couple of hours will get access to your system.. Allways use passwords, If the users dont want passwords then you dont need any membe

Re: need advice on how to design tables for recurring events

I've been working with Drupal for some time, and there is a module that allows you to create event-based content with a repeating schedule. The schema that it uses may be of some help to you. CREATE TABLE IF NOT EXISTS event_repeat ( rid int(10) unsigned NOT NULL default '0', repeat_data longt

Re: need advice on how to design tables for recurring events

On 10/10/07, Ramsey, Robert L <[EMAIL PROTECTED]> wrote: > I'm looking for a "best practices" way of creating tables to store both > one time and regularly repeating events. These are classes, so for the > most part the have a regularly recurring time, but we do have some one > off events. (...) >