trying to build in power using travis .

The package PyMySQL having problem in authenticate methods test for mysql8.0.
The package is able to connect to mysql and perform unit tests successfully, However there is another test which helps to test the authentication for t he users ,It requires to create userid using root and it fails , I have tried the same on VM,It works well on vm under the same dist/steps,
The below is failing sqls
0.01s$ mysql -h127.0.0.1 -uroot -e 'create database test2 DEFAULT CHARACTER SET utf8mb4'
0.01s$ mysql -h127.0.0.1 -utravis -e "create user test2 identified ${WITH_PLUGIN} by 'some password'; grant all on test2.* to test2;"
ERROR 1044 (42000) at line 1: Access denied for user 'travis'@'localhost' to database 'test2'
The command "mysql -h127.0.0.1 -utravis -e "create user test2 identified ${WITH_PLUGIN} by 'some password'; grant all on test2.* to test2;"" failed and exited with 1 during .
Your build has been stopped.
0.01s$ mysql -uroot -h127.0.0.1 -e ' CREATE USER user_sha256 IDENTIFIED WITH "sha256_password" BY "pass_sha256_01234567890123456789", nopass_sha256 IDENTIFIED WITH "sha256_password", user_caching_sha2 IDENTIFIED WITH "caching_sha2_password" BY "pass_caching_sha2_01234567890123456789", nopass_caching_sha2 IDENTIFIED WITH "caching_sha2_password" PASSWORD EXPIRE NEVER; GRANT RELOAD ON . TO user_caching_sha2;'
ERROR 1524 (HY000) at line 1: Plugin 'caching_sha2_password' is not loaded
The command "mysql -uroot -h127.0.0.1 -e ' CREATE USER user_sha256 IDENTIFIED WITH "sha256_password" BY "pass_sha256_01234567890123456789", nopass_sha256 IDENTIFIED WITH "sha256_password", user_caching_sha2 IDENTIFIED WITH "caching_sha2_password" BY "pass_caching_sha2_01234567890123456789", nopass_caching_sha2 IDENTIFIED WITH "caching_sha2_password" PASSWORD EXPIRE NEVER; GRANT RELOAD ON . TO user_caching_sha2;'" failed and exited with 1 during

Steps:

0.66s$ git clone --depth=50 --branch=master https://github.com/asellappen/PyMySQL.git asellappen/PyMySQL
0.01s0.01s$ source ~/virtualenv/python3.9/bin/activate
$ python --version
Python 3.9.1
$ pip --version
pip 20.3.1 from /home/travis/virtualenv/python3.9.1/lib/python3.9/site-packages/pip (python 3.9)
before_install.1
50.43s$ sudo apt-get install rustc
before_install.2
2.87s$ sudo apt install mysql-server
before_install.3
$ python3 -m pip install PyMySQL[rsa]
before_install.2
2.87s$ sudo apt install mysql-server
before_install.4
3.08s$ pip install mysql-connector-python --no-cache-dir
before_install.5
0.40s$ sudo /etc/init.d/mysql start
before_install.6
1.59s$ pip install pyparsing urllib3 toml --no-cache-dir
before_install.7
0.02s$ mysql -e "SELECT user FROM mysql.user;"
before_install.8
0.01s$ mysql -e " SHOW GRANTS FOR 'root'@'localhost'"
before_install.9
0.01s$ mysql -uroot -e "SELECT SUBSTRING_INDEX(USER(), '@', -1) AS ip, @@hostname as hostname, @@PORT as port, DATABASE() as current_database;"
before_install.10
0.01s$ mysql -uroot -e "select CURRENT_USER();"
before_install.11
0.01s$ mysqladmin -u root version
before_install.12
0.01s$ mysql -h127.0.0.1 -uroot -e "SET GLOBAL local_infile=on"
before_install.13
0.01s$ mysql -h127.0.0.1 -uroot -e 'create database test1 DEFAULT CHARACTER SET utf8mb4'
before_install.14
0.01s$ mysql -h127.0.0.1 -uroot -e 'create database test2 DEFAULT CHARACTER SET utf8mb4'
0.01s$ mysql -h127.0.0.1 -utravis -e "create user test2 identified ${WITH_PLUGIN} by 'some password'; grant all on test2.* to test2;"
ERROR 1044 (42000) at line 1: Access denied for user 'travis'@'localhost' to database 'test2'
The command "mysql -h127.0.0.1 -utravis -e "create user test2 identified ${WITH_PLUGIN} by 'some password'; grant all on test2.* to test2;"" failed and exited with 1 during .

ERROR 1044 (42000) at line 1: Access denied for user 'travis'@'localhost' to database 'test2'?