For example, to configure MySQL to listen for connections from network hosts, in the file /etc/mysql//mysqld.cnf, change the bind-address directive to the server’s IP address: bind-address = 192.168.0.5 You can edit the files in /etc/mysql/ to configure the basic settings – log file, port number, etc.

If the server is not running correctly, you can type the following command to start it: sudo service mysql restartĪ good starting point for troubleshooting problems is the systemd journal, which can be accessed from the terminal prompt with this command: sudo journalctl -u mysql When you run this command, you should see something similar to the following: LISTEN 0 151 127.0.0.1:mysql 0.0.0.0:* users:(('mysqld',pid=149190,fd=29)) The network status of the MySQL service can also be checked by running the ss command at the terminal prompt: sudo ss -tap | grep mysql Oct 08 14:37:38 db. systemd: Started MySQL Community Server. Oct 08 14:37:36 db. systemd: Starting MySQL Community Server. └─2028 /usr/sbin/mysqld -daemonize -pid-file=/run/mysqld/mysqld.pid Loaded: loaded (/lib/systemd/system/rvice enabled vendor preset: enabled)Īctive: active (running) since Tue 14:37:38 PDT 2 weeks 5 days ago

Which should provide an output like the following: You can quickly check its current status via systemd: sudo service mysql status Once the installation is complete, the MySQL server should be started automatically. To install MySQL, run the following command from a terminal prompt: sudo apt install mysql-server It is intended for mission-critical, heavy-load production systems and mass-deployed software.

MySQL is a fast, multi-threaded, multi-user, and robust SQL database server. Multi-node configuration with Docker-Composeĭistributed Replicated Block Device (DRBD)

Mysql server debian