Posted on 2009-11-30
These are the instructions I use to setup a MySQL database server.
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
Tags: mysql