[webmin-l] Access denied for user

[Munzir T. ( ) <mun...@gm...>]

Hi,
In usermin, trying to backup the database gives:
DBI connect failed : Access denied for user 'myuser'@'localhost' to 
database 'mysql'

So, I set the option
Use DBI to connect if available? no

Now, I am getting:
SQL show character set failed :  Access denied for user 'myuser'@'localhost' 
to database 'mysql'

I also changed the option:
Database access control list, in username: db1 db2 format.
MySQL permissions also apply from
myuser: mydb
to
myuser: mydb mysql
to no avail.

However, from the command line if I did:
mysqldump -umyuser -p mydb > mydb.dump
It works great!

Any hint please?


-- 
Munzir Taha
Telecommunications and Electronics Engineer
Maintainer of Fedora Arabic Translation Project
https://listman.redhat.com/mailman/listinfo/fedora-trans-ar
Maintainer of the OpenBugs project page at
http://www.arabic-fedora.org/munzir/OpenBugs.html
Master CIW Designer, ICDL, MOUS, Linux+, LPI 101
Riyadh, SA