Running Mysql inside the Docker and expose the port to host machine

Prequisite

1. Docker installed
2. mysql client on the host machine is installed / Use Java client program to connect

Step 1 

Download mysql image from docker central

    docker pull mysql

Step 2

Check in docker whether image is available

    docker image ls

Step 3

Run the docker container command, which will create container and start it. 

The -p options will expose the port 3306 of mysql running inside the container to be accessibkle by host machine

docker run --detach --name=mysql --env="MYSQL_ROOT_PASSWORD=root" -p 127.0.0.1:3307:3306 mysql

Step 4

Check whether mysql Service Started. The container will be shown.

     docker ps

Step 5

Connect mysql from docker host machine

    mysql -uroot -proot -h127.0.0.1 --port=3307

Mysql Installation in 3 Steps For Mac/Apple

Pre-Requisite

Add the below paths to "/etc/paths"

/usr/local/mysql/bin

/usr/local/mysql/support-files

Step 1

Using any SQL clients install the MySql in your Mac

• MySQL .dmg Archive (Download Link: https://dev.mysql.com/downloads/mysql/)
• Brew (CLI)

Command for Brew

brew install mysql

Error 

If brew installation failing, try reinstalling the mysql.

brew reinstall mysql    

If its still not working, execute below commands to remove all the folders and run the brew install command again.

sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
rm -rf ~/Library/PreferencePanes/My*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /private/var/db/receipts/*mysql*

Step 2 

Initialise mysql client using the below command which will create all the necessary data folders.

mysqld --initialize

If mysqld command not found is returned, add the below paths

    vi /etc/paths

Add the below paths to it

/usr/local/mysql/bin

/usr/local/mysql/support-files

 

Error

!!!! Do not create "data" folder under /usr/local/mysql* !!!!

The mysql "--initialize" command will take care of it. Delete the data folder if its created by you.

"The designated data directory /usr/local/mysql-8.0.25-macos11-x86_64/data/ is unusable. You can remove all files that the server added to it."

Step 3

Start the mysql server

    mysql.server start

If you still face issues try uninstalling mysql and follow from all the Steps. 

COVID - Bed Availability - Helpful Links - Remedisivir Vaccine - Tamil Nadu

TamilNadu COVID Bed Availability:

https://tncovidbeds.tnega.org/

https://u07.ihx.in/ 

Chennai Zone Bed Availability Tracker:
https://chennai-zones.herokuapp.com/privateHospitals

COVID CONTROL ROOM CHENNAI

+91 1800 120 555 550
+91 44 2538 4530
+91 44 2538 4520


Twitter for Help:
https://mobile.twitter.com/104_gotn
https://twitter.com/1O4GoTN

Remedisivir Vaccine Availability

Place to Check for Availability

• District Govt Hospitals
• KMC Chennai

Documents Required

• Patient Aadhaar Card
• RT PCR Test Results
• Chest CT Scan Photo Copy
• Doctor Prescription

From Twitter

Family Impacted by COVID looking for Food support in Chennai
If you are looking for support of food, kindly check the below contact numbers.

Donate to COVID Releief:

https://donate.indiacovidresources.in/

Fund Raising For Covid:

https://docs.google.com/document/d/1eiobgyrl8iz-R1Dz7c4R5pzzzkuZLBj99vaC7T_UeVo/preview?pru=AAABeTK9SEw*gIQVCszE9NaFaRxD2JlXIA


COVID Chat Bots:

https://www.covidsos.live/app/index.html

How to Freeze and UnFreeze Multiple Excel Panes

 Excel Version Used: 16.48

Freeze Multiple Rows

Step 1: Under the View ribbon check for option if UnFreeze Panes exists if any rows already frozen.

Step 2: Place the Cursor in the row where all the above row need to be frozen and click the "Freeze Panes" button now to freeze all the rows above the cursor.

Freeze Multiple row and Column

Step 1: Under the View ribbon check for option if UnFreeze Panes exists if any rows already frozen.

Step 2: Place the Cursor in the row where all the above row and left column need to be frozen and click the "Freeze Panes" button now to freeze all the rows above the cursor and left columns of the cursor.