Hi Mark, Thanks for your response, my problem is that I've done that. It works on a windows machine running mysql, I've set my Linux machine up the same and it doesn't work.
The only difference is that I am running MSQL 3.23.51-nt on my windows machine and the latest rpm's on my Linux machine. I thought there may be some known issues with these rpm's - that's why I asked the question. Thanks anyway. Kevin -----Original Message----- From: Mark Matthews [mailto:mark@;mysql.com] Sent: 30 October 2002 12:30 To: Kevin Passey Cc: Mysql (E-mail) Subject: Re: Errors trying to connect to MYSQL using tomcat - do I need to ope n any ports on my firewall or is this done internally? Kevin Passey wrote: > Hi all > > I have downloaded the latest rpms and added records to HOST,DB,and USER > files in the mysql database. > > I am trying to access the database from a web page using a tomcat server > running on the same machine. > > I get the following message : Server configuration denies access to data > source. The solution is to create the correct GRANTs on your MySQL database. You need to add a grant for the username/password connecting from the host Tomcat is running on, e.g.: GRANT ALL PRIVILEGES ON db.* to 'user'@'host' IDENTIFIED BY 'password' Of course you should read the MySQL manual section on GRANTS to make sure you understand what you're doing, so that you don't create a security issue. Also, this problem is discussed in the 'README' for the JDBC driver :) -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA <___/ www.mysql.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
