sslug-teknik team mailing list archive

Re: sikker backup af mysql db

To: sslug-teknik@xxxxxxxx
From: Atte André Jensen <atte@xxxxxxxxxxxxxx>
Date: Fri, 27 Feb 2009 11:17:32 +0100
Delivered-to: mailing list sslug-teknik@xxxxxxxx
Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAAAXNSR0IArs4c6QAAABhQTFRF ExQSMzUyTE5LamxpiIqHq62p0NLP6uzoQWtXFgAAAgJJREFUOMtlk9114yAQhdkODEnOPgvZKQDs FBAgDVjDNmBGFVhqP3dAMvZZHufjcucPxczzWg/TFGMM3ls5iucOEI++g9IAc3lV8L2C5T9QlicQ EHe7ojlswHcwdxBF0eI1qx0gXe/Hbh6rhgvRJC91DxKwEFXB+cmDHmWHV1AQn+Hs23GD1g0s4ly8 9V4sLOLa7OkuHEmbMQWJm6c6Fl6z8/ZCQe7rXjnALTh7KddBH9T2VANLCW784YD7qmpUnZOUDZDv 37hthk3BDUSf5uI2hw7QjsRr2Yp4AZTn9easfqTbAFqY1/WGSFOMDawNLFeEhqo4Kd7SworMS7D7 +XwCfr4Ht4OfDTBP4QKwOdiRd1Am/7WWYIcGjh0EH/PNb9b2UwD9kwH6RHR7VPHF6vug/gJMF0rS dNNAZvUW/UlAphSd081kZFZHO6Z5LcREAIOpaZ0EnNG8hXNBu5yHt6nerE5J9orpKn/DWWOkvUdi 9UGEPeEpyaLIgshbGK/6iGg3CieUUgHctcJ5j3gKrUJ3J5kGBMNBwNuU5jqPKU1eCGYocaUF4C1k G6tC60MDMVZQ96QB1cB7zHVNADCnh0BpE8SkIDHfJDvQ45nR9oyJ4Avs1gKMz/IQyU/uFnVRLwAl BVvBoQM9ZtQR4TB0gfojbThnrKh7KmID2iQI8L+7tfoFfr8bM7YNgScAAAAASUVORK5CYII=
In-reply-to: <49A7BA78.1060009@imf.au.dk>
Mailing-list: contact sslug-teknik-help@xxxxxxxx; run by ezmlm
Newsgroups: sslug.teknik
Organization: SSLUG
User-agent: Thunderbird 2.0.0.19 (X11/20090105)

Lars Madsen wrote:

er det ikke bare en bruger som har select rettigheder på alle databaserevt. låse rettigheder


Ok, sådan her:

GRANT Select ON *.* TO backup@localhost IDENTIFIED BY 'password';

--
Atte