Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_jsp thread: Re: java.sql.SQLException: General error: Access denied for user: '@l...'


Message #1 by "johan kvarnström" <j.kvarnstrom@t...> on Tue, 30 Jul 2002 22:09:07
The solution is to add the user/password again, for the computer you're
connecting from. Assume that you're on a local network, and your IP is
192.168.0.10. Log into the mysql console as root and issue the command

GRANT ALL PRIVILEGES ON *.* TO erik@1... IDENTIFIED BY
'erik007';

This gives user 'erik' with password 'erik007' the right to connect from
192.168.0.10, access any database and perform any operation on them.

Johan Kvarnström.

  Return to Index