Dear Madam, Sir,
I created a new user with :
./mysql -u root -p1234 mysql
grant select,insert,update,delete,create,drop on prodoc to prodoc@"%"
identified by '1234';
In my asp script that is opening the connection I use :
cnnString =
"DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://xxx.xxx.xxx.xx:3306/dbname
};uid=username;pwd=1234;"
The error :
Invalid authorization specification: Access denied for user: 'username@ns'
(Using password: YES)
Strange thing is that when I replace username with root, all works well... I
even creates an admin with full rights, both for localhost and @"%", but
still no good.
All hints are wellcome.
Kind regards,
Harry M. Aasterud
---------------------------------------------------------------------
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
