Computer Programming web Web programming Tips



MySQL Community Server 8.0.12 Installation on Windows. Part 4

By Sergey Skudaev


From the main menu select MySQL, MySQL Shell. The command prompt window is displied

MySQL Shell

You can type ´\help´ command to see all commands.

MySQL shell

To connect to the MySQL Server type the following command: ´\connect root@localhost/mysql´ and press enter. The shell prompts you for the password. Type the password for the root user and press enter. If the password is correct, you are connected.

MySQL shell

To switch to SQL mode, type ´\sql´ command. Then type: ´show databases;´ command. The list of databases are displayed.

MySQL shell

Copy the create table SQL statement and paste it to the command prompt window. Press enter. The student table is created.

  CREATE TABLE students (
  stid int(11) NOT NULL auto_increment,
  lastname varchar(20) default NULL,
  firstname varchar(20) default NULL,
  username varchar(20) default NULL,
  password varchar(100) default NULL,
  email varchar(100) default NULL,
  role varchar(20) default NULL,
  PRIMARY KEY  (stid)
);

MySQL shell

Insert a few student records

If you want to learn SQL visit the following web pages:

Learn SQL

XAMPP SHELL

MySQL Community Server 8.0.12 Installation on Windows. Part 1...

MySQL Community Server 8.0.12 Installation on Windows. Part 2...

MySQL Community Server 8.0.12 Installation on Windows. Part 3...



Our dog needs urgent surgery, and the cost is overwhelming.

Any help, big or small, would mean the world to us. Thank you for supporting Oscar on his journey to recovery!



Oscar Story.

Oscar wasn’t just any puppy—he was a gift from a mother who trusted us with her smallest one.

For five years, my wife worked at the Indian Medical Center in Arizona, deep in Navajo Nation. Near her clinic, she often saw a homeless dog wandering the area. Over time, she began feeding her, and the dog grew fond of her. Then, one day, that same dog brought her newborn puppies to my wife—as if proudly showing them off.

Among them was the smallest, most delicate pup. My wife couldn’t resist. She brought him home, and we named him Oscar.

Oscar thrived in the house provided by the medical center, enjoying the big backyard where he lived. I built him a sturdy wooden doghouse, and we often took him on walks along the Window Rock Trail. He became our adventure companion, making the vast desert feel like home.

After my wife’s contract ended, we moved back to Florida, bringing Oscar with us. He adjusted to his new surroundings, but he never lost his adventurous spirit.

Now, Oscar faces a tough challenge—he needs urgent surgery, and the cost is overwhelming. We want to give him the best care possible, just as he’s given us years of joy and loyalty.

Any help, big or small, would mean the world to us. Thank you for supporting Oscar on his journey to recovery!



My  eBooks  on  Amazon

US    UK    BR    CA
US    UK    BR    CA
US    UK    BR    CA
US   UK   BR   CA