Hello,
I've got one last issue removing user accounts.
I notice I have a usera 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 for '
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
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
: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).
SW Until now we've used the Debian package of MySQL (latest deb. version),
SW however
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 perfectly, my data is now on the new
machine. I did have
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
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