Hello,
I've got one last issue removing user accounts.
I notice I have a user " " & a number "nobody".
However when I look at the grants I get an error;
mysql> show grants for nobody@localhost;
ERROR 1141: There is no such grant defined for user 'nobody' on host
'localhost'
mysql> show grants
Hello,
I have a system running MySQL with old user accounts I wish to remove.
I am looking for a command to delete all user that do not have access to any
databases.
Does anyone know of such a command ??
With Thanks,
Steve.
Hi
I want to limit the databases users can see to the databases they have access
to. I have read the manual & know I can use safe_show_databases or
skip_show_databases.
However if I add either of these lines to my.cnf mysql fails to start;
set-variable= safe_show_database
set-variable=
Just to clarify;
My understanding now,
If I delete row 14 (example) the next time I create any data in my database
it will be put in the now slack space that used to contain row 14 ?
if it does not entirely fit in this space, the data that did not fit will be
put in the next empty / slack spa
I've had a dig around the mysql website / google & can't find an answer so
maybe someone here can help...
we've noticed data/records deleted from mysql databases still appear to exist
in the /var/lib/mysql/database/ files ?
I presume they are flagged for deletion at a later date, if this is t
Ok, I follow that, in future when moving databases I will use mysqldump.
However, I still wish to know why moving the databases by duplicating the
files & directory structure does not work. This is 100% repeatable and I
can't see why (unless file(s) exist I am not copying).
If for some reason s
gt; If you want to do that, you have to flush all tables and shut the
> server down, IIUC. Then it should work, I think - and I think we
> did this before, but I am not sure.
>
> Steve Wright schrieb am Dienstag, 7. August 2001, 10:40:04:
> > I've tried mysqldump, it worked pe
te |Mon, 6 Aug 2001 13:51:09 +0100
> From |Steve Wright <[EMAIL PROTECTED]>
>
> Hello!
>
>
> SW> Hi,
> SW> Wondering if anyone can here can help,
> SW> We've got a small selection of MySQL databases used by our customers
> (for SW> websites).
>
Hi,
Wondering if anyone can here can help,
We've got a small selection of MySQL databases used by our customers (for
websites).
Until now we've used the Debian package of MySQL (latest deb. version),
however the systems are being updated & we're starting to use source builds,
(this
