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!! 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. 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. 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. 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
Archived
This topic is now archived and is closed to further replies.