For Wordpress, you can create a regular or smart group and use CiviCRM Directory to display those records in a directory.
It's basic alpha stage plugin so it depends on how much functionality you need. It will display all the core fields correctly. For custom fields it has an issue with not being able to retrieve them all from Civi in the edit screen.
This should be possible out of the box. CiviCRM has mapping capabilities documented here https://docs.civicrm.org/user/en/latest/initial-set-up/mapping/
There is an extension using open source v google mapping if you want: https://github.com/eileenmcnaughton/org.wikimedia.geocoder
Once you have your mapping working, then you should be able to do a Search ...
Thanks for your fast reply.
in the mheanwhile i checked again the DB informations, checked again the wp-config and copy all infos from there.
Result the same.
in the meanwhile i receive also a answer from the hoster.
They said at my hosting package i didnt have the rights for the DB. They suggest me of course to rent a virtual server ...or to download the ...
Couple of observations:
You may need to double-check that you can reach your MySQL database, since CiviCRM apparently can't (it's confusing since it reports that it can't connect, yet various operations can be done)
Your MySQL user needs to be able to create triggers. You probably need to contact your host to request this capability.
In step 5_15_alpha1 the field cacheKey must be renamed in cachekey. Is that done.
Try to update the fieldname if it is cacheKey.
CREATE INDEX index_all ON civicrm_prevnext_cache (cachekey, entity_id1, entity_id2, entity_table, is_selected)
If the table is empty, try dropping and recreating it, i.e.
SHOW CREATE TABLE civicrm_prevnext_cache;
Then copy the output to the clipboard.
Then DROP TABLE civicrm_prevnext_cache;
Then paste from the clipboard.