XAMPP Startup Guide

Follow these steps to upgrade you XAMPP version to a newer version.

 

Rename your old XAMPP installation folder

i.e.

mv /opt/lampp /opt/lampp_old

Install XAMPP

Copy the files from your old htdocs folder to the new htdocs

/opt/lampp/htdocs/

Give your user ownership of those files. This is necessary to be able to edit the files.

chown user:user -R /opt/lampp/htdocs

 

Configure Virtual Hosts

open /opt/lampp/etc/httpd.conf

uncomment this line

Include etc/extra/httpd-vhosts.conf

 

Copy your httpd-vhosts.conf file from your previous installation to the new location.

/opt/lampp/etc/extra/httpd-vhosts.conf

 

Update your xampp password

“UPDATE mysql.user SET Password=PASSWORD(‘password’) WHERE User=’root’;”

 

Update your PHPMyAdmin password

 

Open the file [XAMPP Installation Path] / phpmyadmin / config.inc.phpin your favorite text editor.

Search for the string or got to line 31.

Look for $cfg\['Servers'\]\[$i\]['password'] = '';


Change it to like this,$cfg\['Servers'\]\[$i\]['password'] = 'password'; Here the ‘password’ is what we set using the SQL query.

 

Copy your databases from your old installation.

-chown mysql:mysql -R /opt/lamp/var/mysq/

 

Re-enable any php extensions you may have activated in your previous installation. i.e. xdebug

Add extensions in /opt/lampp/etc/php.ini

zend_extension=”xdebug.so”

Easy way to verify is to use php_info(); or use PHPStorm

PHPStorm xdebug verification

Set your timetime in php.ini

 

Xamp Desktop Shortcut Ubuntu 12, Ubuntu 14+

Two Methods, Use GUI # 1, Use GUI #2

The important line to change when choosing the GUI is Exec= line.

 

sudo nano /usr/share/applications/xampp.desktop

 

paste

 

[Desktop Entry]
Encoding=UTF-8
Name=Xampp Control Panel
Comment=Start or Stop XAMPP
Exec=gksudo python /opt/lampp/share/xampp-control-panel/xampp-control-panel.py
Icon=/opt/lampp/htdocs/favicon.ico
Categories=Application;Development;Web
Version=1.0
Type=Application
Terminal=0


Save


sudo chmod +x xampp.desktop


GUI #2

[Desktop Entry]
Encoding=UTF-8
Name=Xampp Control Panel
Comment=Start or Stop XAMPP
Exec=gksudo  /opt/lampp/manager-linux-x64.run
Icon=/opt/lampp/htdocs/favicon.ico
Categories=Application;Development;Web
Version=1.0
Type=Application
Terminal=0

Where are mysql db files kept – MAMP PRO and more

Where are MySQL’s Files Kept?

MySQL stores and accesses files in various places on your hard drive. This page documents the locations of commonly used files, for some often used MySQL installations.

If you want to backup your data or copy data from one server to another, please don’t copy the data files directly. It is recommended to use Sequel Pro’s Export and Import features (use a MySQL dump) to accomplish this.

If you can’t find the files in the locations given here, it could be because you changed the configuration — these are only the default locations. Some of the files only exist while the MySQL server is running (eg. the socket file).

If your installation has no option file (my.cnf), you can create it in the base directory of your installation (see ‘Using Option Files’ section of the MySQL manual for more information).

If you can connect to your MySQL server, you can find many of these paths by selecting Show Server Variables… from the Database Menu in Sequel Pro.

MySQL installed with the official .pkg installer

Socket File
/tmp/mysql.sock
Data Files
/usr/local/mysql/data/
Error Log
/usr/local/mysql/data/HOSTNAME.err (insert your hostname)
Base Directory
/usr/local/mysql/ (this is a symbolic link)

MySQL pre-installed on Mac OS X Server

Socket File
/var/mysql/mysql.sock

MySQL 5 installed with MacPorts

Socket File
/opt/local/var/run/mysql5/mysqld.sock
Data Files
/opt/local/var/db/mysql5/
Error Log
/opt/local/var/db/mysql5/HOSTNAME.err (insert your hostname)

MySQL installed with MAMP

Socket File
/Applications/MAMP/tmp/mysql/mysql.sock
Data Files
/Applications/MAMP/db/mysql/
Base Directory
/Applications/MAMP/Library/
Error Log
/Applications/MAMP/logs/mysql_error_log

MySQL installed with MAMP PRO

MAMP PRO shares many paths with MAMP, with the following difference:

Data Files
/Library/Application Support/appsolute/MAMP PRO/db/mysql

MySQL installed with XAMPP

Socket File
/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock
Data Files
/Applications/XAMPP/xamppfiles/var/mysql
Configuration File
/Applications/XAMPP/xamppfiles/etc/my.cnf

 

MySQL installed with Zend Server CE

Socket File  
/usr/local/zend/mysql/tmp/mysql.sock
http://www.sequelpro.com/docs/Where_are_MySQLs_Files