I have just installed Mysql 5 that I donloaded from the Mysql Website. When I installed I was not prompted to name my instance or provide any user names or passwords. After installing I want to open it up and start learning how to use the database. When I opened Mysql administrator, I was prompted to enter the Server host along with a user name and password. I tried LocalHost with a user name of Root with a blank password but got an error. I also tried Default but that didn't work either.

Does anyone have any idea what the server host name would be and/or the default name and password would be or how to find this information out?

Thanks GEM

Usernames are case sensitive if MySQL is installed on UNIX/Linux. Therefore you should enter 'root', not 'Root' as username if you're using UNIX/Linux.

If you're using Windows; are you sure you have started the MySQL server?

I assume that MySql is running. I don’t have any problem opening MySql workbench. I’ve even created a project with one table and one view. Even when I’m in workbench I haven’t been able to find the instance or server name? . Any Idea where I can look in the workbench ui to find it?

If I haven’t entered a pass word anywhere, the password should be null shouldn’t it?.....I’m using windows Vista…..

GEM

hi Gem,

what kind or version of mysql server are you using ?
so is it with IIS?

most probably ..
user: root
pass: (blank) or "root"

root with lowercases

if you just want to learn and code for mysql stuffs
you try also using the wamp, its windows apache, mysql, and PHP ..
i have a link for you here , im using this software for debugging purpose before uploading files on live server.


br