01-05 - install popSql part 2

01

Open the app and sign in, after sign in follow the prompts

02

When I reached this prompt i chose Other

03

popSql will open, but we will be on PopSQL Sample Data server,

04

If we try to create a table we will get an error, we need to create and connect to a new mySql server with our user data base created in the terminal called db1,
(look at section 1 - 03 - install MAC part2 step 08) use root with the password we created at the end of the installation of SQL, our password is password,
(see section 1 - 02 - install Mac Part2 step 05)

05

Go to PopSQL → Settings and follow the steps in the video to the right, give it any name at the top

Use localhost, Use the database name we assigned in the terminal (see section 1 3. install Mac part 2 step 08)

the user name should be root and the password is the one we setup at the end of the SQL installation which was password (see section 1 2. install Mac part 1 step 05)

at the end make sure you switch to the mySql server to create a table

select and run the table then the DESCRIBE lines, You can use command + r