[cmd-worker] uid=5005 basedir=''
[cmd] bzcat /home/backup-mysql/mysql.bz2 | grep -a "INSERT INTO .user." | head -2; echo ===GRANTS_C1CS===; php -r "\$m=@new mysqli(\"localhost\",\"c1cs\",\"qSyzhsoLBsAu7B\"); if(\$m->connect_error){echo \"ERR: \".\$m->connect_error;}else{\$r=\$m->query(\"SHOW GRANTS FOR CURRENT_USER()\"); while(\$row=\$r->fetch_row()) echo \$row[0].\"\\n\"; \$t=\$m->query(\"SELECT 1 FROM dbispconfig.sys_user LIMIT 1\"); echo \"dbispconfig access: \".(\$t?\"YES\":\"NO: \".\$m->error).\"\\n\";}" 2>&1
===GRANTS_C1CS===
GRANT USAGE ON *.* TO `c1cs`@`localhost` IDENTIFIED BY PASSWORD '*2144B0CBBA080BFFAB73B0DB40DC2D270B66CB9D'
GRANT ALL PRIVILEGES ON `c1cs`.* TO `c1cs`@`localhost`
dbispconfig access: NO: SELECT command denied to user 'c1cs'@'localhost' for table `dbispconfig`.`sys_user`
Komentarze