Mysql who is logged in

Viewed 58k times. How do I see which user I am logged in as? Is there a way to change which user I logged in as with out logging out? Improve this question. Add a comment. Active Oldest Votes. Improve this answer. I found this user function select user ; Will show you which user is logged in.

Does that link still work for you? It does work, it has an other interesting function as well select database ; will show you your currently selected database. That's really annoying, I wonder why it doesn't work for me. Cloud Computing.

Data Science. Angular 7. Machine Learning. Data Structures. Operating System. Computer Network. Compiler Design. Computer Organization. Discrete Mathematics. Ethical Hacking. By default, contents of audit log files produced by the audit log plugin are not encrypted and may contain sensitive information, such as the text of SQL statements.

For security reasons, audit log files should be written to a directory accessible only to the MySQL server and to users with a legitimate reason to view the log. See Section 6. Statements received by the server may be rewritten if a query rewrite plugin is installed see Query Rewrite Plugins. In this case, the --log-raw option affects statement logging as follows:.

Without --log-raw , the server logs the statement returned by the query rewrite plugin. This may differ from the statement as received. With --log-raw , the server logs the original statement as received. An implication of password rewriting is that statements that cannot be parsed due, for example, to syntax errors are not written to the general query log because they cannot be known to be password free. Instead of just listing users, you can modify search results and find user-specific information.

A detailed and customizable overview enables you to make an informed decision regarding the security of your MySQL server. Introduction The primary function of a database is to store information in a structured way to allow easy access to that information. Was this article helpful?

Vladimir Kaplarevic. He has more than 7 years of experience in implementing e-commerce and online payment solutions with various global IT services providers.

His articles aim to instill a passion for innovative technologies in others by providing practical advice and using an engaging writing style. Next you should read. MySQL Security.