From: Christian Mack
Date: March 11 1999 1:10pm
Subject: Re: Access denied
List-Archive: http://lists.mysql.com/mysql/15
Message-Id: <36E7C0B5.91CEC09C@compal.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Asterix wrote:
> 
> Hi,
> I am writing a program that use JDBC to access mysql database.
> However, when I run the program I have this following error :
> 
> General error: Access denied for user: '@tools1' to database 'HONGKONG'
> java.sql.SQLException: General error: Access denied for user: '@tools1' to
> database 'HONGKONG'
>         at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java)
>         at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java)
>         at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
>         at org.gjt.mm.mysql.Statement.executeQuery(Statement.java)
>         at testc.StockSlave.readRecord(StockSlave.java:157)
>         at testc.StockSlave.doJob(StockSlave.java:105)
>         at testc.StockSlave$1.onArrival(StockSlave.java:60)
> 
> I think I have a privilege problem.
> I did flush the privilege in mysql:
> 
> % mysql -uroot mysql
> mysql> flush privileges;
> % mysqladmin -uroot reload
> 
> I also tried:
> 
> % mysql -uroot mysql
> mysql> insert into user values ('tools1','%', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
> 'Y', 'Y', 'Y', 'Y');
> ERROR 1136: Column count doesn't match value count at row 1
> 
> Does anybody can help me solve this problem?
> How can I allow any user from specific host to access mysql w/o submitting
> their username and password?
> 
> Thank you very much.
> Regards,
> 
> AJI

Hi AJI

First: I think you didn't give an user name to the driver.
You should provide your Java source code with the getConnection(...) thing.
With this we can help you.

Second: Don't give '%' for column mysql.user.User use '' (= empty string) instead.

Third: The error message indicates, that you are not using a current 3.22.xx mysql database. Please give us the version you use.

Tschau
Christian