Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== XAMPP Quick Setup walkthrough ====== **Official Method** * download and install XAMPP * open xampp-control software, and run Apache server and SQL server * open http://localhost to make sure everything runnning * open http://localhost/phpmyadmin, to make sure database running * check password.txt in the install directory for defaut SQL server password and ftp password * now you can start work on your web project in htdoc directory under install directory * http://localhost/ is pointing to htdoc directory, so use your sub directory to separate project folders. **Portable Method** * download portable version, either 7z, zip, or installer version of portable * https://sourceforge.net/projects/xampp/files/XAMPP%20Windows/5.6.21/ * run setup_xampp.bat to tell XAMPP the current correct directory for its structure * run the xampp-control.exe, it will run smoothly (or run as admin) **Default Password for MySQL** * it is under xampp folder, password.txt file **Create a Database for Wordpress site** * name as wp_test01, collation as choice, create ====== xampp setup ====== Download from http://www.apachefriends.org click on the xampp-control application to go. start web <code>xampp start apache</code> start sql <code>xampp start mysql</code> start web <code>xampp stop apache</code> start sql <code>xampp stop mysql</code> ===== auto start on startup ===== * windows: simple, put shortcut in windows startup folder * mac: (2 methods) * ref: http://www.kharysharpe.com/2011/04/automatically-starting-xampp-on-mac-osx-boot-up/ * do shell script "sudo /Applications/xampp/xamppfiles/mampp start" password "YOUR ADMIN PWD" with administrator privileges * linux ===== Linux LAMPP install guide===== in Linux, extract the LAMPP with sudo, or "MySQL couldn't start" error will pop-up later. <code bash>sudo tar xvfz xampp-linux-1.7.3a.tar.gz -C /opt # or if you want to extract here sudo tar xvfz xampp-linux-1.7.3a.tar.gz </code> ===== Access from local and LAN network ===== Enter in Browser like <code>ServerName.local</code> or <code>192.168.1.machineIP</code> or <code>ServerName</code> ===== configure file ===== ^Apache configuration |/Applications/xampp/etc/httpd.conf, \\ /Applications/xampp/etc/*.conf | ^Apache logs | /Applications/xampp/xamppfiles/logs/access_log, \\ /Applications/xampp/xamppfiles/logs/error_log | ^PHP configuration |/Applications/xampp/etc/php.ini | like upload_max_filesize | ^MySQL configuration |/Applications/xampp/etc/my.cnf | * enable PHPZip module for php <code>\xampp\php\php.ini</code> * remove ; from <code>;extension=zip</code> * save and restart ====== xampp customize htdoc location path ====== - go to directory : xampp/apache/conf; - backup httpd.conf; - edit httpd.conf, search and replace "DocumentRoot" as following <code> # DocumentRoot "/App/xampp/htdocs" DocumentRoot "/SiteDir" </code> - and search and replace the <Directory "/xampp/htdocs"> configure setting as following <code> # <Directory "/App/xampp/htdocs"> <Directory "/SiteDir"> </code> - server root (optional, only if yours apache server not working, just check path to apache server) <code> # ServerRoot "/xampp/apache" ServerRoot "/PATHTOHERE/xampp/apache" </code> - to add extra directory into server alias list, means, you can ask apache server to use a short name to find other directory on your computer. * basically, when people use url ServerName/web2/index.htm, it doesn't look at defaut root directory for web2 folder, but go /Dev/WebSys computer folder to find index.htm * here is example code to add in httpd.conf, and shut down and restart server to make it work <code> <Directory "/Dev/WebSys2"> Require all granted </Directory> Alias /web2 "/Dev/WebSys2" </code> * if you want allow htaccess for url rewrite, make sure like this <code> <Directory "/Dev/WebSys2"> AllowOverride All Require all granted </Directory> Alias /web2 "/Dev/WebSys2" </code> * also make your rewrite module for php is loaded in httpd.conf <code>LoadModule rewrite_module modules/mod_rewrite.so</code> ====== xampp customize local domain for a local web path ====== Steps: - use hosts file to point the domain to local 127.0.0.1, example "test.com", also include localhost to be safe <code> 127.0.0.1 localhost 127.0.0.1 test.com </code> - in xampp/apache/conf/extra/httpd-vhosts.conf, add your local domain solver "test.com", and since localhost is default domain name for root dir, be sure add it as well to use localhost as usual <code> <VirtualHost *> DocumentRoot "/App_Server/xampp/htdocs/wp_site_test_com" ServerName test.com <DIRECTORY "/App_Server/xampp/htdocs/wp_site_test_com"> Order allow,deny Allow from all </DIRECTORY> ServerAlias www.test.com ErrorLog "logs/test.com-error.log" CustomLog "logs/test.com-access.log" common </VirtualHost> <VirtualHost *> DocumentRoot "/App_Server/xampp/htdocs" ServerName localhost </VirtualHost> </code> - now, restart apahce server, type "test.com" should visit your local path for test.com - extra tips: - for wordpress install at that path, it will pop up ask database server setting in wordpress initial step, - since wordpress alone dont create database for itself, you need go http://localhost/phpmyadmin/ to create a database for wordpress, i would suggest name as "wpdb_test_com" with collation setting - then, continue wordpress db connection with the db name you created, default db for xampp is root/no pass. rest as default should finish wordpress initialization ====== xampp customize http broadcast port ====== - edit xampp/apache/conf/httpd.conf; - search and replace "80" to your port number <code>ServerName localhost:80</code> - and search and replace "80" in <code>Listen 80</code> ====== Security and Site Protection ====== ===== Blocking "Domain Smacks" in Apache ===== ref: http://blog.foxxtrot.net/2010/02/blocking-domain-smacks-in-apache.html <code>RewriteEngine on RewriteCond %{HTTP_REFERER} smackingdomain.com RewriteRule .+ [F] # Return 403 Forbidden RewriteRule .+ http://jokestersite.com/ [R] # Redirect back on the joker. </code> ===== Set Security for XAMPP ===== * run command in terminal: <code>xampp security</code> ref: http://robsnotebook.com/xampp-builtin-security ====== MySQL Server Guide ====== * MySQL database server configuration is stored in the "mysql" database inside itself. * the server user is stored in DB: "mysql" > Table: "user" * phpmyadmin control panel system is a front interface for the database server ^ tables ^ MySQL access control ^^^ ^ user | host name + user name + password | select,insert,update,delete rights | which means knowing user and pass wont grant access, \\ and possible to set local only access from its php server; \\ also it mean sets foreign server call possible with maybe coincided names | ^ db | database level access control | ^ table priv | table level access control | ^ columns_priv | column level access control | ^ procs_priv | procs access control | * <code sql>SHOW GRANTS FOR 'joe'@'office.example.com';</code> * limits of MyServer server: * A password applies globally to an account. You cannot associate a password with a database, table ====== Error and Solution====== * error: Apache cant start, * solution 1: run setup_xampp.bat after copy, to auto set root directory correctly * solution 2: make sure the website folder that defined in \xampp\apache\conf\httpd.conf portion DocumentRoot directory exists. * also check httpd.conf and change to 82 if 80 port in use. * solution 3: just go to \xampp\apache\logs folder, and delete all 4 files, so it can generate itself again. * solution 4: run with admin rights * error: MySQL cant start, access right * solution: delete the file that has no access right * error: php time out, especially when do install type of script * go php.ini configure file, and search and update "max_execution_time = 300" (5min) * error: upload failed * make sure php.ini allow the big size upload, search and replace these 2 line in php.ini from configure button menu <code>upload_max_filesize = 50M post_max_size = 50M</code> appwiki/xampp.txt Last modified: 2024/04/14 15:55by ying