Q : Getting ready for RaidenFTPD ODBC support : Setup web-server and MySQL™ management utility

A : After you installed MySQL™ and MySQL™ Connector/ODBC successfully , you need to install a web-server and database management utility so you can search and manage your database easily .

We'll guide you through the steps for setting up a web-server RaidenHTTPD (free trial) and PhpMyAdmin (free version)

 

1. download RaidenHTTPD 1.0x for Win2000/Xp

RaidenHTTPD primary download page: http://www.raidenmaild.com/download/RaidenHTTPD.exe

RaidenHTTPD web site : http://www.raidenhttpd.com/

2. run RaidenHTTPD.exe

IMPORTANT WARNING : PLEASE AT LEAST LOGIN WEB-ADMIN FOR ONCE AFTER SETUP, TO RESET YOUR ADMINISTRATIVE ACCOUNT AND PASSWORD, OTHERWISE IT IS VERY DANGEROUS

click Next to continue.

be sure to install php to c:\php , unless you already have it installed , the web administration and phpMyAdmin will both make use of php scripting engine.

3. configuring RaidenHTTPD

the first time setup wizard will pop up after the installation is done.

click next to continue

if your server IP is set to 0.0.0.0 , it will bind to all local IPs , make sure to enable SSL/TLS , and if you install the php engine by the RaidenHTTPD installer , the php4isapi.dll is already configured , otherwise you need to specify its location by clicking the browse button

now take a look at anti hacking , ip checking , php options to see if you want to change anything


because we are setting up a web-server for database management only at this moment , we'll recommend you to deny all IP but allowing your own IP only

make sure your register_globals is enabled , many web scripts require it to work

now click next and you will be asked for picking up your web root directory , specify a clean directory for your web documents

now you are in the virtual host and virtual directory setup dialog , there is nothing much to change but for security reason we'll recommend you to disable 'directory index' , but of course it's up to you , if you setup IP-checking properly it's ok to enable it.

At last , click next , install service , start service , and you are done , now the RaidenHTTPD tray icon will appear

if your service is not started successfully , it's probaby there is something that occupies your port 80 already , you can change the port to another one since we'll primarily use SSL in the later tutorial

IMPORTANT WARNING : PLEASE AT LEAST LOGIN WEB-ADMIN FOR ONCE AFTER SETUP, TO RESET YOUR ADMINISTRATIVE ACCOUNT AND PASSWORD, OTHERWISE IT IS VERY DANGEROUS

4. download phpmyadmin , the php MySQL™ administration interface

official web site : http://phpmyadmin.sourceforge.net/

download : http://www.phpmyadmin.net/index.php?dl=3

decompress the phpMyAdmin-2.5.0-php.zip to your web root directory c:\www , and you will get a c:\www\phpMyAdmin-2.5.0 folder

5. connecting to your phpmyadmin

now the start page of your phpmyadmin is https://127.0.0.1/phpMyAdmin-2.5.0/index.php , you will notice that you can login immediatelly , because you MySQL default user and password are not changed yet , this is no good for security , we'll teach you how to change it . but before we do that , you will need to finish the setup for phpmyadmin first

edit config.inc.php by notepad or ultraedit

find $cfg['PmaAbsoluteUri'] = ''; and replace with $cfg['PmaAbsoluteUri'] = 'https://127.0.0.1/phpMyAdmin-2.5.0/';
save this file and reload your web page , and you will find that the error message has gone
, but the warning message for your root and password is still there , now we are going to change the default root password

click databases... , selcect mysql

click user table

click browse

click inert a new row , fill the necessary fields , remember your username and password , this is to replace the default root account so give it all the priviledges , click go , to finish

after the record is inserted , you can not use it immediatelly , you must reload your MySQL™ , just reload this URL by IE https://127.0.0.1/phpMyAdmin-2.5.0/index.php , and you will find the place to reload MySQL™

now , make sure to reload MySQL before you test your account , edit config.inc.php by notepad or ultraedit

find

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user

replace with

$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = ''; // MySQL user

save file , reload URL https://127.0.0.1/phpMyAdmin-2.5.0/index.php , and input the username/password you just created to login the admin panel , if this works , you can now delete all other default MySQL accounts for safety reason .

6. creating account for MySQL™ Connector/ODBC

giving the database root account for ODBC to use maybe too dangerous , you need to create an account that has accesses to the 'raiden' database only

similar to the above instructions , click databases... , selcect mysql , click user table , click insert

fill the necessary fields , remember your username and password , this is to be used for RaidenFTPD ODBC connection , note that we don't give any priviledge here , the host is localhost , username is decided by you , and password must be encrypted by PASSWORD function

the account is not read yet , click databases... , selcect mysql , click db table , click insert

assign the username you just created to the raiden Db , Host is localhost , we give it all priviledges here , click Go to finish , now same as above , Reload your MySQL

Now try to change the username password you set in ODBC driver (was root and empty) , set them to the username and password you just created and click test

now your MySQL™ and ODBC are ready for RaidenFTPD ODBC support

 

7. a few words

now you are running MySQL with own user account and password . aren't you ? NOT YET , you must goto mysql database , user table , and delete all accounts that came with MySQL and then reload your server .

That's ALL

Copyright © RaidenFTPD TEAM , ALL RIGHTS RESERVED

REVISION 2.4 , 2003/05/22

The copyrighted works contained in this information service shall not be copied, reproduced, varied, altered, modified, adapted, distributed, performed and displayed in any form without the written permission of the copyright owner. All trademarks belong to their respective owners .