Cool!. That solved my problem; I don't understand why
doing a grant all didn't fix the permissions but here
is my ant output now:
[EMAIL PROTECTED] cvebrowser]$ ant test
Buildfile: build.xml
init:
build:
jar:
test:
[echo] Testing using the following classpath:
/usr/share/java/junit.jar:test:/usr/share/java/log4j.jar:build:/usr/share/mysql-connector-java-3.0.6-stable/mysql-connector-java-3.0.6-stable-bin.jar.
[echo] Creating test database test_cvebrowser and
tables
[sql] Executing commands
[sql] 4 of 4 SQL statements executed
successfully
[echo] Tests summary will go to test/TEST-*
[junit] Running
cvebrowser.test.RunAllDownloadTests
[junit] Tests run: 3, Failures: 0, Errors: 0, Time
elapsed: 2.019 sec
[echo] Drop test database test_cvebrowser and
tables
[sql] Executing commands
[sql] 5 of 5 SQL statements executed
successfully
Thanks a lot for your help :)
--- [EMAIL PROTECTED] wrote:
>
> mysql> use mysql;
> mysql> update user set grant_priv = 'Y' where user =
> 'root';
> mysql> flush privileges
>
> and reconnect to mysql server as root user and
> retry grant clause. You'll be happy!!! ^^
>
> > Greetings,
> >
> > I'm trying to create a database and then adding a
> > specialized user so it can work with it, but so
> far i
> > got no luck:
> >
> > [EMAIL PROTECTED] josevnz]$ mysql -u root -p -h
> > localhost.localdomain
> > Enter password:
> > Welcome to the MySQL monitor. Commands end with ;
> or
> > \g.
> > Your MySQL connection id is 11 to server version:
> > 4.0.12
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear
> the
> > buffer.
> >
> > mysql> use mysql;
> > Database changed
> > mysql> CREATE DATABASE test_cvebrowser;
> > Query OK, 1 row affected (0.00 sec)
> >
> > mysql> GRANT
> SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
> > ON test_cvebrowser.* TO
> > 'test_cvebrowser_user'@'localhost.localdomain'
> > IDENTIFIED BY 'cv3br0ws3r';
> > ERROR 1044: Access denied for user:
> '[EMAIL PROTECTED]'
> > to database 'test_cvebrowser'
> > mysql>
> >
> > Any ideas what's wrong? (must be something pretty
> > simple, but no cigar so far). I don't understand
> why
> > the error if i managed to connect the first time.
> >
> > I'm using:
> > - Redhat Linux 8.0
> > - MySQL 4.0.12 (fresh install)
> >
> > PD: I already checked the documentation at
> > 'http://www.mysql.com/doc/en/Database_use.html',
> but
> > no luck.
> >
> > Thanks in advance,
> >
> > JV.
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
>
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
