mysql Archives - SysOpsPro

How to connect to MySQL without a password prompt

Post author:SOP Admin
Post published:October 17, 2021
Post category:MySQL
Post comments:0 Comments

It is possible to login into your MySQL instance without a password input. This is useful when we want to connect to MySQL from an script or run MySQL commands from the bash terminal with MySQL -e (execute) option.

How to execute MySQL scripts (.sql) files

Post author:SOP Admin
Post published:October 1, 2021
Post category:MySQL
Post comments:0 Comments

SQL script simply contains a series of SQL statements to be executed in order. This helps readability, allows reusability, and mitigates the chances of making mistakes. Besides, you can also get your script peer-reviewed.