mysqldump: Got error: 1044

[savago]

Server version: 5.1.22-rc-log FreeBSD

proxy# crontab -l
0 3 * * * root /usr/sbin/freebsd-update cron

*/5 * * * * /usr/abills/libexec/billd -all
1 0 * * * /usr/abills/libexec/periodic daily
1 1 * * * /usr/abills/libexec/periodic monthly
1 3 * * * /usr/abills/libexec/periodic backup
proxy# /usr/abills/libexec/billd -all
proxy# /usr/abills/libexec/periodic daily
proxy# /usr/abills/libexec/periodic monthly
-- Connecting to localhost...
mysqldump: Got error: 1044: Access denied for user 'abills'@'%' to database 'abills' when using LOCK TABLES
proxy# /usr/abills/libexec/periodic backup
-- Connecting to localhost...
mysqldump: Got error: 1044: Access denied for user 'abills'@'%' to database 'abills' when using LOCK TABLES
proxy#

phpadmin priv,

Users having access to "abills"
User Host Type Privileges Grant Action
abills localhost database-specific SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER No Edit Privileges
root 127.0.0.1 global ALL PRIVILEGES Yes Edit Privileges
root localhost global ALL PRIVILEGES Yes Edit Privileges
root test global ALL PRIVILEGES Yes Edit Privileges

[Abram]

В phpMyAdmin поставь usage в привилегиях.

[savago]

В phpMyAdmin поставь usage в привилегиях.

tak bilo sdelano

User Host Password Global privileges Grant
abills % Yes USAGE No
abills localhost -- USAGE No
root 127.0.0.1 Yes ALL PRIVILEGES Yes
root localhost Yes ALL PRIVILEGES Yes
root test Yes ALL PRIVILEGES Yes

[ran]

да поставь ты усеру абиллс все привилегиии на базу abills и не мучайся