Could anyone help me please? I wolud like to know how to change user in MySql. That is, I created another user besides the default user root but i want to be logged in to the user account i created instead of being logged in to root automatically. Is there anyway I can do that? I've tried using MySql Console but its not working, maybe I don't have the right statements to do that. thanks
解决方案
In command prompt
mysql -h host -u username -p
shell> mysql --user=user_name --password=your_password db_name
Then type an SQL statement, end it with “;”, \g, or \G and press Enter.