By wernst on

All,

So I am installing Drupal on host provider this time, and they use Plesk to set up MySQL databases and users and their passwords. I used Plesk to make a "drupal" database, and I made a mysql user "drupaluser" with a password. I populated the drupal database with the contents of the mysql file with the drupal tarball with phpMyAdmin, and to make a long story short, everything is just fine and working well.

BUT, during the install process, I was unable to:

GRANT ALL PRIVILEGES ON drupal.*
TO nobody@localhost IDENTIFIED BY 'password';

(assume all usernames and passwords are correct) as I have when I am using my own servers. The error message was something to do with a lack of user permission. I can retry this to get the exact error message if necessary.

Now here's the question: since everything is working great with drupal, should I worry about not being able to execute the above command? If this really is something I should worry about, should I try some alternative commands?

-Warr

Comments

Steven’s picture

Steven commented

Most likely you already have the correct permissions set thanks to Plesk. If you run into an 'Access denied to database' error, you'll need to get the permissions sorted with the administrators.

rdash’s picture

rdash commented

I know this thread is old, but instead of starting a new one, I thought I'd comment here.

I had the same problem. I FTP'd my Drupal installation files using Filezilla, then used my host's pre-installed myPHPadmin to create a database of "drupal00" (I changed the appropriate lines in the settings.php file ). I tried to but could not grant privileges, as indicated in the manual.

Being stubborn, I went along with the install anyway. I could create the first (admin) user, but I got an error. Then I tried creating content and I ended up with errors galore, including the following:

user error: Access denied for user: 'drupal00@%' to database 'drupal00'

The way that my mySQL accounts are set up (GoDaddy.com), my username and the database name are the same.

I checked the settings.php, and nothing seems amiss. I'm able to view admin pages, but usually get database errors. I don't have command line access to the database, else I'd have no trouble running the Grant Privileges command.

I feel like I'm overlooking something, but staying up until 4:30 am last night trying to find it didn't help :<

Any suggestions anyone?

rehash’s picture

rehash commented

I've had the same problem and fixed it with phpmyadmin

rdash’s picture

rdash commented

Do you remember how? I looked for "privileges" options in the interface, but didn't see any. I haven't used phpmyadmin much, so I'll have to explore the docs a bit.

thanks for the tip.

swaroop.S’s picture

swaroop.S commented

First go to root account in mysql.

After creating the tables through .mysql file.Run the grant command through the root account again.This may solve your problem...

Swaroop.S
Library Asst. (Digital Library/e-Library)
SDM-IMD
Karnataka
Mysore

heine’s picture

heine commented

Most people do not have 'root' access to MySQL databases at their hosting provider...

--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

rdash’s picture

rdash commented

Yeah, I'm totally disappointed with the way Drupal handles databases. My hosting provider is GoDaddy.com on all but one of my domains. However, I run WordPress 1.5.2 on one of my GoDaddy-hosted domains and have no database access problems (except slowness). This must be a GoDaddy-database related problem, though, as other members here have said their installation works on their provider.

I'm so frustrated, I'm one inch from giving up on Drupal. I was going to install it on 6-10 of sites, including those of friends and family. I'd hate to have to go back to WordPress, especially after I've written about 4 posts on various blogs praising how great Drupal is.

Anyone else have this problem? I'd know exactly how to solve it if I had root access and shell access. But I don't.

sepeck’s picture

sepeck commented

How Drupal handles databases is not necessarily the issue. How the hosting providers you use allow/set permissions is. Drupal is great. It's a robust CMS with a lot of features. Those features leverage functionality in SQL databases.

Could Drupal use a different method? maybe, but such a different method will not happen without a lot more discussion and a scalable workable long term solution that gets someone to work on it and shepard it throught the full development cycle.

So, this is not a Drupal problem, it is a hosting provider problem.
Perhaps GoDaddy is not such a good hosting provider for your needs? I imagine you could ask GoDaddy technical support to make sure that your MySQL account has LOCK Tables access.

-sp
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide

rdash’s picture

rdash commented

SP, I agree. I love Drupal in theory. But in practice, it's been an utter pain in the ass on my godaddy-hosted sites. My point being, it shouldn't be like this. While I am a veteran programmer, I don't know if I want to go mucking about with the code just yet.

Thanks very much for the tip. I'll email GoDaddy support. Do you think that this is the only problem then?

thanks,

raj

Amarnath-1’s picture

Amarnath-1 commented

I believe that the shared hosting with godaddy doesn't allow neither drupal nor civicspace.

if anyone is hosting drupal/civicspace site with godaddy please help me out.

The errors are,

user error: Access denied for user: 'saiputla@%' to database 'saiputla'

query: LOCK TABLES sequences WRITE in /home/content/b/x/i/bxivu/html/includes/database.mysql.inc on line 66.

warning: Cannot modify header information - headers already sent by (output started at /home/content/b/x/i/bxivu/html/includes/common.inc:384) in /home/content/b/x/i/bxivu/html/includes/common.inc on line 192.

thanks in advance

gello101’s picture

gello101 commented

I'm receiving the exact same errors with Godaddy.com. I called and tech support confirmed that I have the Lock tables permissions.

user error: Access denied for user: 'USER@%' to database 'DATABASE'
query: LOCK TABLES sequences WRITE in /[snip]/html/drupal/includes/database.mysql.inc on line 66.

warning: Cannot modify header information - headers already sent by (output started at /[snip]/html/drupal/includes/common.inc:384) in /[snip]/html/drupal/includes/common.inc on line 192.

Anyone able to work through this issue?

heine’s picture

heine commented

No, you really need the lock tables permission.
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.