How to set up the mysql server on the bot?

[babuphanish]

Hello, I bought a mysql server but I'm a bit lost. How can I connect it to the bot?

[e-enes]

Hello,

You can put the information of your mysql database on the .env file as given in the example.

# Discord Bot Info
TOKEN=

# MySQL Server Info
HOST= # The IP of your MySQL server
PORT= # The port of your MySQL server, if you do not have a port, leave blank.
USER= # The username to connect to your MySQL database
PASSWORD= # Your username password
DATABASE= # Finally the name of the database