Obtaining mySQL account information

Hi,

I am new to mySQL just now installed Drupal, a CMS that runs on PHP and mySQL on my apache server (XAMPP).

While trying to install the Drupal, I was required to provide the Database name, database username and the password.

I only remmeber the password but not the database username. Is there command that once upon loggin into MySQL command line that I can obtain my username and tha name of any databases i created earlier?

I can log in comfortably into MySQL since it only asks for my password. But I need the username for Drupal. I have installed MySQL a while ago which is why I dont remember the login details clearly.

re: Obtaining mySQL account information

Well, first, mysql should have a root account. The first thing you should do is set the password in mysql for the root account as right now it won't have one by default. Then, you can set your password if it isn't already done.

To see a list of all the databases, you need to use the command:
Unless your account has privileges on the database you mentioned in the Drupal install (I assume it created it, but could be wrong), then you might not be able to see it.

Regards,

Jeff