Hi.. I'm using mySQL with Avantgo
For a while we kept getting an access denied error: access denied for user '@<servername>' to database '<dbname>' The avantgo support person told me how to go into the mysql database and we looked at the users table and saw that there was a password for 'root'. We had been using root with no password on an old server before we moved to this new one and it had always worked. Nevertheless he told me what it was and I entered it in the DSN information. Then the error changed to: access denied for user 'root@<servername>' (Using password:YES) which I understand from the mysql documentation means that we are entering the wrong password... so I kept looking on the documentation for more clues… The mysql_install_db script to set intitial privileges is always mentioned but I cannot find this script on my server anywhere.... I also tried setting the root password to what it should have been with. INSERT INTO user (Host,User,Password) VALUES('%','root',PASSWORD('<password>')); and the change seemed to go thru but now the error message we get is Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. Does anyone know what is going wrong? Any help would be greatly appreciated. Also, if anyone can tell me where to find the mysql_install_db script, that would be helpful as well. Thanks, Leslie __________________________________________________ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php