Search code examples
javamysqldatabasejdbcdatabase-connection

How do I find out my MySQL URL, host, port and username?

I need to find my MySQL username. When I open the MySQL command line client, it only asks me for my password. I don't remember my username. And for connectivity with JDBC, I need the URL, host and port number. Where do I find all of these?

Solution

  • If you're already logged into the command line client try this:

    mysql> select user();

    It will output something similar to this:

    +----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.41 sec)

    In my example above, I was logged in as root from localhost.

    To find port number and other interesting settings use this command:

    mysql> show variables;