MySQL, run the following command from a terminal prompt:
apt-get install mysql-server
This will also install
mysql-client, so it is not necessary to specify it explicitly. During the installation process you will be prompted to enter a password for the MySQL root user.
Once the installation is complete, the MySQL server should be started automatically. You can run the following command from a terminal prompt to check whether the MySQL server is running:
netstat -tap | grep mysql
When you run this command, you should see the following line or something similar:
tcp 0 0 localhost:mysql *:* LISTEN 2556/mysqld
If the server is not running correctly, you can type the following command to start it:
service mysql restart
Since version 5.5
InnoDB as its default storage engine. By default the InnoDB data will be stored in a single file,
/var/lib/mysql/ibdata1, and this file could grow really big.
This file has a initial size of 10Mb and it automatically extends. InnoDB data files can’t shrink, they only expand.
DROP etc. will not free up diskspace, instead, freed regions are marked as unused and can be reused later. It is possible to specify a limit in
my.cnf, but none is set by default (therefore the data file will increase until all diskspace is consumed :().
It is possible to configure
MySQL to use a separate data file for each InnoDB table by using the
Add the following line to
[mysqld] # Use separate data files for each table. innodb_file_per_table