US 3.3, german charset, auto-run mysql, testscript

December 12, 200619 yr

Hello there,

I just stumbled upon US3.3 and it is very nice. I like the way it takes W: to overcome fixed paths problems. Also its a lot smaller then XAMPP and got everything I need. Congrats to the developers and the admins here.

Here a few quick steps to make US3.3 work for german WinXP:

1. Make phpMyAdmin work on german Windows

Download the files "german-utf-8.inc.php" and "german-iso-8859-1.inc.php" from here:

German charset rar-ed

and place them into "diskw\home\admin\www\phpMyAdmin\lang".

2. Auto-start mySQL

To start mySQL automatically open the "start_server.bat" in a text editor. Around line ~27 remove the if-clause like that:

BEFORE: 
IF "%2"=="mysql" start \usr\local\mysql\bin\mysqld-opt.exe --defaults-file=/usr/local/mysql/bin/my-small.cnf

AFTER:
start \usr\local\mysql\bin\mysqld-opt.exe --defaults-file=/usr/local/mysql/bin/my-small.cnf

3. Change start-up website

US will start the webpage "http://localhost/apanel" automatically. I didn't like that - I wanted just "http://localhost". To change this open the file "redirect.html" from "diskw\home\admin\www" and edit the line ~25:

BEFORE:
window.location = 'http://localhost/apanel/';

AFTER:
window.location = 'http://localhost/';

4. Test if everything works

Finally I created a short php script that tells me everything is working fine. Place the the following code into a new file called "index.php" in "diskw\www" and overwrite/rename the existing one.

<html><body><div style="font-family: verdana; font-size: 10px; font-weight: bold;">HTML works !<br><br>
<script type="text/javascript">document.write("Javascript works !<br><br>");</script>
<?php
echo "PHP works !<br><br>";
if($db = mysql_connect("localhost", "root", "root"))
{echo "mySQL works !";}else{echo "<h2>mySQL doesn't work !</h2>";}
mysql_select_db("mysql", $db) or die ("This mySQL database doesn't exist.");
?>
</div></body></html>

Credits:

All information in this short article can be found in this forum. Credits to the authors.

Quote