Difference between revisions of "MySQL"

From MineOS Wiki
Jump to navigation Jump to search
Line 14: Line 14:
  
 
[[File:mysqld_rc.png|thumb|none|400px|Remove mysqld from the list]]
 
[[File:mysqld_rc.png|thumb|none|400px|Remove mysqld from the list]]
 +
 +
== PhpMyAdmin ==
 +
 +
PhpMyAdmin is available as an addon. To install, ensure you have first secured MySQL. Then, as ''root'':
 +
 +
<nowiki>
 +
# cd /usr/games/minecraft/addons
 +
# wget http://minecraft.codeemo.com/crux/mineos-scripts/addons/phpmyadmin.sh
 +
# chmod +x phpmyadmin.sh
 +
# ./phpmyadmin.sh
 +
</nowiki>

Revision as of 16:58, 29 August 2011

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':

# mysql_secure_installation

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.

# vi /etc/rc.conf

Remove mysqld from the list

PhpMyAdmin

PhpMyAdmin is available as an addon. To install, ensure you have first secured MySQL. Then, as root:

# cd /usr/games/minecraft/addons
# wget http://minecraft.codeemo.com/crux/mineos-scripts/addons/phpmyadmin.sh
# chmod +x phpmyadmin.sh
# ./phpmyadmin.sh