By yoavbinyamini on

Hi
Newbie here.
When I go to the phpMyadmin page, my username and password work (I'm in), but under "create new database" I have the "NO privileges".
I am using Drupal 5.1 and I instaled it localy with David Mercers book as a guide.
Everything seems to be working fine on the Drupal side of things.

Anyone know how to remedy this?
Let's say php is not something I am fluent with...

Thanks

Yoav

Comments

dshaw’s picture

dshaw commented

This issue has nothing to do with Drupal or PHP. It looks like you need to configure you MySQL database correctly. I would guess that the user you have logged in as does not have permission to create databases. You should have a look at the MySQL install instructions that come with Drupal. You need to issue a GRANT privileges on database for user command. The instructions will have the correct form.

gloscon’s picture

gloscon commented

If you are using cPanel, this should be simple

1) Create DB
2) Create User
3) Add user to database.

Check with your host first and they should be able to help you.

If all of the above does not work, please send me an email or call me on 604-630-4292 and I can help you.
--
Roshan Shah
http://www.gloscon.com

.carey’s picture

.carey commented

I encounter this same issue when I login to phpMyadmin. What I do is use the cpanel to create the database and the authorized user. Afterwards, I can login to phpMyadmin and make any changes to the database I choose. This may very well be the same in your case. Don't be alarmed. Just use cpanel's database feature instead.

yoavbinyamini’s picture

yoavbinyamini commented

Thanks for all the answers..
I probably should have added that I am using the "apache2triad" package, so I don't have a cPanel (as far as I know), and I am my host at the moment...working localy (as David Mercer advised)

I did try the command..but got a syntax error (do to my non existing sql skills). the command I used - worked for Drupal) was:
GRANT ALL PRIVILEGES ON database TO yoavbinyamini@localhost IDENTIFIED BY '12345678';

Where did I get it wrong??

dshaw’s picture

dshaw commented

Just a guess, but perhaps your database is not called "database".

The Drupal doco says to do the following:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
ON databasename.* TO 'username'@'localhost' IDENTIFIED BY 'password';

If ALL PRIVILEGES is valid syntax and equates to the above, then you need something like:

GRANT ALL PRIVILEGES ON dbname.* TO 'yoavbinyamini'@'localhost' IDENTIFIED BY '12345678';

That is, change "database" to "your dbname" and suffix .*. And possibly add the single quotes for user@host.

yoavbinyamini’s picture

yoavbinyamini commented

Thanks dshaw, your guess was correct.. I actually ran the
GRANT ALL PRIVILEGES ON drupal.* TO 'yoavbinyamini'@'localhost' IDENTIFIED BY '12345678';
During the setup (as David Mercer suggested), but the database IS called "drupal", and I thought it was for "Drupal 5.1
Anyway I ran 

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
ON drupal.* TO 'yoavbinyamini'@'localhost' IDENTIFIED BY '12345678';

as well, just to be on the safe side. Both ran with no errors.
I even ran flush privileges so it would take effect right away.

STILL -"NO PRIVILEGES" under the" Create new database".

It seems I could do everything else (other then what I really need).
BTW I have full administrative power inside Drupal.

Any other php hacks up you sleeve??
Thanks again (I know we newbies can be a pain..)

dshaw’s picture

dshaw commented

I can't think of what else to do. The SQL (not PHP) looks fine to me. Perhaps rebooting the MySQL server, but that's clutching at straws. Are you sure you modifying the same DB that Drupal is configured to point to? You don't have two DBs and you're modifying one and using the other (more straws).

Kipp Elliott Watson’s picture

Kipp Elliott Watson commented

If nothing else works, try:

Username: root
Password: password

Just think of it as the hacker's secret handshake. Ooops. Did I just reveal something I should have kept quiet about?

P.S. I feel your frustration. Three years is a long time to wait for an answer. At least this might help the next newbie along.

PGN’s picture

PGN commented

To Kipp Elliott Watson,

Better later than never!!! Thanks for the advice, it surely eased my pain:-)

Regards,
PGN