## 5.7.20

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20: cat ~umshastr/.my.cnf
[client]
user=root
socket=/tmp/mysql_ushastry.sock
password=
 
-- binary tarball
rm -rf 89267
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/89267 
bin/mysqld --basedir=$PWD --datadir=$PWD/89267 --core-file --socket=/tmp/mysql_ushastry.sock --port=3307 --log-error=$PWD/89267/log.err 2>&1 &

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20:  bin/mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.20 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set password=password('mysql123');
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> \q
Bye
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20:  bin/mysql -uroot -S /tmp/mysql_ushastry.sock
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

-- update ~umshastr/.my.cnf
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20: vi ~umshastr/.my.cnf
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20: cat ~umshastr/.my.cnf
[client]
user=root
socket=/tmp/mysql_ushastry.sock
password=mysql123

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20: bin/mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.20 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> \q
Bye
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown
[1]+  Done                    bin/mysqld --basedir=$PWD --datadir=$PWD/89267 --core-file --socket=/tmp/mysql_ushastry.sock --port=3307 --log-error=$PWD/89267/log.err 2>&1

## 8.0.4 - in-place upgrade, make sure to pass --skip-slave-start --skip-grant-tables --skip-networking --skip-innodb-buffer-pool-dump-at-shutdown --explicit-defaults-for-timestamp --skip-read-only

bin/mysqld --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.7.20/89267 --core-file --socket=/tmp/mysql_ushastry.sock --port=3307 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.7.20/89267/log.err --skip-slave-start --skip-grant-tables --skip-networking --skip-innodb-buffer-pool-dump-at-shutdown --explicit-defaults-for-timestamp --skip-read-only 2>&1 &

-- excerpt from error log


2018-01-17T10:02:05.558611Z 0 [Warning] [MY-011070] Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it is deprecated and will be removed in a future release.
2018-01-17T10:02:05.558822Z 0 [System] [MY-010116] /export/umesh/server/binaries/Trunk/mysql-8.0.4-rc-linux-glibc2.12-x86_64/bin/mysqld (mysqld 8.0.4-rc-log) starting as process 12106 ...
2018-01-17T10:02:08.360360Z 0 [Warning] [MY-010068] CA certificate ca.pem is self signed.
2018-01-17T10:02:08.467675Z 0 [ERROR] [MY-001146] Table 'mysql.component' doesn't exist
2018-01-17T10:02:08.467740Z 0 [Warning] [MY-003543] The mysql.component table is missing or has an incorrect definition.
2018-01-17T10:02:08.472916Z 0 [Warning] [MY-010405] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2018-01-17T10:02:08.472960Z 0 [ERROR] [MY-010422] Error in checking mysql.slave_master_info repository info type of TABLE.
2018-01-17T10:02:08.472977Z 0 [ERROR] [MY-010415] Error creating master info: Error checking repositories.
2018-01-17T10:02:08.472984Z 0 [ERROR] [MY-010426] Slave: Failed to initialize the master info structure for channel ''; its record may still be present in 'mysql.slave_master_info' table, consider deleting it.
2018-01-17T10:02:08.472992Z 0 [ERROR] [MY-010529] Failed to create or recover replication info repositories.
2018-01-17T10:02:08.473246Z 0 [System] [MY-010931] /export/umesh/server/binaries/Trunk/mysql-8.0.4-rc-linux-glibc2.12-x86_64/bin/mysqld: ready for connections. Version: '8.0.4-rc-log'  socket: '/tmp/mysql_ushastry.sock'  port: 0  MySQL Community Server (GPL).


-- try to connect 
 [umshastr@hod03]/export/umesh/server/binaries/Trunk/mysql-8.0.4-rc-linux-glibc2.12-x86_64: bin/mysql
ERROR 2000 (HY000): Unknown MySQL error

[umshastr@hod03]/export/umesh/server/binaries/Trunk/mysql-8.0.4-rc-linux-glibc2.12-x86_64: bin/mysql_upgrade
mysql_upgrade: Got error: 2000: Unknown MySQL error while connecting to the MySQL server
Upgrade process encountered error and will not continue.


## restart without --skip-grant-tables

bin/mysqld --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.7.20/89267 --core-file --socket=/tmp/mysql_ushastry.sock --port=3307 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.7.20/89267/log.err --skip-slave-start --skip-networking --skip-innodb-buffer-pool-dump-at-shutdown --explicit-defaults-for-timestamp --skip-read-only 2>&1 &

[umshastr@hod03]/export/umesh/server/binaries/Trunk/mysql-8.0.4-rc-linux-glibc2.12-x86_64: bin/mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.4-rc-log MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show variables like '%version%';
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 8.0.4                        |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| tls_version             | TLSv1,TLSv1.1,TLSv1.2        |
| version                 | 8.0.4-rc-log                 |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86_64                       |
| version_compile_os      | linux-glibc2.12              |
+-------------------------+------------------------------+
8 rows in set (0.01 sec)
mysql> system cat docs/INFO_SRC
commit: 876a72f83457403c5165623fd7a31699563d08ef
date: 2018-01-04 15:02:58 +0100
build-date: 2018-01-04 15:05:59 +0100
short: 876a72f
branch: mysql-8.0.4-rc-release

MySQL source 8.0.4