(Debian Linux 2.2)
trying (logged in as the owner of the database):
mysql guestbook.sql (database is palced in my home directory)
I get:
access denied for user: '@localhost' to database 'guestbook.sql'
What is going wrong?
--
I'm able to connect to connect to the database but unable to select
elements.
Josep
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
I'm new to mysql, but going on ...
I've set up user jupshoes to the data base phpbook with the GRANT command:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON phpbook.*
TO jupshoes@localhost
IDENTIFIED BY 'jupshoes';
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DRO
- Original Message -
From: "Kevin Donnelly" <[EMAIL PROTECTED]>
To: "josep" <[EMAIL PROTECTED]>
Sent: Tuesday, December 11, 2001 11:27 AM
Subject: Re: PHP+MYSQL: unable to select database
> Hi Josep
>
> > It is a php guestbook
ith tables, etc.
Sorry my newbie errors!
Thank's to everybody in the mailing lists arround the net!
Bye.
Josep.
My problem was:
> >I'm new to mysql, but going on ...
> >
> >I've set up user jupshoes to the data base phpbook with the GRANT
command:
>
I get:
unable to select database
when I visit my guestbook.php
The user trying it is set in the mysql.user (without any perms) and in the
mysql.db (with all perms).
Do I have to set all perms to this user in the mysql.user table?
Josep
I type (as normal user called jupshoes) the following:
mysql -u jupshoes -p guestbook.sql
and I don't connect to the server but I'm sent back to the shell after
printing the help lines.
Why?
Josep
-
Before posti
I can't select a database from a php script.
I've set privileges in both the user and the data base tables
and I've done FLUSH PRIVILEGES;
WHY?
JOSEP.
-
Before posting, please check:
http://www.mysql.com/ma
