We will give it rights on the base “example” and no other. Here we will create a new user “user” with the password “password”. Servers are too often the victim of attack such as brute force.
However, we want to warn you, creating a remote connection increases the risk of attacks, so use a complicated username and password and avoid giving a user rights to all your tables (it’s better to use a dedicated user by base). Creating a dedicated MySQL userįirst we will have to connect to the Raspberry Pi and then connect to MySQL in order to create a new user to manage a remote database. In addition, opening the connection remotely allows to connect to the MySQL service from another IP (if this one have the authorization) and thus to manage its database without passing by SSH or other services.įor this tutorial we consider that you already have a Raspberry Pi with MySQL server installed. This is especially what the hosts do, on shared servers. Indeed, you can choose to separate these two parts in order to lighten your server in terms of query.
The remote connection can be very useful if you have a server without an internal database.
#Connect to mysql database workbench on my computer how to
Today, we will be interested in MySQL, more precisely how to activate the remote connection to the database, it mean from another machine not connected to our Raspberry Pi. We apologize for any errors this may cause. Ⓘ This article may have been partially or fully translated using automatic tools.
0 kommentar(er)
