Hi,
What is the command to create log file while executing mysql
command.
I.e I want to run a file using mysql as follows
Mysql -uroot db_name < "Inputfile"
I want to log the above results into a log file, to do the same
what option I have to use here with mysql command.
PS: Input file contains some sql statements.
Please help me in this. This is very urgent.
Thanks,
Narasimha
-----Original Message-----
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 09, 2005 11:16 PM
To: mysql@lists.mysql.com
Subject: Re: Access Denied
Hello.
Right. No need to FLUSH PRIVILEGES after GRANT.
My fault, sorry.
Michael Stassen <[EMAIL PROTECTED]> wrote:
>
> Gleb Paharenko wrote:
>> Hello.
>>
>> Execute FLUSH PRIVILEGES after granting.
>> See:
>> http://dev.mysql.com/doc/mysql/en/flush.html
>> http://dev.mysql.com/doc/mysql/en/privilege-changes.html
>
> Yes, please read this one. FLUSH PRIVILEGES is NOT needed after
GRANT,
> REVOKE, or SET PASSWORD. You only need to FLUSH if you directly edit
the
> grant tables (INSERT, UPDATE, DELETE). Since he/she is using GRANT,
FLUSH
> PRIVILEGES is unlikely to be relevant.
>
>> http://dev.mysql.com/doc/mysql/en/access-denied.html
>> http://dev.mysql.com/doc/mysql/en/user-resources.html
>>
>> Connect to the server using mysql command line client using specified
in GRANT statement
>> username and password to check that the problem not in MySQL server.
What output does the
>> following statement produce:
>>
>> SHOW GRANTS FOR 'metal-host'@'localhost';
>
> Run this when it works, and then again when it doesn't. If the result
is
> different, then something is changing the privileges assigned to
> [EMAIL PROTECTED], so the solution will involve finding what is
doing
> that. If the privs are the same, then we need to look elsewhere.
>From the
> (not entirely clear) description, I expect the first case.
>
>> What exact version of MySQL server do you use?
>>
>> [snip]
>>
>> Hello Gleb, no i m not doing flush..i dont even know what flush is.
>> do u have anything in mind ?
>>
>> [snip]
>>
>
> Michael
>
>
> Metal Host Contact wrote:
>
> > I have installed in a single user called "metal-host" more than 10
> > databases all with different names and in different php scripts
(phpbb
> > phpnuke mambo etc).
> > the problem is that they only work as I install them,after some hour
later
> > all the scripts show me that error : Access denied for user:
> > '[EMAIL PROTECTED]' (Using password: YES) ....
> > then im trying to do : GRANT ALL PRIVILEGES ON somethign.* TO
> > [EMAIL PROTECTED] IDENTIFIED BY "password"; and then each
database that
> > i re-give the GRANT all command works perfectly..but for 1 minute
> > only,then it gives me the same : Access denied for user:
> > '[EMAIL PROTECTED]' (Using password: YES) .... So is there any
> > limitation for the number of DBases that each user should
> > run ?
> >
>
--
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
Confidentiality Notice
The information contained in this electronic message and any attachments to
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [EMAIL
PROTECTED] immediately
and destroy all copies of this message and any attachments.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
