)īind-address = ( The ip address of your Service Net interface. )īind-address = ( The ip address of your Public Net interface.

MySQL, by default is no longer bound to ( listening on ) any remotely accessible interfaces.Įdit the “bind-address” directive in /etc/mysql//mysqld.cnf: bind-address = 127.0.0.1 ( The default. To ensure that the database server launches after a reboot, run the following Informs you that the service is already running: sudo systemctl start mysql If the service is already started, a message Run the following command to allow remote access to the mysql server: sudo ufw enableĪfter the installation is complete, you can start the database service by You don’t need to do this if the application that uses MySQL If you have iptables enabled and want to connect to the MySQL database fromĪnother machine, you must open a port in your server’s firewall (the default To the root user and setting the root password. This utility prompts you to define the mysql root passwordĪnd other security-related options, including removing remote access Installation completes, enter the following command: sudo mysql_secure_installation utility If the secure installation utility does not launch automatically after the The installer installs MySQL and all dependencies. Install the MySQL server by using the Ubuntu operating system package manager: sudo apt-get update

You might need to install other packages to letĪpplications use MySQL, like extensions for PHP. This article describes a basic installation of a MySQL database server on It isĪ good choice if you know that you need a database but don’t know much about MySQL is an open-source relational database that is free and widely used.

Debian mysql client