notes of setting up mysql for test env

Posted on |

On windows

start and trigger mysql cmd

  • start default mysql db engine
1
mysqld
  • connect to mysql engine and get the cmd prompt
1
mysql -u root -p -h localhost

cmd run under mysql cmd prompt

  • list database
1
show databases;
  • create new database
1
create database poc;
  • switch database
1
use poc;
  • list tables
1
show tables;
Reward Makes Perfect
0%