Hello,
I'm trying to install drupal 5.2 in netsons host one free host with php and mysql. While I was configuring drupal with the db parameters, I received these following messages:
The following error must be resolved before you can continue the installation process:
We were unable to lock a test table on your MySQL database server. We tried locking a table with the command LOCK TABLES drupal_install_test WRITE and MySQL reported the following error: Access denied for user ' userid'@'%' to database 'dbname'.
How can I solve this kind of problem? In the worst case that I can't solve it, can you give me some indications about Free hosts with php and mysql where I can try to Install drupal?
Thanks in advance for all information Best regards, Sauro
Ask your host to allow your database user to have lock tables permissions. (The database itself will also need to allow those permissions.) Some hosts will not allow this -- I have no idea why -- but if they give you trouble, there are many other hosts out there -- a search of the forums will give you several leads.
Laura
• Laura Scott pingVision, LLC
1350 Pine Street, Suite 1 Boulder, CO 80302 303.415.2559 http://pingv.com
On Aug 21, 2007, at 5:04 PM, Sauro Cesaretti wrote:
Hello,
I'm trying to install drupal 5.2 in netsons host one free host with php and mysql. While I was configuring drupal with the db parameters, I received these following messages:
The following error must be resolved before you can continue the installation process:
We were unable to lock a test table on your MySQL database server. We tried locking a table with the command LOCK TABLES drupal_install_test WRITE and MySQL reported the following error: Access denied for user ' userid'@'%' to database 'dbname'.
How can I solve this kind of problem? In the worst case that I can't solve it, can you give me some indications about Free hosts with php and mysql where I can try to Install drupal?
Thanks in advance for all information Best regards, Sauro
-- [ Drupal support list | http://lists.drupal.org/ ]
Ok thank you I'll try to ask that. Can anyway anybody give me some advices about cheaps hosts Where I can install drupal easily? Thank you in advance and sorry that it's a bit off-topic. Best regards, Sauro
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Laura Scott Sent: mercoledì 22 agosto 2007 1.30 To: support@drupal.org Subject: Re: [support] Problems installing drupal
Ask your host to allow your database user to have lock tables permissions. (The database itself will also need to allow those permissions.) Some hosts will not allow this -- I have no idea why -- but if they give you trouble, there are many other hosts out there -- a search of the forums will give you several leads.
Laura
Laura Scott pingVision, LLC
1350 Pine Street, Suite 1 Boulder, CO 80302 303.415.2559 http://pingv.com
On Aug 21, 2007, at 5:04 PM, Sauro Cesaretti wrote:
Hello,
I'm trying to install drupal 5.2 in netsons host one free host with php and mysql. While I was configuring drupal with the db parameters, I received these following messages:
The following error must be resolved before you can continue the installation process:
We were unable to lock a test table on your MySQL database server. We tried locking a table with the command LOCK TABLES drupal_install_test WRITE and MySQL reported the following error: Access denied for user ' userid'@'%' to database 'dbname'.
How can I solve this kind of problem? In the worst case that I can't solve it, can you give me some indications about Free hosts with php and mysql where I can try to Install drupal?
Thanks in advance for all information Best regards, Sauro
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
lunarpages starts at $6.95/mo. and I have been developing a site on there for a couple weeks without a problem... they're feature set is great - up to 10 domains, unlimited subdomains, databases, 350GB storage, 3500GB bandwidth etc. for 6.95. I've been hosting with them for about 6 months and have had no problems whatsoever.
However - I would warn you about drupal on a free/cheap shared host if it's going to get any large amount of traffic. There has been a lot of talk on the forums about people getting shut down because drupal used to much processing power, the most famous being http://drupal.org/node/137898 (well i don't know how famous it is, but it comes up on the first page of almost everything I search for no matter how unrelated my search is). To be safe I called lunarpages yesterday and asked them about their policy - as others have said their hosting providers did, lunarpages would shut my sites (all of them, not just the one causing trouble) without notice if my sites go above 1% of the processing power of the machine. 1%. not much. I don't think I'll run into a problem because I'm only developing on that server. I still ended up in a screaming match with him - my contention being that whether it's a policy or not it's an unfair one if I am not provided with a tool to monitor my usage or given warning. Like not putting speedometers in cars but still issuing tickets if you speed. He basically said tough luck, it's the way we and everyone else does it in the industry and it's not going to change.
.s
Sauro Cesaretti wrote:
Ok thank you I'll try to ask that. Can anyway anybody give me some advices about cheaps hosts Where I can install drupal easily? Thank you in advance and sorry that it's a bit off-topic. Best regards, Sauro
I use Siteground. They will do the install for you and have it scripted (via fantastico). But just google drupal hosting services, and you should find more.
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Sauro Cesaretti Sent: Wednesday, August 22, 2007 5:02 AM To: support@drupal.org Subject: Re: [support] Problems installing drupal
Ok thank you I'll try to ask that. Can anyway anybody give me some advices about cheaps hosts Where I can install drupal easily? Thank you in advance and sorry that it's a bit off-topic. Best regards, Sauro
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Laura Scott Sent: mercoledì 22 agosto 2007 1.30 To: support@drupal.org Subject: Re: [support] Problems installing drupal
Ask your host to allow your database user to have lock tables permissions. (The database itself will also need to allow those permissions.) Some hosts will not allow this -- I have no idea why -- but if they give you trouble, there are many other hosts out there -- a search of the forums will give you several leads.
Laura
* Laura Scott pingVision, LLC
1350 Pine Street, Suite 1 Boulder, CO 80302 303.415.2559 http://pingv.com
On Aug 21, 2007, at 5:04 PM, Sauro Cesaretti wrote:
Hello,
I'm trying to install drupal 5.2 in netsons host one free host with php and mysql. While I was configuring drupal with the db parameters, I received these following messages:
The following error must be resolved before you can continue the installation process:
We were unable to lock a test table on your MySQL database server. We tried locking a table with the command LOCK TABLES drupal_install_test WRITE and MySQL reported the following error: Access denied for user ' userid'@'%' to database 'dbname'.
How can I solve this kind of problem? In the worst case that I can't solve it, can you give me some indications about Free hosts with php and mysql where I can try to Install drupal?
Thanks in advance for all information Best regards, Sauro
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-
Laura Scott -
Metzler, David -
sander-martijn -
Sauro Cesaretti