How to show a user information in MySQL

select * from mysql.user where user='User'\G;