smf IIS and MySQL issues

  • tgray96
  • Novice
  • Novice
  • No Avatar
  • Joined: Feb 23, 2011
  • Posts: 27
  • Loc: Rising Sun Indiana
  • Status: Offline

Post March 16th, 2011, 1:33 pm

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
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post March 16th, 2011, 1:33 pm

  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8925
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post March 16th, 2011, 1:43 pm

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?
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • tgray96
  • Novice
  • Novice
  • No Avatar
  • Joined: Feb 23, 2011
  • Posts: 27
  • Loc: Rising Sun Indiana
  • Status: Offline

Post March 16th, 2011, 3:44 pm

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
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8925
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post March 16th, 2011, 4:59 pm

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.
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • tgray96
  • Novice
  • Novice
  • No Avatar
  • Joined: Feb 23, 2011
  • Posts: 27
  • Loc: Rising Sun Indiana
  • Status: Offline

Post March 16th, 2011, 5:02 pm

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

i have tried root
and root@localhost

neither work
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8925
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post March 16th, 2011, 5:29 pm

What is the error message you are getting when you try to login via phpMyAdmin? Just not authorized?
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8925
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post March 16th, 2011, 5:35 pm

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.
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • tgray96
  • Novice
  • Novice
  • No Avatar
  • Joined: Feb 23, 2011
  • Posts: 27
  • Loc: Rising Sun Indiana
  • Status: Offline

Post March 16th, 2011, 5:39 pm

it is a 32 bit..... maybe thats my problem......... just in case not heres the error: #1045 Cannot log in to the MySQL server
  • tgray96
  • Novice
  • Novice
  • No Avatar
  • Joined: Feb 23, 2011
  • Posts: 27
  • Loc: Rising Sun Indiana
  • Status: Offline

Post March 16th, 2011, 5:41 pm

Its MySQL 5.5 and it was installed by itself...
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8925
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post March 16th, 2011, 5:44 pm

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?
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • tgray96
  • Novice
  • Novice
  • No Avatar
  • Joined: Feb 23, 2011
  • Posts: 27
  • Loc: Rising Sun Indiana
  • Status: Offline

Post March 16th, 2011, 5:46 pm

yes....... I am going to reinstall MySQL in 64 bit.... but I'll check the phpmyadmin folder as well... Thanks!
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8925
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post March 16th, 2011, 5:47 pm

Okay let us know what you figure out after you re-install :)
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • tgray96
  • Novice
  • Novice
  • No Avatar
  • Joined: Feb 23, 2011
  • Posts: 27
  • Loc: Rising Sun Indiana
  • Status: Offline

Post March 16th, 2011, 5:49 pm

Alright... Thanks
  • tgray96
  • Novice
  • Novice
  • No Avatar
  • Joined: Feb 23, 2011
  • Posts: 27
  • Loc: Rising Sun Indiana
  • Status: Offline

Post March 16th, 2011, 7:10 pm

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
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8925
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post March 16th, 2011, 9:02 pm

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
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post March 16th, 2011, 9:02 pm

Post Information

  • Total Posts in this topic: 26 posts
  • Users browsing this forum: No registered users and 214 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.