If you use Xampp, edit /opt/lampp/bin/mysql.server and search for "datadir". You will find an empty assignment like:
- Code: Select all
Simply apply the folder you like and restart MySQL.
If you dont use Xampp, you may as well edit the MySQL Configuration file my.cnf (usually in /etc) and search for the section [mysqld]. Apply the datadir=/home/... Directive there and alsol restart MySQL.
And finally proceed to http://dev.mysql.com/doc/refman/5.1/en/ ... files.html
and read about how to configure MySQL runtime options (for future questions).
P.S.: Beware you grant the desired permissions to the datadir folder, as MySQL server usually runs with different userid than yours.