On XAMPP the defaults work: user root with no password. On cPanel hosting, first create an empty database under MySQL Databases and add your database user to it with All Privileges. Use the same user as your old app so it can read the old data too.
root