problem creating database in mysql

[jamuse at gmail.com (Jamuse)]

On 9/16/07, H D Moore <hdm at metasploit.com> wrote:
> The creation uses command line tools,

which ones?

> the connect uses ActiveRecord. Ddi
> you try it after you specified the database name (after the /)?

Yes.
As I mentioned removing the database works fine:
msf > db_destroy root at localhost/metasploit3
Database "metasploit3" dropped

and when I create the database, the database gets created but I get
the following error message:
=======================================================================
msf > db_create root at localhost/metasploit
[*] Database creation complete (check for errors)
[-] Error while running command db_create: This plugin failed to load:
 Failed to connect to the database

Call stack:
/usr/local/src/trunk/plugins/db_mysql.rb:139:in `cmd_db_create'
./lib/rex/ui/text/dispatcher_shell.rb:230:in `send'
./lib/rex/ui/text/dispatcher_shell.rb:230:in `run_command'
./lib/rex/ui/text/dispatcher_shell.rb:196:in `run_single'
./lib/rex/ui/text/dispatcher_shell.rb:191:in `each'
./lib/rex/ui/text/dispatcher_shell.rb:191:in `run_single'
./lib/rex/ui/text/shell.rb:125:in `run'
./msfconsole:77
=======================================================================

Likewise just connecting to the database returns the following error:

======================================================================
msf > db_connect root at localhost/metasploit
[-] Error while running command db_connect: This plugin failed to
load:  Failed to connect to the database

Call stack:
/usr/local/src/trunk/plugins/db_mysql.rb:73:in `cmd_db_connect'
./lib/rex/ui/text/dispatcher_shell.rb:230:in `send'
./lib/rex/ui/text/dispatcher_shell.rb:230:in `run_command'
./lib/rex/ui/text/dispatcher_shell.rb:196:in `run_single'
./lib/rex/ui/text/dispatcher_shell.rb:191:in `each'
./lib/rex/ui/text/dispatcher_shell.rb:191:in `run_single'
./lib/rex/ui/text/shell.rb:125:in `run'
./msfconsole:77
======================================================================

Thanks for your help.