Skip to main content

Posts

Showing posts from December, 2018

History of MySQL from AB Corp to Cloud Database

MySQL was created by a Swedish company, MySQL AB, founded by David Axmark, Allan Larsson and Michael "Monty" Widenius. Original development of MySQL by Widenius and Axmark began in 1994. The first version of MySQL appeared on 23 May 1995. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter,and "SQL", the abbreviation for Structured Query Language.

·23 May 1995 - First internal release ·Year 1996 - Version 3 oSimple CRUD operations oJanuary 1997 Windows version was released on 8 January 1998 for Windows 95 and NT oproduction release 1998, from www.mysql.com
·Year 2002 - Version 4 oMyISAM ounions oTracking oB-trees osubqueries oprepared statements
·Year 2005 - Version 5.0 ocursors, stored procedures, triggers, views, oFederated Storage Engine oEvent scheduler, partitioning, plugin API, row-based replication, server log tables

Ignore a table from backup in mysql

Sometimes it happens that you need to ignore a table from backup due to any reason like
1. Table size is big, we keep log in that data.
2. Table that don't need to copy in backup.
3. Database copying from prod to test and some tables don't need in backup file.
Generally when we create backup in single dump file it consolidate all db schema and data and if we need to exclude any table of sets of tables, then we need to use "--ignore-table" clause in mysqldump command.

Syntax is as below.

mysqldump -h <host> -u <username> -p <schema> --no-create-info --ignore-table=schema.table1  > db-data.sql

Thanks for reading Plz dont forget to like Facebook Page.. https://www.facebook.com/pages/Sql-DBAcoin/523110684456757

How to grant all privileges in mysql8

Hello Friends,

How are you, hope you are doing good. Cold have been started in the country, specially northern India and I also started mysql 8.0 on AWS RDS instance. Yesterday I was trying to give full permission to new created user from all the IP in mysql 8, It started giving me error 1406. I was using below query to give permission, as the same we were using earlier in all versions.

grant all privileges on *.* to 'youngdbauser'@'%' with grant option;

Above query gives error 1406 in mysql 8.0. After lots of trying and dig inside error and mysql portal. Then I created user with full permission in create statement only. This is the new statement with create user which I seen in mysql document portal.

create user ''youngdbauser''@'%' identified by 'mypass';
grant all privileges on *.* to 'youngdbauser'@'%' with grant option;

It resolved my issue.

Summary : Now you can must specify the user's local during create statemen…