chrxr Posted June 28, 2011 Share Posted June 28, 2011 I installed MySQL 5.5.10 with EasyPHP and am trying to open MySQL from the command line. On launching mysql.exe with -u root, I get the message below: ERROR 1045 (28000): access denied for user 'root'@'localhost' (using password: yes) I have never used MySQL before, but I'm sure i never set a password for the root user. In phpMyAdmin there are 3 "Users" in the privileges tab for MySQL: User Host Password Root 127.0.0.1 No Root Local Host No rooty % Yes I set up "rooty" after I get the error above in my bumbling attempts to get into MySQL. Anyone get any ideas as to why I can't get into the MySQL command line? Many thanks in advance!! Quote Link to comment https://forums.phpfreaks.com/topic/240656-cant-launch-mysql-cmd-line-asking-for-password-but-none-set/ Share on other sites More sharing options...
requinix Posted June 28, 2011 Share Posted June 28, 2011 Don't give the -p argument? Just "mysql -u root" should be enough. Quote Link to comment https://forums.phpfreaks.com/topic/240656-cant-launch-mysql-cmd-line-asking-for-password-but-none-set/#findComment-1236083 Share on other sites More sharing options...
chrxr Posted June 28, 2011 Author Share Posted June 28, 2011 Astonishingly all I had to do was -uroot -p then press enter on the password entry. Astonishing how the mind (or at least my mind) can overcomplicate things. Thanks for you help though. Quote Link to comment https://forums.phpfreaks.com/topic/240656-cant-launch-mysql-cmd-line-asking-for-password-but-none-set/#findComment-1236097 Share on other sites More sharing options...
fenway Posted July 2, 2011 Share Posted July 2, 2011 You really should always have a password for root. Quote Link to comment https://forums.phpfreaks.com/topic/240656-cant-launch-mysql-cmd-line-asking-for-password-but-none-set/#findComment-1237724 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.