SQL with Jupyter Notebook Tutorial

55 / 61

Installing MySQL on your machine

MySQL can be installed on Windows as well as Linux.

All the database names and table names are case sensitive while columns names are not.

Installing MySQL on Linux/UNIX

The recommended way to install MySQL on a Linux system is via RPM. MySQL AB makes the following RPMs available for download on its website -
https://dev.mysql.com/doc/refman/5.5/en/linux-installation-rpm.html

  • MySQL - The MySQL database server manages the databases and tables, controls user access and processes the SQL queries.

  • MySQL-client - MySQL client programs, which make it possible to connect to and interact with the server.

  • MySQL-devel - Libraries and header files that come in handy when compiling other programs that use MySQL.

  • MySQL-shared - Shared libraries for the MySQL client.

  • MySQL-bench - Benchmark and performance testing tools for the MySQL database server.

Installing the packages:

[root@host]# `rpm -i MySQL-client-5.0.9-0.i386.rpm`<br>
[root@host]# `rpm -i MySQL-devel-5.0.9-0.i386.rpm`<br>
[root@host]# `rpm -i MySQL-shared-5.0.9-0.i386.rpm`<br>
[root@host]# `rpm -i MySQL-bench-5.0.9-0.i386.rpm`<br>

All the MySQL related binaries are in /usr/bin and /usr/sbin.
All the tables and databases will be created in the /var/lib/mysql directory.

MySQL runs with a default configuration and it works well for most of the cases. But, if needed, it can be modified.

Configuration file to define custom values to various MySQL parameters:

Config file is /etc/my.cnf
Default values are:
[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock

[mysql.server]
user = mysql
basedir = /var/lib

[safe_mysqld]
err-log = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid

MySQL uses InnoDB engine for DBMS by default.

Database engine of MySQL can be changed at

  • MySQL server level (parameter default-storage-engine), will need database restart changed after initial setup.

  • Table level (ENGINE = INNODB - permanent as well as temporary tables)

  • Session level (SET default_storage_engine=NDBCLUSTER)

  • Temporary tables level permanently (parameter default_tmp_storage_engine)


No hints are availble for this assesment

Answer is not availble for this assesment

Loading comments...