![]() ![]() ![]() MySQL is designed to allow data to be stored in different ways. Whilst the default configuration of MySQL provided by the Ubuntu packages is perfectly functional and performs well there are things you may wish to consider before you proceed. Replace 192.168.0.5 with the appropriate address, which can be determined via ip address show.Īfter making a configuration change, the MySQL daemon will need to be restarted: sudo systemctl restart rvice 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 at 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 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 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |