API Credentials for MySQL

Guide to obtaining tokens, keys, and connections.

To connect MySQL to Botize you need the connection details of your MySQL server. The information varies depending on where your database is hosted (your own server, a managed service like AWS RDS, Google Cloud SQL, or a shared hosting panel like cPanel). Below is what each field means and where to typically find it.

Host

  1. 1

    The Host is the address (domain or IP) where your MySQL server is reachable. For a managed database it is the endpoint provided by the cloud console (for example, "mydb.xxxxxx.us-east-1.rds.amazonaws.com" on AWS RDS).

  2. 2

    On a hosting panel like cPanel, the host is often "localhost" if you connect from inside the same hosting, or the public IP / hostname of your server when connecting from the outside.

  3. 3

    Important: Botize connects to your database from the public internet. Make sure your MySQL server allows remote connections and that any firewall (or security group) permits Botize's IP address: 13.113.179.242.

  4. 4

    Paste the host into the "Host" field in the Botize connection form.

Port

  1. 1

    The default MySQL port is 3306. If your provider uses a different port, you will see it in their console (for example, AWS RDS shows the port next to the endpoint).

  2. 2

    Paste the port number into the "Port" field in the Botize connection form.

User and Password

  1. 1

    Use a dedicated MySQL user for Botize, not your root user. This way you can grant only the permissions Botize needs and revoke them at any time.

  2. 2

    If you do not have one yet, create a user with a command similar to: CREATE USER 'botize'@'%' IDENTIFIED BY 'a-strong-password'; GRANT SELECT, INSERT, UPDATE, DELETE ON your_database.* TO 'botize'@'%'; FLUSH PRIVILEGES;

  3. 3

    On a hosting panel, look for "MySQL Databases" and create a new user there, then assign it to the database.

  4. 4

    Paste the username into the "User" field and the password into the "Password" field in the Botize connection form.

Database name

  1. 1

    This is the name of the database (schema) you want Botize to work with — not the table.

  2. 2

    If you are not sure, list your databases with: SHOW DATABASES; in any MySQL client. Pick the one that contains the tables Botize will read from or write to.

  3. 3

    Paste the database name into the "Database name" field in the Botize connection form.