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:
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.
Enable PHP for PhpMyAdmin
Enable PHP script execution in /var/www/hiawatha/phpmyadmin by enabling CGI.
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:
Edit the hosts.allow file as well to add the mysqld daemon:
mysqld: ALL SSHD: ALL </syntaxhighlight>
Have all localhost generated packets accepted by default in iptables:
iptables -A INPUT -i lo -j ACCEPT iptables-save > /etc/iptables-rules
You will need to restart the mysqld daemon for these changes to take effect.