I fully reinstalled MySQL, and changed the login information in my config.php file to username: root with no password and it worked...hmph go figure it was that simple...figured i would share that with everyone in case someone else has the same problem

hmm... I worked on this for 2 days and couldn't get it to work. When I went to bed last night, it still wasn't working. But, when I got on today and tried it, everything was working fine.... Weird. You gotta love a computer that fixes itself... lol

Anyway... Everything is working great. Thanks

Working great for me - the two snags I had (in case it helps anyone) is that when I opened the cmd to add the users, I needed a space before the mysql --user bit, and as Preech said in the config.php file I needed to leave the password blank. :) This is going to help so much - wish I'd found it sooner! :D

What can I say...Fantastic. So much easier than doing it online. many thanks for a great tutorial.

Great Tutorial. Thank you.

One question :)

I have done a mysql dump for my online forum.

I want to restore this to my local forum.

When I try to run restore procedure, I get a message that table is already created.
Which of course it is.

What have I done wrong?

04. Open a CMD window and change it's location to your current MySQL /bin folder.

05. Set your Users:
\bin> mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@'%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost;
mysql> GRANT USAGE ON *.* TO dummy@localhost;

I'm trying to use a CMD prompt but l couldn't access my network folder in C:
I dunno why

I did a tut of how to access network folder via CMD prompt but l couldn't get it to working, i need help!

Also.. I don't know how to set up any users :(

To make life easier for you go here : http://www.easyphp.org/?lang=en and download the easy php 1.7 which includes and configures :Apache 1.3.27, php 4.3.3, MySQL 4.0.15 ...

Or take XAMPP form www.apachefriends.org which includes preconfigured Apache 2.0.48, MySQL 4.0.17, PHP 4.3.4 + mod_php 4.3.4, Perl 5.8.2 + mod_perl 1.99_12,
Openssl 0.9.7c + mod_ssl 2.0.48 & PHPMyAdmin 2.5.5 pl1 :)

How do you set up any users?

how do u get it to connect from ur mysql db? cuz it doesn't work for me.