MySQL Setup on Ubuntu Hardy Heron
These are the instructions I use to setup a MySQL database server. Note that WordPress is insisting on screwing up the quotes, so you cannot cut-and-paste the text. If anyone knows how to disable this in (hosted) WordPress, please let me know (and I’m already using the non-GUI editor).
Install Ubuntu Server, do not select a profile at the end.
Install ssh and mysql. It will ask for a root password.
apt-get install ssh mysql-server
Grant the root user access from across the network
mysql -p
GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'password';
Tweek the config to listen on the network and to store each table in a separate file. Edit /etc/mysql/my.cnf and in the [mysqld] section, comment out the existing bind-address and add one with the server’s IP address, and add a line innodb_file_per_table
Restart the server daemon
