ldong/mysql_notes.md

## mysql_notes.md

      
    Raw
  

              mysql_notes.md
            
          
    Add new user

https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-14-04
Installation

sudo mysql_secure_installation
sudo apt-get install mysql-server
MySQL

netstat -tln
sudo /etc/init.d/mysql restart
sudo service mysql restart
sudo vim /etc/mysql/my.cnf
sudo mysql -u root -p
SHOW GLOBAL VARIABLES LIKE 'PORT';
sudo ufw allow 3306/tcp
sudo service ufw restart
Login

mysql -h 192.241.203.159 -u root -p
Password: root