Hi all, i think: Someone maybe don’t know how to create a MySQL Database for his dedicated server (expecially with B3 or MAM). So i create this guide for you!

Get started!

REQUIREMENTS:

– XAMPP installed.

– MySQL + Apache running in XAMPP.

WHAT TO DO:

– Open your browser (IE, Opera, Firefox, Safari etc…).

– Write in the link bar: localhost (set your language).

– On the right there’s a list of names. Click on phpMyAdmin.

– There’s written: Create a database. Under there’s a textbox, write the name of the database you wanna create. (If you use ManuAdminMod write mamstats)

– Push the button Create.

Well done, you created a database but you have to set it before use it.

– Return to localhost.

– Click on Security, in the right. A new tab will open.

– Now click in the link http://localhost/security/xamppsecurity.php

– Set a password for root.

– Change the phpmyadmin authentication from cookie to http.

– Click Change password button.

– Under, for XAMPP directory protection, write User : root Password : the same password you setted before.

– Click Secure XAMPP directory button.

– Close your browser.

– Go to your XAMPP directory (C:\xampp)

– Go there: C:\xampp\phpMyAdmin\config.inc.php and open this file with notepad.

– Replace with the following: $cfg[‘Servers’][$i][‘password’] = ‘PUT HERE THE PASSWORD YOU CHOSE’;
$cfg[‘Servers’][$i][‘auth_type’]     = ‘http’;

Well, you created and setted your MySQL Database!