Get General Log and Binary Log location from MySQL database.

2004-08-11 Thread Aleksandar Mihajlovic
I am using MySQL 4.1.3 and wondering if there is any way to get binary log, and general log location by querying database. I've checked mysql> show variables; command, but it only returns if log is ON or OFF. Thanks, Aleksandar - Do you

MySQL Privileges

2004-05-17 Thread aleksandar . mihajlovic
Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use mysql ERROR 1044 (42000): Access denied for user: 'fabackup'@'localhost' to database 'mysql' mysql> Am I doing something wrong here, or this

Password displayed in process list

2004-05-30 Thread Aleksandar Mihajlovic
Hi, I am new to MySQL and have one question. I would like to run mysql job as a batch job (scheduled through cron) and have to provide password to the batch job: mysql -udba -ppassword My concern that anybody running: ps -ef will be able to see the password when job is run. Is there