How to use MySql database in travis CI

Travis CI Discussions & Feedback
1 
language: python
sudo: enabled
services:
    - mysql
python:
    - "3.7.3"
env:
    global:
     - TRAVIS=true
before_install:
    - sudo mysql -e 'CREATE DATABASE pianyuan;'
    - sudo mysql -e 'select database();'
    - sudo mysql -e 'SHOW DATABASES;'
    - sudo mysql -e 'USE pianyuan;'
    - sudo mysql -e 'select database();'
    - sudo mysql --version
# command to install dependencies
install:
    - pip install -r requirements.txt
script:
    - python main.py

but the code - sudo mysql -e 'USE pianyuan;' didn’t worked, I couldn’t select a mysql database, WHY???

2

Would it be possible for you to post the name of your repository and a link/url to a build that shows the error you mention? Thanks!

3

In this commit, I create a database, but the cli use pianyuan didn’t work, I could’t not create a table because CI told me that No database selected

4

In this github commit

5

Every

sudo mysql -e ...

is separate process. Once completed its effect on connection is gone.

Try

sudo mysql -e 'USE pianyuan; create  table film...;'
1 Like
6

thanks， It’s work!