This article provides a tutorial to set up a first database and create a new user on a new macOS XAMPP installation.
If you didn’t set up your XAMPP host yet, you can follow previous tutorial to edit XAMPP Virtual Hosts.
1. Meet phpmyadmin
http://localhost/phpmyadmin in your favorite browser.
Go to User Accounts tab.
Create a new user with all-privileges and grant him access to
% hosts and
localhost. Don’t create associated database. It’s mostly useless.
2. Create your database
Create a database with a
utf8-general-cli encoding format.
Modify config.inc.php file
Change user and add your password.
AllowNonPassword to false.
compress to true.
Restart Apache Servers
Back to phpmyadmin
Remove all other users privileges.