MySQL 5.7 installation from Binaries

MYSQL 5.7 Installation Steps.

sudo chown -R mysql:mysql /mysqldata /mysqlbinlog /mysqltemp
mkdir -p /mysqldata/data /mysqldata/config /mysqldata/software /mysqldata/mysqlbinary
mkdir -p /mysqlbinlog/slowlog /mysqlbinlog/binlog
sudo cp /home/cloud-user/mysql-advanced-5.7.18-linux-glibc2.5-x86_64.tar.gz /mysqldata/mysqlbinary
sudo chown -R mysql:mysql /mysqldata/mysqlbinary


cd /mysqldata/mysqlbinary
tar -zxvf mysql-advanced-5.7.18-linux-glibc2.5-x86_64.tar.gz
mv mysql-advanced-5.7.18-linux-glibc2.5-x86_64 mysql
scp 10.144.160.183:/mysqldata/config/my.cnf /mysqldata/config/my.cnf

/mysqldata/mysqlbinary/mysql/bin/mysqld --initialize --user=mysql --basedir=/mysqldata/mysqlbase --datadir=/mysqldata/data


Note :- After intialization last line it will create complex password like  g,PAyic-l6g1.


E.g. A temporary password is generated for root@localhost: g,PAyic-l6g1.


/mysqldata/mysqlbinary/mysql/bin/mysqld_safe --defaults-file=/mysqldata/config/my.cnf  &


Note :- Above step will bring up mysql service, can be verified by ps -ef | grep -i mysqld.


Once up kindly login to the mysql with complex password mentioned above.
/mysqldata/mysqlbinary/mysql/bin/mysql -u root -p -S /mysqldata/data/mysql.sock


Note :- Socket file path can be verified by mysqld process.
Once logged into the mysql before running any other command please set password as,


SET PASSWORD = PASSWORD('N3wC0mple#P@ssw0rd');
once done you should be able to excute other commands as well.