MySQL login problems

[michaelwkane]

I'm trying to setup some sort of free webmail, but all of the projects I've found on SourceForge require me to create a MySQL database. However, the only databases I can see are the ones created my Ensim, and when I try to create a database I get an "access denied" error.

For instance, in trying

>mysqladmin create tiki

I get: "Access denied for user: 'odbc@127.0.0.1' (Using password: NO)'

That error came after following an instruction for installing TikiWiki, a webmail application.

WinMySQLAdmin never asked for a username / password the first time I started it, which (I think) means it uses my RDP username / password. But that doesn't work, either.

[QT]

The reason you're getting that error is because you are not logged in as the MySQL administrative user. If you don't know how to login as the MySQL administrative user, you can go to the Ensim Knowledge Base and search for "root user" and it will pull up the instructions on how to do that _and_ create the database.

[Buckaroo]

Windows Ensim Pro or Linux Ensim Pro?

If its linux, you can't create a database from the command line. You'll need to do it as the site admin via the GUI.