How you can create MySQL database in phpMyAdmin for WordPress?
In my previous posts, I’ve shown you how to setup local web server on USB flash drive with XAMPP and Server2Go. Both come with phpMyAdmin which you can use to create and manage databases.
For XAMPP, once you’ve started xampp-control.exe and both Apache and MySQL modules, you can access phpMyAdmin with any browser at https://127.0.0.1/phpmyadmin/ – no username/password required for accessing phpMyAdmin in XAMPP.
At Databases tab, create a new database (for purpose of installing WordPress later) ie. wpdb with utf8_general_ci collation.
You’ll need a database user (with password) including All Privileges too.
Now, you have a database with :
Database name : wpdb
Database user : wpdb
Database password : (set by you) ie. wpdbpass
You are all set to install WordPress.