smf IIS and MySQL issues

ok so installed MySQL, but i cant create user accounts and it wont let me use root on the SMF installer

ok not worried about that now, i cannot create a MySQL user via the MySQL Workbech

Create User:
user: smf
password:xxx
password:xxx
limit connectivity to hosts matching: localhost

After clicking create i get error:

Unhandled Exception

Could you provide a bit more information? What type of server are you running? Windows? Linux?

How come you cannot create any MySQL users? Did it provide you some sort of error message? I know you installed MySQL, but are you sure MySQL is actually running?

according to the MySQL workbench its running
Error: Unhandled Exception:Error adding account smf@localhost:

IIS 7, along with php

after noticing the web hosting forum i realize i should've put it there..... sorry ... Thats running on Windows server 2008 R2 64bit

Do you have phpMyAdmin installed? If not you may want to install that. I have heard reports that there could be a bug with the GUI tools (if that is how you are trying to do it) and that some people have reported that they can get around the problem by using phpMyAdmin and adding your user there.

i have phpmyadmin installed, but i cant login ....

i have tried root
and root@localhost

neither work

What is the error message you are getting when you try to login via phpMyAdmin? Just not authorized?

Also quick question, I noticed you are using a 64 bit system. Did you install the 32 bit version or 64 bit version of MySQL? Could you tell me exactly what version you installed, and if you installed it as part of a greater package, or all separately by itself.

it is a 32 bit..... maybe thats my problem......... just in case not heres the error: #1045 Cannot log in to the MySQL server

Its MySQL 5.5 and it was installed by itself...

Also make sure in your phpMyAdmin config file you have set the user to root and the password correctly. You do know the MySQL root's password right? Meaning you set this up at one point during the install of MySQL?

yes....... I am going to reinstall MySQL in 64 bit.... but I'll check the phpmyadmin folder as well... Thanks!

Okay let us know what you figure out after you re-install

Alright... Thanks

alright getting this error from simple machine forums php web-based installer:

Some of the queries were not executed properly. This could be caused by an unsupported (development or old) version of MySQL.

Technical information about the queries:
Line #563: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) /*!40102 NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP */,' at line 3

So did you get further than before? Did the other problem go away and you were able to create a MySQL user and password? Maybe try and older version of MySQL:

http://dev.mysql.com/downloads/mysql/5.1.html