2007/8/21, Jay Pipes <[EMAIL PROTECTED]>:
> Terry wrote:
> > Hello,
> >
> > I want to grant a user all permissions to all DBs on the system as
> > well as any new DBs that show up. I want to avoid having to modify
> > permissions everytime a new DB is added. Is there a way to do this?
>
> GRANT S
OK. I am just a little pumped up these days.
I just passed my Certification Exams.
Chapter 34 of the Certification Book is still fresh in my mind.
Even though I'm in the US, Cheers everybody !!!
Jay Pipes <[EMAIL PROTECTED]> wrote:
Terry,
I absolutely agree with Rolando on this.
Rol
Terry,
I absolutely agree with Rolando on this.
Rolando,
Although I agree with you, I was only trying to answer Terry's question :)
Cheers,
Jay
Rolando Edwards wrote:
You must be very careful when granting permissions on every database this way.
Here is why:
By giving a user permissions o
You must be very careful when granting permissions on every database this way.
Here is why:
By giving a user permissions on all databases this way,
you also give away permissions to the 'mysql' schema.
This is where the grant tables live.
A person could
1) insert new users into mysql.user like t
Yep.
Terry wrote:
Just to verify, will that include all new databases?
On 8/20/07, Jay Pipes <[EMAIL PROTECTED]> wrote:
Terry wrote:
Hello,
I want to grant a user all permissions to all DBs on the system as
well as any new DBs that show up. I want to avoid having to modify
permissions every
Just to verify, will that include all new databases?
On 8/20/07, Jay Pipes <[EMAIL PROTECTED]> wrote:
> Terry wrote:
> > Hello,
> >
> > I want to grant a user all permissions to all DBs on the system as
> > well as any new DBs that show up. I want to avoid having to modify
> > permissions everyti
Terry wrote:
Hello,
I want to grant a user all permissions to all DBs on the system as
well as any new DBs that show up. I want to avoid having to modify
permissions everytime a new DB is added. Is there a way to do this?
GRANT SELECT, INSERT, CREATE, ... ON *.* TO 'username'@'hostname'
IDE
Hello,
I want to grant a user all permissions to all DBs on the system as
well as any new DBs that show up. I want to avoid having to modify
permissions everytime a new DB is added. Is there a way to do this?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
A common issue a lot of people have is this
rm logfile
if the mysql server is still accessing that file it will not continue to
write to that file again till mysql is restarted
if that was the case the proper way to clear a log and keep the server
running is
cp /dev/null logfile
On 8/20/07, Br
Have you had any errors in the last 2 weeks? Have you restarted your
server in the last 2 weeks? Your problem might just be a symptom of
no problem at all.
- michael
On 8/20/07, Brown, Charles <[EMAIL PROTECTED]> wrote:
> Hello all.
>
> I noticed that the last entry in mysql error log was two
Hello all.
I noticed that the last entry in mysql error log was two weeks ago. Can
some one tell me why mysql is not writing to this log
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONF
If you can't access functions directly, you could implement a trigger
on that row to intercept the password as it being written and do your
MD5 encoding there.
- michael
On 8/18/07, C K <[EMAIL PROTECTED]> wrote:
> Thanks to all,
> but the problem is that I am using external programs to insert
Hi N.N., all !
heocon wrote:
I have program with data accessed by MySQL. In my assume, I copy program and
its data files to my friends, and they run program with pleased faces. And
now, the first friend wants to delete all program related data files and
copy program related data files from seco
13 matches
Mail list logo