I was trying to install Joomla on my machine .. so i ran the microsoft web platform and choose joomla Mysql and other tools went well .. BUT joomla it self isn't installed giving the following error :
This product did not install successfully: the database 'my_site_db' could not be created Access denied for user 'root'@'localhost' (using password :YES)
It asked me to enter a password for Joomla and the database in the last step of installation. I think i had MySQL already installed.
You obviously have MySQL installed, because this message comes from MySQL server. Make sure that the password you provided is the password for MySQL's root user.
You shouldn't be using the root user for accessing a website. Root has access to everything.
Can you create a new user using phpMyAdmin or alternative? I'm not sure what tools come with the MS web platform, but you should create a user, with privileges to access the database and use that.
Check if you can login with the root user on the MySQL Server (with a tool,..) , if not then re-setup the MySQL Server again. I've had this problem too for an unknown reason.
Having the same problem here. I decide3d to go with webplatform so I could skip some config I have no idea how to set. Installing each application or running tools won´t make me believe this package can be installed at once. BTW, are you using Windows 7 x64?
Specify your windows user account as the root database password. That worked for me.