Mysql code question (establishing username)

Hello all! Very simple question from a beginner. :slight_smile: I’d like to set up my dev. server to match my wordpress environment on-line. The instructions in chapter 2 (Database Driven Website) on creating a database are clear (and I set one up). But I don’t see anywhere where I can establish a username within mysql.

On my host server, when establishing a database, I can simply type in this hostname in a box.

This is requested in the wp-config.php file: /** MySQL database username */
define(‘DB_USER’, ‘my_hostname’);

So what do I type after this prompt?

mysql>

  1. We learned how to set up a password for our mysql, does this also govern the individual databases, or would I need to establish usernames and passwords for individual databases to mirror the environment on my server?

Thanks in advance!