Re: Check table script
Jean Hagen wrote: Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line, plug in the password at the prompt, and everything works. When I put this exact command into an executable file, and add the '=[pswd]' argument, I get an access denied error message: /usr/local/mysql/bin/mysqlcheck: Got error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) when trying to connect p.s. I've used this exact method on mysqldump, and it works. Any suggestions? Anyone have a mysqlcheck script that they run via cron? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Jean, Have you tried adding [mysqladmin] user=root password=blabla to the .my.cnf file for the user running the script? walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Check table script
At 15:14 -0500 8/4/03, Jean Hagen wrote: Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line, plug in the password at the prompt, and everything works. When I put this exact command into an executable file, and add the '=[pswd]' argument, I get an access denied error message: -p doesn't take '=[pswd]'. If you wrote something like -p=pswd, it would take the '=' character as part of the password. You should use either -ppswd (no intervening space) or --password=pswd if you want to do this. /usr/local/mysql/bin/mysqlcheck: Got error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) when trying to connect p.s. I've used this exact method on mysqldump, and it works. Any suggestions? Anyone have a mysqlcheck script that they run via cron? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Check table script
At 16:57 -0400 8/4/03, walt wrote: Jean Hagen wrote: Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line, plug in the password at the prompt, and everything works. When I put this exact command into an executable file, and add the '=[pswd]' argument, I get an access denied error message: /usr/local/mysql/bin/mysqlcheck: Got error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) when trying to connect p.s. I've used this exact method on mysqldump, and it works. Any suggestions? Anyone have a mysqlcheck script that they run via cron? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Jean, Have you tried adding [mysqladmin] user=root password=blabla to the .my.cnf file for the user running the script? You probably meant to say the [mysqlcheck] group here. The [mysqladmin] group would be read only by the mysqladmin program. walt -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]