Difference between revisions of "MySQL"
Line 36: | Line 36: | ||
=== Enabling PHP for PhpMyAdmin === | === Enabling PHP for PhpMyAdmin === | ||
− | PHP is only permitted to execute in /var/www/hiawatha/admin by default, follow instructions to [[PHP#Enable_PHP_for_only_one_directory_and_its_subdirectories|enable PHP]] for /var/www/hiawatha/phpmyadmin (or you may enable PHP for all directories if you choose). | + | PHP is only permitted to execute in /var/www/hiawatha/admin by default, follow instructions to [[PHP#Enable_PHP_for_only_one_directory_and_its_subdirectories|enable PHP]] for <tt>/var/www/hiawatha/phpmyadmin</tt> (or you may enable PHP for all directories if you choose). |
PhpMyAdmin is now accessible via https://ip-address/phpmyadmin. Note: '''HTTPS is required for PhpMyAdmin.''' | PhpMyAdmin is now accessible via https://ip-address/phpmyadmin. Note: '''HTTPS is required for PhpMyAdmin.''' |
Revision as of 19:51, 17 September 2011
Contents
Youtube walk-through
Securing MySQL and installing phpMyAdmin
Securing MySQL
The MySQL password is not set by default (blank), and can only be set when the MySQL daemon is running (upon first boot). To set the password, execute the following command as 'root':
<syntaxhighlight lang="bash">
mysql_secure_installation </syntaxhighlight>
Disabling MySQL
If you are certain you have no need for MySQL, either for websites or for your Minecraft server mods, you may remove it from the services list.
<syntaxhighlight lang="bash">
vi /etc/rc.conf </syntaxhighlight>
PhpMyAdmin
PhpMyAdmin is available as an addon. To install, ensure you have first secured MySQL. Then, as root:
<syntaxhighlight lang="bash">
cd /usr/games/minecraft/addons ./phpmyadmin.sh </syntaxhighlight>
mbstring module
On MineOS installations earlier than 0.4.8, php-mbstring was not included in the install. Since PhpMyAdmin operates better with this module, you can install it with another add-on. Versions 0.4.8 and beyond have this module installed by default.
<syntaxhighlight lang="bash">
cd /usr/games/minecraft/addons ./mbstring.sh </syntaxhighlight>
Enabling PHP for PhpMyAdmin
PHP is only permitted to execute in /var/www/hiawatha/admin by default, follow instructions to enable PHP for /var/www/hiawatha/phpmyadmin (or you may enable PHP for all directories if you choose).
PhpMyAdmin is now accessible via https://ip-address/phpmyadmin. Note: HTTPS is required for PhpMyAdmin.
Enabling remote access/TCP-IP connectivity
Remote access/TCP-IP connectivity is disabled by default on installs <= 0.4.6--later versions can ignore this step as it has already been automated. All these actions must be done as root:
Edit the /etc/my.cnf file and comment out the line:
<syntaxhighlight lang="bash">
- skip-networking
</syntaxhighlight>
Edit the hosts.allow file as well to add the mysqld daemon:
<syntaxhighlight lang="bash">
mysqld: ALL SSHD: ALL </syntaxhighlight>
Have all localhost generated packets accepted by default in iptables:
<syntaxhighlight lang="bash">
iptables -A INPUT -i lo -j ACCEPT iptables-save > /etc/iptables-rules </syntaxhighlight>
You will need to restart the mysqld daemon for these changes to take effect.
<syntaxhighlight lang="bash">
/etc/rc.d/mysqld restart </syntaxhighlight>