In this post we will see how to install Mysql Database 5.7.35 in Linux Operating System.

For more interesting posts on MySQL, please click on INDEX

Steps :

1. Create the below directories :

mkdir -p /mysqldatabase/TEST/admin/
mkdir -p /mysqldatabase/TEST/logs/
mkdir -p /mysqldatabase/TEST/tmp
mkdir -p /mysqldatabase/TEST/data
mkdir -p /mysqldatabase/TEST/binlogs
mkdir -p /mysqldatabase/product/binary


2. Traverse to the location where you want to install the MySQL Binaries

cd /mysqldatabase/product/binary


3. Get the Link to download the binaries

Go to google and search for MySQL 5.x download.

Select the operating system and OS Version to download the edsired version. If the desired version isn’t available, then click on Archives and check for the latest version.

4. Click on download besides Compressed TAR Archive and copy the Link Address from “No thanks, just start my download


5. Download the Setup file with the copied link

[mysql@test binary]$ wget


6. Unzip and untar the file

[mysql@test binary]$ tar -zxvf mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz


7. Create a softlink to the extracted file (optional)

[mysql@test binary]$ ln -s mysql-5.7.35-linux-glibc2.12-x86_64 5.7.35


8. Create the my.cnf file

vi /mysqldatabase/TEST/admin/my.cnf
port = 3306
socket = /mysqldatabase/TEST/admin/mysql.sock


port = 3306
socket = /mysqldatabase/TEST/admin/mysql.sock
max_allowed_packet = 32M
query_cache_size = 32M
table_open_cache = 512K
sort_buffer_size = 4M
read_buffer_size = 2M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 4M
thread_cache_size = 25
key_buffer_size = 32M
server-id = 1
net_read_timeout = 60
innodb_data_home_dir = /mysqldatabase/TEST/data
innodb_data_file_path = ibdata1:200M;ibdata2:200M:autoextend
innodb_buffer_pool_size = 4096M
innodb_log_file_size = 1024M
innodb_log_buffer_size= 512M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 500


9. Install MySQL database

cd /mysqldatabase/product/binary/5.7.35
[mysql@test 5.7.35]$ bin/mysqld --defaults-file=/mysqldatabase/TEST/admin/my.cnf --initialize --user=mysql
2021-10-01T16:01:46.428149Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 1048686)
2021-10-01T16:01:46.428271Z 0 [Warning] Changed limits: table_open_cache: 457 (requested 524288)
2021-10-01T16:01:46.428597Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
 100 200
 100 200
 100 200 300 400 500 600 700 800 900 1000
 100 200 300 400 500 600 700 800 900 1000
2021-10-01T16:01:53.053944Z 0 [Warning] InnoDB: New log files created, LSN=45791
2021-10-01T16:01:53.113695Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-10-01T16:01:53.191290Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: e4fc1dfb-22d0-11ec-9497-0800271f22df.
2021-10-01T16:01:53.192417Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-10-01T16:01:53.923155Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2021-10-01T16:01:53.923182Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2021-10-01T16:01:53.928363Z 0 [Warning] CA certificate ca.pem is self signed.
2021-10-01T16:01:54.344747Z 1 [Note] A temporary password is generated for root@localhost: Mu,jT7!jC?=&

10. Get the root password
From the above the installation logs, you can get the root password. Here the temporary root password is Mu,jT7!jC?=&

11. Start the Instance and login to the instance to change the root password

[mysql@test 5.7.35]$ bin/mysqld_safe --defaults-file=/mysqldatabase/TEST/admin/my.cnf --user=mysql &

[mysql@test 5.7.35]$ /mysqldatabase/product/binary/5.7.35/bin/mysql -h127.0.0.1 -P3306 -uroot -p

( Use password from mysqld.log and change the password as mentioned )

mysql>  ALTER USER 'root'@'localhost' IDENTIFIED BY 'mysql';