Posts

Change indentation in Visual Studio Code (VS Code) |R

Image
Click on the right bottom Spaces option  It will show different spacing options available with visual studio code. Select "Indent using tabs" it will show the different spacing configuration for tab indent select one value and the file tab indent will be updated with the selected value https://stackoverflow.com/questions/34174207/how-to-change-indentation-in-visual-studio-code

MySQL Database Backup Using CLI

 Backup MySQL using terminal mysqldump -u [user name] –p [password] [options] [database_name]  > [dumpfilename.sql] mysqldump -v -u appuser–p  mydb > mydbbackup.sql

Print Date and Time in windows command line without prompt

 Date To print the date in the windows command-line/console. date /T The /T parameter will omit the prompt for a new date. Example: C:\>date /T 21-06-2021 If the user wants to set a new date, use the following command  in command-line date Time To print the time in the windows command-line/console time /T The /T parameter will omit the prompt for a new time. Example C:\>time /T 17:36 if the user wants to set a new time, use the following command in command-line time 

Different Tools

Project Management Redmine Monitoring  Graphite

python-docx | docx | No module named 'exceptions'

If the project is using docx as a reference and installed docx package instead of the   python-docx it will lead to following error ModuleNotFoundError: No module named 'exceptions' To fix this error install python-docx and remove docx. pip install python-docx  To install python-docx package Official Documentation available here: https://pypi.org/project/python-docx/ pip uninstall docx To remove installed docx package

Time Server List

List of time server can be used to configure gadgets and desktops. NIST Sever Name  time.nist.gov Supported Protocols Network Time Protocol (RFC-1305) Daytime Protocol (RFC-867) Time Protocol (RFC-868) Ref: https://tf.nist.gov/tf-cgi/servers.cgi     NTP.ORG Server Names The NTP Pool DNS system automatically picks time servers which are geographically close for you, but if you want to choose explicitly, there are sub-zones of pool.ntp.org. The "continent" ones are: Area: HostName: Worldwide pool.ntp.org Asia asia.pool.ntp.org Europe europe.pool.ntp.org North America north-america.pool.ntp.org Oceania oceania.pool.ntp.org South America south-america.pool.ntp.org Supported Protocols Network Time Protocol ( RFC 5905 , RFC 5906 , RFC 5907 , RFC 5908 ) Simple NTP [SNTP] ( RFC 5905 ) Ref: http://ntp.org

MySQL 8 User creation and grant privileges

Environment MySQL Version: 8.0.21 OS: CentOS 7 Minimal install 64bit MySQL User MySQL user can be created using by the following command in MySQL console CREATE USER 'user1'@'localhost' IDENTIFIED BY 'password1'; If the application connects to MySQL service from a specific IP address application server IP address can be specified in create user statement. CREATE USER 'user1'@'192.168.1.1' IDENTIFIED BY 'password1'; If MySQL needs to connect from different sources using a single username and password. Wildcard(%) can be used instead of an IP address. CREATE USER 'user1'@'%' IDENTIFIED BY 'password1'; % is a wildcard - It can be used as  '%.domain.com' or '%.123.123.123'  To grant privileges to a database, the user must create a database.  Following command granting privileges to a database with name 'school' GRANT ALL ON school.* TO 'user1'@'192.168.1.1'; For localhost connect...