Asaph
2010-11-04 11:24:09
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;
I am getting "ERROR 1146 (42S02): Table 'performance_schema.session_variables' doesn't exist"