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 Quote 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 Quote 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 Quote 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? Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.