User Tools

Site Tools


ec2_config

This is an old revision of the document!


EC2 Config

<pre> Installing MySQL with APT

Install MySQL by the following command:

shell> sudo apt-get install mysql-server

This installs the package for the MySQL server, as well as the packages for the client and for the database common files.

During the installation, there are two requests by the dialogue boxes:

  Supply a password for the root user for your MySQL installation.
  Important
  Make sure you remember the root password you set. Users who want to set a password later can leave the password field blank in the dialogue box and just press OK. However, it is very important that you set the password soon using the program mysql_secure_installation, as people can gain anonymous access to your MySQL server until you have secured the database's root account with a password.
  Indicate if you want to install the test database with “Yes” or “No”. Installation of the test database is not recommended for production environments. 

Starting and Stopping the MySQL Server

The MySQL server is started automatically after installation. You can check the status of the MySQL server with the following command:

shell> sudo service mysql status

Stop the MySQL server with the following command:

shell> sudo service mysql stop

To restart the MySQL server, use the following command:

shell> sudo service mysql start </pre>

Console

ec2_config.1436276479.txt.gz · Last modified: 2021/06/04 02:16 (external edit)