Setting up MySQL / Maria DB is quite easy as PHsPeed comes out of the box with a pre-installation. However, if you don't want to use this you still have to set up the connection.

User id, password and database needs to be set to your situation. If your database is external, then you must set the server host and port to the external instance. Before selecting the database, use the test/show databases to verify the connection. When the connection is set up well then you can select the database from the dropdown box.

PDO String

mysql:host={%host%};dbname={%dbname%};port={%port%};charset=utf8

The charset can also be selected bysetting the char set drop down. UTF8 is PHsPeeds default.