Registrations Closing Soon for DevOps Certification Training by CloudxLab | Registrations Closing inEnroll Now
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 -
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:
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user = mysql
basedir = /var/lib
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 (
Temporary tables level permanently (parameter default_tmp_storage_engine)
No hints are availble for this assesment
Answer is not availble for this assesment