FUDforum: FUDforum Installation Issues

Home » FUDforum » FUDforum Installation Issues » Install help

Show: Today's Messages :: Polls :: Message Navigator

Install help [message #29433]

Tue, 20 December 2005 21:31

Cliff

Messages: 3
Registered: December 2005

Karma: 0

Junior Member

I'm getting the following while running the install script:

FATAL ERROR: your MySQL account does not have permissions to run LOCK queries on existing MySQL tables
Enable this functionality and restart the script.

I used phpMyAdmin to create the database and user account, and granted all priviledges to the user. I don't see anything in the phpMyAdmin menus that deals with this.

Suggestions?

Thanks in advance,

Cliff

[Updated on: Tue, 20 December 2005 21:39]

Report message to a moderator

Re: Install help [message #29439 is a reply to message #29433]

Wed, 21 December 2005 05:06

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

In MySQL there is a LOCK permission you can grant or revoke from the user. You need to make sure that this setting is enabled for the user/database you are using with the forum.

FUDforum Core Developer

Report message to a moderator

Re: Install help [message #29456 is a reply to message #29439]

Wed, 21 December 2005 18:32

Cliff

Messages: 3
Registered: December 2005

Karma: 0

Junior Member

Thank you.

I ran the MySQL update permissions script and that enabled this additional permissions choice in phpMyAdmin.

That did the trick and the forums are up and running.

Much appreciated!

Report message to a moderator

Re: Install help [message #29840 is a reply to message #29456]

Wed, 18 January 2006 17:37

BayouBill

Messages: 3
Registered: January 2006

Karma: 0

Junior Member

I am an experienced developer, but a newbie to FUDforum, MySQL, and phpMyAdmin. I'm trying a first-time install on a site hosted by GoDaddy using MySQL. I'm getting the same error. Could you provide details of how to grant the necessary privilege in MySQL using phpMyAdmin? What is the correct "GRANT" syntax once in phpMyAdmin, and/or where is the "script" you refer to? Thanks.

Report message to a moderator

Re: Install help [message #29846 is a reply to message #29840]

Thu, 19 January 2006 03:14

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Here are the docs
http://dev.mysql.com/doc/refman/5.0/en/grant.html

FUDforum Core Developer

Report message to a moderator

Re: Install help [message #31085 is a reply to message #29846]

Thu, 30 March 2006 22:36

DanielMD

Messages: 5
Registered: March 2006

Karma: 0

Junior Member

Specially since i am using a Godaddy host and don't have full control of the system.

What do i do if they don't allow me to change this? Can i change the code in FUDforum or is it a very intensive feature (used many times if not used would break the forum)?

[Updated on: Thu, 30 March 2006 23:22]

Report message to a moderator

Re: Install help [message #31099 is a reply to message #31085]

Sat, 01 April 2006 18:03

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

The locking of table is a required function, used by the forum to ensure data consistency. You need to ask your server admin or database admin to grant your database account the LOCK privilege.

FUDforum Core Developer

Report message to a moderator

Re: Install help [message #31106 is a reply to message #31099]

Sat, 01 April 2006 18:57

DanielMD

Messages: 5
Registered: March 2006

Karma: 0

Junior Member

Godaddy does not do that. They claim security reasons

WARNING Do not use godaddy for hosting.

[Updated on: Sat, 01 April 2006 18:57]

Report message to a moderator

Previous Topic:	Godaddy MySQL problem
Next Topic:	Mysql charset changer ( admin control panel)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 22:55:55 GMT 2024

Total time taken to generate the page: 0.02259 seconds