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
