Re: [webmin-l] Access denied for user

[Jamie C. <jca...@we...>]

There is actually a bug in Usermin that causes this.
To fix it, you can either grant all mysql users access to the 'mysql' database, or upgrade
Usermin from http://www.webmin.com/devel.html .

 - Jamie

On 4/Sep/2006 01:42 Munzir Taha (=?utf-8?q?=D9=85=D9=86=D8=B0=D8=B1?=  =?utf-8?q?_=D8=B7=D9=87?=) wrote ..
> 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?