On Wednesday 09 July 2003 00:53, Nils Valentin wrote:
Hi Rudy,
How about changing the port number in my.cnf and restarting the server ?
All clients will look on the wrong port number and not be able to connect.
That should do it while you take your backup.
When finished change the port
Dear all,
Is there a way to start mysqld in a way, that say only a superuser can
connect. I would need this e.g. for restoring a backup, because I do not
want users to connect to the server while I restore the binary log.
I already check the options for mysqld but could not find anything
I wonder if you could make a backup of your original users table, then make one
of JUST your super user... Then when you go to do your back up you would copy
your table with JUST your super user in there and go to work... After you are
done with the backup copy your old table back and restart
Hi Rudy,
How about changing the port number in my.cnf and restarting the server ?
All clients will look on the wrong port number and not be able to connect.
That should do it while you take your backup.
When finished change the port number back to 3306.
Best regards
Nils Valentin
Tokyo/Japan
/ superuser only
Dear all,
Is there a way to start mysqld in a way, that say only a superuser can
connect. I would need this e.g. for restoring a backup, because I do not
want users to connect to the server while I restore the binary log.
I already check the options for mysqld but could