Re: What is my username and password in mysql database?

[Bob Field]

You're probably using the start menu shortcut that sometimes gets created when you install MySQL. It puts in the username 'root' and prompts for a password. You can alter this shortcut or create your own, or open a command prompt window and run the command-line utility like this:

c:\> "\program files\mysql\bin\mysql.exe" -u <username> -p
Enter password: ********
mysql>

'%' is a wildcard meaning all hosts. It's somewhat of a security loophole since you are authorizing computers to access your databases without knowing in advance who they are. It's better to explictly state localhost or the name of the remote computer.