!
Josep
-
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
- 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 (called phpBook) with mysql downloaded from
www.netone.at
OK - I've
.
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:
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
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 password 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 posting
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/manual.php
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
(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?