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

Question

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?

Answer 1

Hello @kartik,

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;

Hope it helps!!

Thank you!