Menu
I created a different user, when I try to log into mysql it will not let me. I think I am missing a step. I am using windows 7. When I log in it automatically asks me for a password. If I enter the root password I can use mysql. If I enter the password I have created for the user, I get an error I cannot read and the program exits. Do I need to first login as root then somehow log in as new user. I am very confused. The code I used to create the new user is here:
Trouble logging into mysql as non root
981
If you want to login as a different user on MySQL, you need to use “mysql -u -p command”. The syntax is as follows to login as a different user.
Within the connection tab, do one of the following: Click Users and Privileges from the Management list within the Navigator area. Click Server and then Users and Privileges from the menu.
Try this:
>> mysql -u USERNAME -p
Press enter, and you'll be prompted for the password for USERNAME.
143
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
