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)
Loading comments...