m4rty's questions

This is a new install and I have only set the root passwords for localhost, 127.0.0.1 and .

I know the password is correct as I can log in with root@localhost to the mysql server and can also create users. However, when I try to grant privileges to the newly created user I get the dreaded "Access denied for user root@localhost (using password: YES)" error message.

GRANT ALL PRIVILEGES ON *.* TO 'myUserName'@'localhost' IDENTIFIED WITH 'myUsersPass' WITH GRANT OPTION;

Returns:  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

There's got to be something small that I've missed in my setup, however I cannot find it. I've been searching for a while and all I can seem to find that relates is a wrong password for the root account, and I know I've got the right one.

I've looked through numerous threads here and they all seem to relate to a lost or unknown password for the root account, which is not the case here.

We're at the end of a VDI deployment and have a new requirement to install SQL Server Developer Edition (2008) on the virtual desktop clients.

The DBA's were invited late to the party and subsequently tasked with finding out if this is possible.

Apparently the VDI implementer we hired was advising our management that running SQL Server Desktop was impossible under VDI, but did not elaborate as to why (at least to my knowledge).

Can anyone provide some information whether this is true or not? Is it possible to run SQL Server Desktop Edition (2008) on a Xen VDI client?