How to display serial port in GCP Cloud Shell.
gcloud compute instances get-serial-port-output instance-name \ --zone=us-central1-a \ --project=your-project-id |
Running MySQL commands from the Terminal
You can run MySQL commands from the terminal by using -e switch. Here are a few examples.
mysql -u username -p -e "create database mydb" mysql -u username -p -e "use mydb" mysql -u username -p database -e "select * from mytable" |
If you have .mycnf configured, you can omit the username and password.
mysql -e "create database mydb" mysql -e "use mydb" mysql -e "select * from mytable" |
To run multiple commands from a single line, separate the commands using a semicolon.
mysql -e "create database somedb; use mydb; select * from mytable;" |
Linux Format USB Drive
Here’s how to format a USB drive on Linux.
Plug in the USB drive to see mount point.
# scan for all drives df -Th Filesystem Type Size Used Avail Use% Mounted on /dev/sdc1 fuseblk 30G 66M 30G 1% /media/ulysses/451B99AF225B48EC |
Unmount USB drive.
umount /dev/sdc1 |
Choose a file system type and run the appropriate format command.
# nfts format mkfs.ntfs /dev/sdc1 # vfat format mkfs.vfat /dev/sdc1 # ext4 format mkfs.ext4 /dev/sdc1 |