luyện

Ways to check MySQL version mysql --version mysql -V dpkg -l 'mysql-sever' mysql -u root -p How to check MySQL version: mysql --version Database folder On Microsoft Windows, by default, MySQL save databases in this folder: %ProgramData%\MySQL\MySQL Server 5.5\data Check databases' size SELECT table_schema AS "Database name", SUM(data_length + index_length) / 1024 / 1024 AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema; Export database schema $ mysqldump -u root -p --no-data wordpress1001 > c:\backup\schema-wordpress1001.sql Enter password: **************** Create a dedicated user to backup databases Give credit to: http://www.fromdual.com/privileges-of-mysql-backup-user-for-mysqldump Create dedicated mysql user and grant privileges to run backup $ mysql -u root -p CREATE USER 'backupdb'@'localhost' IDENTIFIED BY 'passwordhere'; GRANT SELECT,SHOW VIEW,RELOAD,REPLICATION CLIENT...

Install PHP Manager for IIS using Web Platform Installer 5.0 Install PHP Manager for IIS using Web Platform Installer 5.0 PHP Manager on IIS 8.5 Remove PHP 5.3 from IIS 8.5 Remove PHP 5.3 from IIS 8.5 Some PHP.ini settings to check session.cookie_secure = True expose_php = off

https://drive.google.com

Who is currently logged on? Who is currently logged on server Enable Network Level Authentication for Remote Desktop connection Enable Network Level Authentication for Remote Desktop connection

Use Conditional Formatting to find duplicate values in Excel Use Conditional Formatting to find duplicate values in Excel

Register free account at https://app.pluralsight.com to explore these free courses.

"Google Sheets is a web-based application that enables users to create, update and modify spreadsheets and share the data online in real time." — TechTarget

-- Check version PRINT @@Version SELECT * FROM sys.configurations -- Show all processes SELECT * FROM sys.sysprocesses -- Check active connections SELECT DB_NAME(dbid) AS DBName, COUNT(dbid) AS NumberOfConnections, loginame FROM sys.sysprocesses GROUP BY dbid, loginame ORDER BY DB_NAME(dbid) -- Check Collation used by all databases USE Master GO  SELECT NAME, COLLATION_NAME  FROM sys.Databases  ORDER BY DATABASE_ID ASC  GO -- Enable 'sa' login ALTER LOGIN [sa] ENABLE GO

Unhide all hidden rows and columns at the same time Apply to: Microsoft Excel 2010, Microsoft Excel 2013 Select all cells on a worksheet: Press CTRL + A On the Home tab, in the Cells group, click Format. Under Visibility, point to Hide & Unhide, and then click Unhide Rows or Unhide Columns. Microsoft Excel: Unhide Rows and Columns

First of all, check BIOS Settings of your laptop or desktop Dell Look for USB PowerShare BIOS Settings: USB PowerShare Lenovo Look for Always On USB Charge in Off Mode BIOS Settings: Enable Always On USB Charge in Off Mode