#2406 astjohn@netgeekservers.com

1.250
open
5
2006-01-29
2006-01-29
Anonymous
No

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
>>>

Discussion

  • 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

    Jamie Cameron - 2006-02-14

    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?

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks