Hi, The problem here is that you need to specify a user for this database, try doing this on your server
%mysql -u root -p Enter password: ******* Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 3.22.32 Type 'help' for help. mysql> GRANT select, insert, update, create, alter, delete, drop ON yourdatabase.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'; mysql> Flush privileges; hth Norman -----Original Message----- From: Jurj Emil [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 9:07 AM To: [EMAIL PROTECTED] Subject: Question Hi there... I'm a very beginner in using mysql.... and i have a problem... So i have a database in mySql, I connected myself to it through java, and if I use as the host the "localhost" then everything goes well. In the moment I try to connect myself remotely, i encounter problems. So on the same computer, if in the url i don't write "jdbc:mysql://localhost/mydatabase", but i write "jdbc:mysql://192.168.0.5/mydatabase" , so I use an ip adress, or instead of the ip adress I write the name of the machine on whihc the Mysql is (eg: xenon), then I receive an error like: - access denied for user "@xenon" do database mydatabase So I thought that I have to add users to the mysql, with privileges...but until now i hadn't succeded to make my application go.. So please help me somebody, who encountered this problem and has the solution... many thankx.... xenon (emil jurj) _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
