如何以其他用户身份登录MySQL? [英] How to log in into MySQL as a different user?
问题描述
有人可以帮我吗?我很想知道如何在MySql中更改用户.也就是说,除了默认用户root之外,我还创建了另一个用户,但是我想登录到我创建的用户帐户,而不是自动登录到root.反正我能做到吗?我已经尝试使用MySql Console,但它无法正常工作,也许我没有正确的语句来做到这一点.谢谢
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
推荐答案
在命令提示符下
mysql -h主机-u用户名-p
mysql -h host -u username -p
表格 mysql文档:
shell> mysql --user =用户名--password =您的密码db_name
shell> mysql --user=user_name --password=your_password db_name
然后键入一个SQL语句,以;",\ g或\ G结尾,然后按Enter.
Then type an SQL statement, end it with ";", \g, or \G and press Enter.
这篇关于如何以其他用户身份登录MySQL?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!