[Autogenerated] with this short module we are going to move into a
discussion where we will be focusing on the accessing of a my sequel
database server and how to communicate with it to collect information when
communicating with a my SQL Server SQL language statements are used to
request specific targeted information.
This can include everything as general as a list of
existing databases and tables.
There's something much more specific where you are looking for information from
a set of fields that match a set of criteria to be clear.
However,
this module is not going to be going into any specifics on SQL
statement syntax or how to use it correctly as this is covered in
many whole other courses on this platform.
Our focus will be on the basics of information collection as it could
be used by you as a network security engineer For python to be able to
correctly communicate with a My SQL Server We must first install a
module that enables this access.
In our case we will be using the my sequel hyphen connector
hyphen Python module that can be installed just like all other
modules discussed using the python dash M pip install command or
the pip three install command.
Once installed we are going to be focusing on the General Python
methods that are used to collect information from within the
databases that sit on the my SQL Server primarily this is going to
be using the my sequel connector.
Python connect and cursor methods along with various SQL statements that
will be crafted to retrieve the intended information.
So now with this information reviewed,
let's move into our demonstration environment.