sunskycount.blogg.se - #1045 - access denied for user 'root'@'localhost' (using password no) in mac

#1045 ACCESS DENIED FOR USER 'ROOT'@'LOCALHOST' (USING PASSWORD NO) IN MAC HOW TO
#1045 ACCESS DENIED FOR USER 'ROOT'@'LOCALHOST' (USING PASSWORD NO) IN MAC INSTALL

Will be resolved when you set $cfg to false The error "Access denied for user (using password:NO)" Note :- if you are using xampp then, file will be located at C:\xampp\phpMyadmin\ > SET PASSWORD FOR = PASSWORD('new-password') Ģ) You can configure wamp's phpmyadmin application for root user by editing C:\wamp\apps\phpmyadmin3.3.9\ It is located inĬ:\wamp\bin\mysql\mysql5.1.53\bin by default. Now you can successfully login as root user with the password you set # mysql -u root -pYourNewPasswordġ) You can set root password by invoking MySQL console. *if you don`t want any password or rather an empty password mysql> grant all privileges on *.* to identified by '' with grant option Ĭonfirm the results: mysql> select host, user from user Įxit the shell and restart mysql in normal mode. Mysql> grant all privileges on *.* to identified by 'YourNewPassword' with grant option Let that be, and use new terminal for next steps.Įnter the mysql command prompt # mysql -u rootįix the permission setting of the root user mysql> use mysql # mysqld_safe -skip-grant-tables &Īt this moment, the terminal will seem to halt. This option is used to boot up and do not use the privilege system of MySQL. Start mysql without any privileges using the following option Stop the service/daemon of mysql running # service mysql stop follow the steps as follows: # mysql -u rootĮRROR 1045 (28000): Access denied for user (using password:NO) How do I solve this? I'm waiting to hear from you.įor this kind of error you just have to set new password to the root user as an admin. The command line shows the following errorĪccess denied for user (using password:**YES**)

Mysql -u root -p EnterPassword: 123 // 123 was the password

I start the MySQL service from Windows services.

The command ran with a warning about character set which I mentioned below Mysqld -defaults-file="C:\\program files\\mysql\\mysql server 5.1\\my.ini" -init-files=C:\\root.txt

Changed the location to c:\program files\mysql\bin.

I stopped the MySQL Service from Windows services.

Update: as Bozho suggested, I did the following: However, it asks for a password which I don't have.

#1045 ACCESS DENIED FOR USER 'ROOT'@'LOCALHOST' (USING PASSWORD NO) IN MAC HOW TO

What is the default password for root (if there is one) and how to change it?īut it shows me: Access denied for user (using password:NO) I never set a root password for MySQL and in the final step of installing WordPress, it asks for a MySQL server password.

#1045 ACCESS DENIED FOR USER 'ROOT'@'LOCALHOST' (USING PASSWORD NO) IN MAC INSTALL

I install everything with Web Platform Installer which is provided by Microsoft. I'm new to MySQL, I'm trying to run WordPress in my Windows desktop and it needs MySQL.