<?php
$host = '127.0.0.1';
$database = 'db';
$user = 'db';
$password = 'pass';
$connect = mysqli_connect($host, $user, $password, $database);
$result=mysqli_query($connect, 'SELECT * FROM `authme`');
@mysqli_query('set character_set_results="utf8"');
$akkaunts = array();
if ($result) {
    while ($row = mysqli_fetch_assoc($result)) {
        $akkaunts[] = $row;
    }
}
?>
<?php foreach($akkaunts as $akk):?>
<?= $akk['realname'] ?>:<?= $akk['password'] ?><br>
<?php endforeach; ?>