Renato Gama

Rodando Ubuntu

1. sudo apt-get install mysql-common
2. sudo apt-get install mysql-server

Rodando Amazon Linux

# Update all packages
sudo yum update

# Install mysql client
sudo yum install mysql

# Create a data directory for MySQL (this step may not be needed,
# or you may need to modify the /etc/my.cnf datadir setting
# if you want to store the data somewhere else. Beware that
# data may be lost if it is not stored in the right place
# on Amazon EC2!)
sudo mkdir /var/lib/mysql

# Install mysql server
sudo yum install mysql-server

# Configure my.cnf settings using “nano” text editor
# For example, you can add a line like max_allowed_packet=16M (the default is 1M)
# Or bind-address=0.0.0.0

nano /etc/my.cnf

# Start mysql server
sudo /etc/init.d/mysqld start

# Set root password for MySQL (Choose a strong one if the
# MySQL TCP port is going to be left open.)
mysqladmin -u root password ’123456789′

# OU VOCE PODE RODAR /usr/bin/mysql_secure_installation QUE É UM GUIA PARA: remover usuario anonimo, # apagar base de dados de teste e liberara acesso remoto.

# Configure mysql to run on startup
sudo chkconfig mysqld on

retirado de: http://www.somacon.com/p572.php

Para Garantir o Acesso Remoto

mysql> use mysql
mysql> GRANT ALL ON *.* to root@’%’ IDENTIFIED BY ‘your-root-password’;
mysql> FLUSH PRIVILEGES;