Oct 24, 2014 - Are you looking at this page because you cannot access the mysql server. Access denied for user: 'root@localhost' (Using password: NO). #1045 - Access denied for user 'root'@'localhost' (using password: NO) I looked on this site and tried the following with no luck. PhpMyAdmin tried to connect to the MySQL server, and the.
Dear Belal U are using mysql -u root -p when u are loging from mylove try this mysql -u -p or mysql -u mylove -p On Tue, May 27, 2008 at 2:54 PM, Muhammad Bilal via linuxadmin-l wrote: Good Day Experts! When i try to execute this command on my fedora core 3 machine and fedora core 7 root@mylove#mysql -u root -p.all the time i am receiving the following Error. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) would appreciate if you could please let me know A.S.A.P. Many Thanks. To setup root password for first time, use mysqladmin command at shell prompt as follows: $ mysqladmin -u root password NEWPASSWORD However if you want to change (or update) a root password, then you need to use following command: $ mysqladmin -u root -p oldpassword newpass Muhammad Bilal via linuxadmin-l wrote: W/O passwd same thing -Original Message- Good Day Experts! When i try to execute this command on my fedora core 3 machine and fedora core 7 root@mylove#mysql -u root -p.all the time i am receiving the following Error.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) would appreciate if you could please let me know A.S.A.P. Many Thanks. Hi, Seems like you are trying to login the first time on mysql. You have to create root password for the first time.
#mysqladmin -u root password Make sure you are on the right path. Regards Chandra www.discussanythinghere.com Muhammad Bilal via linuxadmin-l wrote: Good Day Experts! When i try to execute this command on my fedora core 3 machine and fedora core 7 root@mylove#mysql -u root -p.all the time i am receiving the following Error. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) would appreciate if you could please let me know A.S.A.P. Many Thanks. Hi, I found the following solution from internet! First, you will need to make sure whether the default user is 'admin' or 'root' or whatever.
You will then need to reset the password. Start the mysql server instance or daemon with the -skip-grant-tables option. (security setting) You can do it by adding the 'skip-grant-tables' in the server section of /etc/my.cnf then restart mysql service by #service mysql restart Then Execute these statements. # mysql -u root mysql mysql SELECT Host, User FROM mysql.user; +-+-+ Host User +-+-+ localhost admin -+-+ 1 row in set (0.00 sec) mysql UPDATE user SET Password=PASSWORD('yournewpassword') where USER='Theuser@localhost'; mysql FLUSH PRIVILEGES; mysql quit bye After that, restart the instance/daemon without the -skip-grant-tables option. Modify the /etc/my.cnf AND # service mysql restart IF you follow the above) You should be able to connect with your new password. # mysql -u root -p OR # mysql -u admin -p Enter password: yournewpassword On Tue, May 27, 2008 at 1:54 PM, Muhammad Bilal via linuxadmin-l wrote: Good Day Experts!
When i try to execute this command on my fedora core 3 machine and fedora core 7 root@mylove#mysql -u root -p.all the time i am receiving the following Error. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) would appreciate if you could please let me know A.S.A.P. Many Thanks. Try without password: mysql -u root Regards: Romeo Ninov From: mmj ksa via linuxadmin-l mailto:[email protected] Sent: Friday, December 11, 2009 4:34 PM To: Romeo Ninov Subject: RE:linuxadmin-l ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Posted by mmj ksa on Dec 11 at 9:38 AM Mark this reply as helpfulMark as helpful Hi All, i have the same, i try all what writing here. I have Fedora-11 with LAMP server Thanks for all. If you need to reset the root password - you can stop mysql and restart with the -skip-grant-tables option - this will basically turn off the password checking.
Hi All Some times you may do not set the mysql password for the user root( by default it will take host as localhost) please try any one of the command and if you got the mysql access we can set the mysql password. Hi, If you could not solve problem with: 'mysql -u root ' First, you will need to make sure whether the default user is 'admin' or 'root' or whatever. You will then need to reset the password. Start the mysql server instance or daemon with the -skip-grant-tables option. (security setting) You can do it by adding the 'skip-grant-tables' in the server section of /etc/my.cnf then restart mysql service by #service mysql restart Then Execute these statements. # mysql -u root mysql mysql SELECT Host, User FROM mysql.user; +-+-+ Host User +-+-+ localhost admin -+-+ 1 row in set (0.00 sec) mysql UPDATE user SET Password=PASSWORD('yournewpassword') where USER='Theuser@localhost'; mysql FLUSH PRIVILEGES; mysql quit bye After that, restart the instance/daemon without the -skip-grant-tables option.
Modify the /etc/my.cnf AND # service mysql restart IF you follow the above) You should be able to connect with your new password. # mysql -u root -p OR # mysql -u admin -p Enter password: yournewpassword Hope this helps. On Fri, Dec 11, 2009 at 6:04 PM, mmj ksa via linuxadmin-l wrote: Posted by mmj ksa on Dec 11 at 9:38 AM Hi Alli have the same, i try all what writing here. i have Fedora-11 with LAMP server Thanks for all. Hi, you can change/reset password by following command mysql -u root -p -h localhost On Tue, Apr 6, 2010 at 3:12 PM, OneNetwork-Net via linuxadmin-l wrote: Posted by OneNetwork-Net on Apr 6 at 6:45 AM seem like people know the answer but dont know how to answer it ex. 'but rather the loopback address. Specify the host with -host 7.0.0.1 and try again.'
' how do we know what/when/how/where? -Original Message- From: Muhammad Bilal Sent: Tuesday, May 27, 2008 5:35 AM Subject: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Good Day Experts! When i try to execute this command on my fedora core 3 machine and fedora core 7 root@mylove#mysql -u root -p.all the time i am receiving the following Error. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) would appreciate if you could please let me know A.S.A.P.
Many Thanks. No, this will only (try to) login in to the database.
The same as Ulrich Metzger, after updgrading my machine to Ubuntu 16.04 and Mysql-server-5.7, I couldn't log in with root because of plugin column changed in mysql database. Both sudo dpkg-reconfigure mysql-server-5.7 command and removing, purging and cleaning did not solve my problem. I had to stop mysql service # sudo service mysql stop Start mysql daemon with no -no-grant-tables option # sudo mysqlsafe -no-grant-tables & Then in another terminal, enter mysql (which do not have anymore authenfication) with command mysql, and update password and plugin columns via a sql UPDATE UPDATE mysql.user SET authenticationstring=PASSWORD('), plugin='mysqlnativepassword' WHERE User='root' AND Host='localhost'; Finally kill mysqlsafe command, restart mysql service and connect to mysql normaly # sudo service mysql start # mysql.