Shon Stephens wrote: > > i have an application that will allow me to rotate mysql table using > date variable substition. in other words > > table=tblname.%m%d%Y > > if i am using a remote system to host the application, what
Host doesn't matter. "localhost" and remote hosts are processed in the same manner. > permissions to i need to give the remote application user so that it > can properly select,update,insert records into existing tables, and > create new tables as it needs to? grant create,select,insert,update on db.* to 'user'@'host' -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Alexander Barkov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia <___/ www.mysql.com +7-902-856-80-21 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php