🗄️ MySQL Instructions

MySQL Installation Instructions

MySQL (OPTIONAL)

(NOTE: If you don't plan on using the SeleniumBase MySQL DB feature, then you can skip this section.)

---

GitHub Actions Ubuntu Linux MySQL Setup

sudo /etc/init.d/mysql start
mysql -e 'CREATE DATABASE IF NOT EXISTS test_db;' -uroot -proot
wget https://raw.githubusercontent.com/seleniumbase/SeleniumBase/master/seleniumbase/core/create_db_tables.sql
sudo mysql -h 127.0.0.1 -uroot -proot test_db < create_db_tables.sql
sudo mysql -e 'ALTER USER "root"@"localhost" IDENTIFIED BY "test";' -uroot -proot
sudo service mysql restart

Have SeleniumBase tests write to the MySQL DB:

pytest --with-db_reporting

Query MySQL DB Results:

mysql -e 'select test_address,browser,state,start_time,runtime from test_db.test_run_data;' -uroot -ptest

---

Standard Ubuntu Linux MySQL Setup

sudo apt update
sudo apt install mysql-server
sudo mysql_secure_installation
sudo mysql -e 'CREATE DATABASE IF NOT EXISTS test_db;'
sudo mysql -h 127.0.0.1 -u root test_db < seleniumbase/core/create_db_tables.sql
sudo service mysql restart

To change the password from root to test:

mysqladmin -u root -p'root' password 'test'
sudo service mysql restart

MacOS MySQL Setup

brew install mysql

Then start the MySQL service:

brew services start mysql

(Continue with additional steps below to set up your DB.)

Windows MySQL Setup

Download MySQL here Follow the steps from the MySQL Downloads page.

(Continue with additional steps below to set up your DB.)

Access your MySQL DB

If you want a visual tool to help make your MySQL life easier, try MySQL Workbench.

Prepare your MySQL DB

Use the create_db_tables.sql file to create the necessary tables for storing test data.

Configure your MySQL DB for SeleniumBase

Update your settings.py file with your MySQL DB credentials so that tests can write to the database when they run.

Have SeleniumBase tests write to your MySQL DB

Add the --with-db_reporting argument on the command-line when you want tests to write to your MySQL database. Example:

pytest --with-db_reporting