ubuntu install mysql mysql Change password 20160624

MysqlAdmin for windows
http://dev.mysql.com/downloads/gui-tools/5.0.html


telnet 127.0.0.1 3306

unistall mysql
 apt-get purge mysql-server mysql-client mysql-common mysql-client-5.5 mysql-server-5.5


ubuntu-mysql

inf : https://help.ubuntu.com/lts/serverguide/mysql.html

sudo apt-get install mysql-server
sudo r| grep mysql ## check whether the MySQL server is running
sudo service mysql restart
/etc/mysql/my.cnf ## configuration mysql-config
log_bin_trust_function_creators=true

bind-address            = 192.168.0.5

sudo service mysql restart
sudo dpkg-reconfigure mysql-server-5.5 ## change the MySQL root password
mysqldump --all-databases --all-routines -u root -p > ~/fulldump.sql
sudo service mysql stop



Now backup the original my.cnf file and replace with the new one:
sudo cp /etc/my.cnf /etc/my.cnf.backup
sudo cp /path/to/new/my.cnf /etc/my.cnf


Check the mysql listen port

# netstat -tln
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State
tcp        0      0 0.0.0.0:10000           0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN
tcp6       0      0 :::8080                 :::*                    LISTEN
tcp6       0      0 :::22                   :::*                    LISTEN
tcp6       0      0 127.0.0.1:8005          :::*                    LISTEN

Chkconfig mysql-status

apt-get install sysv-rc-conf
chkconfig
apt-get install chkconfig
chkconfig
sysv-rc-conf apache2 on
chkconfig
chkconfig | mysql
chkconfig | grep mysql
sysv-rc-conf mysql on
chkconfig | grep mysql
chkconfig --list mysql