Connect to MySQL or MariaDB#
MySQL is one of the most popular open-source databases in the world, used by some of the top companies everywhere.
To create a database connection to MySQL or MariaDB,
- Log in DbFace with the Administrator account.
- Find the "Connections" section, and tap "Add new connection" button
- Select "MySQL or MariaDb" in the Database Type dropdown list.
- Database Type:
The database driver that use to connect your database, here we choose "MySQL or MariaDB". DbFace will use "mysqli" driver to connect to MySQL or MariaDB databases.
The name to identify this connection, used only in DbFace.
Your database host domain/IP. If you are not using the default port, should input host:port in the "Host" field.
The database username.
The database password.
- Database Name:
The database that you want to connect. Tap the "Pick" button to populate all database names that have permissions.
Ensure that all information is correct, click "Submit" button, DbFace will use the provided information to try to connect the database and create the connection if successfully.
Congratulations! You have successfully built your first database connection.
We recommend you create a sperated username/password for dbface to connect to your database, for MySQL:
create user 'thenewusername'@'188.8.131.52' identified by 'thenewuserpassword';
grant all privileges on thedatabase.* to 'thenewusername'@'184.108.40.206'
DbFace IP is 220.127.116.11, please update your server's firewall to allow DbFace IP to connect to your database server. If you've got any issues, please contact us to get free support or post a new ticket at our ticket system.
If you just want to create query applications which only access the databases in DbFace, please create readonly database user for the databases.