mysql source installation on ubuntu

wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.26.tar.gz

tar xvf mysql-5.6.26.tar.gz 
cd mysql-5.6.26
cmake -DCMAKE_INSTALL_PREFIX=/data/mysql \
-DSYSCONFDIR=/etc \
-DMYSQL_TCP_PORT=3306 \
-DDEFAULT_CHARSET=utf8 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EXTRA_CHARSETS=all \
-DDEFAULT_COLLATION=utf8_general_ci \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DMYSQL_DATADIR=/data/mysql/data \
-DWITH_SSL=system \
-DENABLE_DOWNLOADS=1
make 
make install 

#start 
sudo bash -c "bin/mysqld_safe --user=mysql &"

#this will make the connection
mysql -uroot -h127.0.0.1


## http://dev.mysql.com/doc/refman/5.6/en/installing-source-distribution.html

mysql> SELECT User, Host, Password FROM mysql.user;


mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'::1' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'%' = PASSWORD('newpwd');