I'm setting up a cron job to run myisamcheck with the options
-Aacmorv. As I have to put in a username and password, for security I
want to create a special account that has the minimum required rights.
In searching the docs I don't find this listed.
Dan Nelson wrote:
In the last episode (Jun 24), Jim Shea said:
I'm setting up a cron job to run myisamcheck with the options
-Aacmorv. As I have to put in a username and password, for security I
http://dev.mysql.com/doc/mysql/en/GRANT.html lists the available
privileges and http
I want to create a user that has the minimum rights to dump a database. I
can't find a discussion of the minimum required rights in the MySQL docs.
Included in my searching was:
5.4.3 Privileges Provided by MySQL
http://www.mysql.com/doc/en/Privileges_provided.html
and
8.7 mysqldump, Dumping
On 2/27/04, 10:12:56 AM, Jim Shea [EMAIL PROTECTED] wrote regarding
Minimum privileges required for mysqldump:
I want to create a user that has the minimum rights to dump a database. I
can't find a discussion of the minimum required rights in the MySQL docs.
At 2/27/2004 08:35 AM, [EMAIL
At 2/27/2004 10:56 AM, [EMAIL PROTECTED] wrote:
Give the use the lock option if you plan on using the --opt.
How is that different than
Giving the lock tables permission as in:
grant select, lock tables on dbname.* to [EMAIL PROTECTED];
results in the same mysqldump error.
in the previous