php_guest Posted February 19, 2009 Share Posted February 19, 2009 I have tried all the following sytax but still it gives me message it is wrong sytax: -$ mysqladmin -u root password mypassword -mysqladmin -u root password mypassword -mysql -u root mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mypassword'); Please what exactly should I wrote into phpmyadmin query field. Thanks Link to comment https://forums.phpfreaks.com/topic/145888-set-mysql-database-password-with-phpmyadmin/ Share on other sites More sharing options...
gunabalans Posted February 19, 2009 Share Posted February 19, 2009 hai, try this SET PASSWORD FOR 'gunabalans'@'%' = PASSWORD( '****' ) gunabalans - user name @% to any host Link to comment https://forums.phpfreaks.com/topic/145888-set-mysql-database-password-with-phpmyadmin/#findComment-765966 Share on other sites More sharing options...
php_guest Posted February 19, 2009 Author Share Posted February 19, 2009 now the error is: #1133 - Can't find any matching row in the user table Link to comment https://forums.phpfreaks.com/topic/145888-set-mysql-database-password-with-phpmyadmin/#findComment-765970 Share on other sites More sharing options...
fenway Posted February 23, 2009 Share Posted February 23, 2009 now the error is: #1133 - Can't find any matching row in the user table Did you actually substitute your user name in the example? Link to comment https://forums.phpfreaks.com/topic/145888-set-mysql-database-password-with-phpmyadmin/#findComment-769042 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.