My php version i installed was php-4.3.4-Win32

And the apache was apache_1.3.28-win32-x86-no_src

Attempting to attach to database...

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user: 'root@localhost' (Using password: YES) in C:\network\Apache2\htdocs\forums\admin\db_mysql.ph p on line 38

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\network\Apache2\htdocs\forums\admin\db_mysql.ph p on line 47

The database has failed to connect because you do not have permission to connect to the server. Please go back to the last step and ensure that you have entered all your login details correctly.

Click to go to the vBulletin website

i get that error can some 1 help

their is 99 members online and not 1 to help me

did you make a database folder? plus how are you trying to log in?

i did make the folder

i will be trying to install all of it again

well i just did and it works perfect:

Well after many attempts on trying to get this working with your tutorial Nakkid I just couldn't get it to work, I've been doing everything perfectly. So I uninstalled everything, and I decided to try PhpTriad. And I must say, not only did it work (with 2.2.6), but it was MUCH easier to install

---------------------------------------------------------------------------------

Quick little tutorial on how to get this working with PhpTriad:
1. Install PhpTriad (http://sourceforge.net/projects/phptriad/)
2. Goto C:\apache\mysql\bin\ and run winmysqladmin
3. If it asks you for a username or password, enter (using Nakkid example) root for username and password for the password.
4. Still in winmysqladmin, goto the databases tab, and right click on your computer name, then select create database. Call it vbulletin.
5. Now in C:\apache\htdocs create a folder called forums, then upload all the vbulletin stuff in there.
6. Goto your start menu > PHPtriad > Apache Console > Stop Apache. (this step might now even be needed, but was for me)
7. Now go to start menu > PHPtriad > Apache Console > Start Apache
8. Apache will come up in a window, simply minimize it.
9. Goto http://localhost/forums/admin/install.php, and you're done!

This doesn't require any moving files or file modifications, and didn't give me any errors either
Thanks to eiSecure for providing the info on PHPtriad!

I wouldn't recommend anyone using phptriad or phpdev anymore - neither of them are running the latest stable releases of php or mysql or apache and these older versions are plagued with bugs and i'm guessing security holes. Even though you're running it offline it still means you may find bugs which are due to your php/mysql/apache versions and not your code :)

my goddess have we heard enough? this thread is NOT and advertizment thread, it is STRICTLY for support, not to go telling people to use phptriad or phpdev or whatever the hell you want to use.

GOT IT?!

lol

Do this:
Open a CMD prompt in the /bin folder and type:
\bin> mysql --user=root mysql
Press ENTER. Type:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'your_password' WITH GRANT OPTION;

someone should make a vB localhost installed (php dev style) ;)

you know you use your localhost too much when you:

#1 Reason - You see someone talking about the root account on a thread and believe that they are reffering to you.

:P

or

#2 Reason - You continually try linking people to localhost to view stuff your workin on offline

w00t! i've done both :P ask Steve

I just installed following the tut with the latest software available for download (php, mysql, etc) and it works perfectly.

Me too Teck :), Had a few problems at first, but then I got it working after the 2nd install.

Also, if anyone wants to install phpMyAdmin along with this tutorial.. do the following:

1. Download the lastest [zip] stable version : http://www.phpmyadmin.net
2. Extract the zip file that you just downloaded to 'c:\Network\Apache2\htdocs
3. Rename the folder that you extracted to something easier to remember. I.E MyAdmin
4. Browse to MyAdmin, or whatever you name it on step #3, and locate 'config.inc.php'.
5. Right click it and open it with you favorite editor. *note some editors, such as notepad makes the file messy and hard to read and edit it.. # I use EditPlus, a great text editor.
6. Locate this line > $cfg['PmaAbsoluteUri'] = ''; and in the '', add the url location to where you installed phpMyAdmin. I.E $cfg['PmaAbsoluteUri'] = 'http://localhost/MyAdmin';
7. Still in config.inc.php, locate this line > $cfg['Servers'][$i]['user'] = 'root'; // MySQL user, and replace 'root' with the username you specified during MySQL installation.
8. Again in config.inc.php, edit the line below the one you just edit on step #7 with the password you set for root or whatever username you gave access to.
9. Launch you favorite browser and point it to http://loacalhost/MyAdmin (or whatever you named it to) and you should see phpMyAdmin saying "Welcome to phpMyAdmin".

your done! :)

done that php my admin bit and i just get this
what did i do wrong?

any help about?

i tried to restore my database and nothing happened, any ideas?

BUT EVERYTHING IS RIGHT :( :(

what could I have missed?

if i take out the password I get a totally different error some kind of 1044 error...but if i modify the username and keep a pass it doesnt matter whether or not the information i put in is correct or not i get the same error, i really dont understand what could be wrong...and i dont see anyone else with this error :(

im running the vb3 rc2

and there is what i have in config.php currently I have tried about every combination of username and password and i have changed localhost to the IP address of my machine and also the 127.0.0.1...it doesnt matter what i changed it to i can change it to any word and i still get the same error

oooooooooo please help :)

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.

Well, I just tried to connect to my database without a user and password but l got this error..

Attempting to attach to database...

Connect failed: unexpected error from the database.

Error number: 1044

Error description: Access denied for user: '@localhost' to database 'vbulletin'

Please ensure that the database and server is correctly configured and try again.

Click to go to the vBulletin website

I tried to connect to my database with a user and password but it said that it cant connect to my database. What did l do?

this is where im stuck

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 dont understand what the CMD window is and where to set your users

also mysql admin is not on for some reason....... its running a red light and i take it that the light is supposed to be greeen

I think in the mysql > bin folder there's an exe where you can execute mysql queries within a DOS interface :)

^^^ ok thanx i seem to have gotten it now

im having trouble trying to restore my sql file from my real boards to my test ones.

-root -password vbulletin < blakkboy_vb.sql

that is what im typing into the prompt but its saying that its not restoring.

can someone help me out who used triad to set this up?

could someone let me know what exactly i did wrong so i can import my db to my computer forums

Try

mysql -u root -p vbulletin < blakkboy_vb.sql

^^^^^^^^ your a life saver, thanx buddy

Hi

I'm working on getting a handle on vB3 and have it running on my local computer so I can make forums and adjust "things".

A fresh untouched vB3 is sitting on a remote live server with several test messages on it.

What files and/directories do I need to upload from my home computer with the modified forums to update the live vb3 on my remote server so it looks and act like my finished version from my home computer?

I want the appearance of the remote vB3 to be the same as the "adjusted" home version of vB3, but I don't want the new adjusted vB3 (with new forums etc.) to mess up the database on the live server

How do I handle this merging of live database on the remote server with the newly adjusted vB3 uploaded from my localhost machine?

Any help is appreciated. I'm pretty new at this stuff

Thanks

I'd do the following:

1) Make sure both run the same version
2) Shut down the live board
3) Make a backup of all files and the database (just in case anything goes wrong)
4) Upload all files form your test board
5) Export style & language from your testbord
6) Import both at your live board
7) If you made changes to the database structue do the same changes to the live system
8) Check if everything is ok
9) Open the live board