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!