MySQL Setup on Ubuntu Hardy Heron

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