Comment
Author: Admin | 2025-04-28
To use root without password. answered Jun 8, 2010 at 5:54 BozhoBozho597k147 gold badges1.1k silver badges1.2k bronze badges 4 Usemysql -u root -pIt will ask for password, insert password and enter. answered May 16, 2019 at 11:10 2 1) You can set root password by invoking MySQL console. It is located inC:\wamp\bin\mysql\mysql5.1.53\bin by default. Get to the directory and type MySQL. then set the password as follows.. > SET PASSWORD FOR root@localhost = PASSWORD('new-password');2) You can configure wamp's phpmyadmin application for root user by editing C:\wamp\apps\phpmyadmin3.3.9\config.inc.php Note :- if you are using xampp then , file will be located at C:\xampp\phpMyadmin\config.inc.phpIt looks like this: $cfg['Servers'][$i]['verbose'] = 'localhost'; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = ''; $cfg['Servers'][$i]['socket'] = ''; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'YOURPASSWORD'; $cfg['Servers'][$i]['AllowNoPassword'] = false;The error "Access denied for user 'root@localhost' (using password:NO)"will be resolved when you set $cfg['Servers'][$i]['AllowNoPassword'] to falseIf you priviously changed the password for 'root@localhost', then you have to do 2 things to solve the error "Access denided for user 'root@localhost'":if ['password'] have a empty quotes like ' ' then put your password between quotes.change the (using password:NO) to (using password:YES)This will resolve the error.Note: phpmyadmin is a separate tool which comes with wamp. It just provide a interface to MySQL. if you change my sql root's password, then you should change the phpmyadmin configurations. Usually phpmyadmin is configured to root user. Andreas6,4752 gold badges39 silver badges47 bronze badges answered Dec 25, 2012 at 8:35 yellobirdyellobird2793 silver badges3
Add Comment