CoD4X Server and BigBrotherBot (b3) help ⇒ Mysql for dummies like me WINDOWS only

[Gen Stranger]

I decided to include how to make a b3 mysql database using winlamp.exe
the reason I choose to use winlamp is mainly because its easy to use

WinLAMP.4.0.0.exe

Winlamp 4.0.0

(59.76 MiB) Downloaded 283 times

WinLAMP.4.0.0.exe

Winlamp 4.0.0

(59.76 MiB) Downloaded 283 times

winlamp contains apache2 php 5.1.4 mysql 5.0 and phpmyadmin which is used to add or remove data bases

After you install winlamp as a stand alone web server with php mysql and phpmyadmin you will have to config it so only you will have access to it and I will explain how to do that.
if you do not config it then anyone with internet access could access it and you do not want that.
if you already have mysql running and are able to add and remove datatbases you will not need this program.

I started by running winlamp4.0.0.exe and selected typical as the way I want it installed

I left servername and email the default values
I selected install and an internet windows opened with this
MySQL and phpMyAdmin Installation


WinLAMP automatically starts the MySQL installer for you.

The default user/password for phpMyAdmin is root/mysql.

As you install and configure MySQL, the easiest thing to do is to accept all defaults, and set the password to 'mysql'. This matches the default password set in phpMyAdmin. Note that easiest is not the same as most secure, so feel free to do something different here.

Here is a typical WinLAMP MySQL setup:

Select 'Typical' installation.
Install.
When the install is complete, if you have already signed up with MySQL, choose 'Skip Sign-Up'
Select 'Configure MySQL Server now'.
Choose 'Standard Configuration'.
Create root password 'mysql'.
Optionally, you can create some other password here, and change the one in the phpMyAdmin config.
Select [Execute].

Then you can close this browser window.

when the mysql window opens select typical
then select skip sign-up when prompted
next a window will open to config mysql
select standard configuration
select install as windows service
and launch automatically
select a password for root
****** write it down you will need it later *****
mysql should start by may error on security settings

see next post to continue

[Gen Stranger]

open a web broswer and type localhost in the window
you should see this
WinLAMP, she installed successfully.
If you can see this, it means that the installation of the Apache web server software on this system was successful.
See PHPINFO to view your PHP configuration, and phpMyAdmin (if you chose to install it) will allow you to begin working with MySQL immediately.
If you chose to install the Apache, PHP, and MySQL manuals, they are now available in your Start / Programs / WinLAMP menu.
Configuration Tips
We consolidated various configuration tips into a single location.
take a look at the configuration tips.

Seeing this instead of the website you expected?

This page is here because the site administrator has changed the configuration of this web server. Please contact the person responsible for maintaining this server with questions. The Apache Software Foundation, which wrote the web server software this site administrator is using, has nothing to do with maintaining this site and cannot help resolve configuration issues.

------------
Now select phpmyadmin from that web page it may error if it does
you have to locate config.inc.php in appache2\phpmyadmin and
change the password to what you installed in the mysql setup (password for root)
after you change it to that password hit refresh and it should show the phpmyadmin window
ok you have to manually edit b3-db-.sql located ib the b3 sql directory
CREATE DATABASE b3 CHARACTER SET utf8;

GRANT ALL ON b3.*
TO 'b3'@'localhost'
IDENTIFIED BY 'password'; change that to whatever you want but you will need it later for b3.xml


now select import on the windows that opens its by the bottom
select browse and go to b3 /sql and select the b3-db.sql and allow it to run
that will make a database
go to that data base and select import you will import b3.sql and all other files one in the directory b3/sql at a time
if any error just continue with the rest
when done you have to edit b3.xml using the same password you just made
thats it if all went well you have installed b3 and got it working for a cod4 server not a cod4x one
go back to viewtopic.php?f=242&t=5486
for cod4x