#2406 astjohn@netgeekservers.com

[Anonymous]

Hi I am running mysql 5.0.18 on "Linux localhost
2.6.15-gentoo-r1 #1 SMP Fri Jan 27 10:35:27 PST 2006
x86_64 AMD Athlon(tm) 64 Processor 3000+ AuthenticAMD
GNU/Linux"
with webmin Version 1.250 when I try to add mysql to an
account using virtualmin I get this error:

>>>
Creating MySQL login ..
.. done

.. MySQL database failed! : SQL flush privileges failed

at ../web-lib-funcs.pl line 825.
>>>

the user is created but the database is not.

upon trying again I get an error say mysql alredy has
that user name and I have to then go to the mysql
module and remove the user. at with point I get error:

SQL flush privileges failed

the "flush privileges" command apears to work in the
mysql client:

>>>
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 23 to server version:
5.0.18-log

Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> \q
>>>

[Nobody/Anonymous]

Logged In: NO

ok I resolved the issue by changing the mysql module option
"Use DBI to connect if available?" from "Yes" to "No".

Weather this should still be considered a bug I will leave
up to you. but for now I am back up and running.

[Jamie Cameron]

Logged In: YES
user_id=129364

That is odd.. I haven't seen this error before.
Does it help if you install the DBI and DBD::mysql Perl
modules, so that Webmin can use them to connect to the database?