FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » FUDforum Installation Issues » Upgrade-error: MySQL Error: #1044 (Access denied for user: ...
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Upgrade-error: MySQL Error: #1044 (Access denied for user: ... [message #16056] Tue, 13 January 2004 11:46 Go to next message
nino is currently offline  nino   Germany
Messages: 19
Registered: May 2003
Karma: 0
Junior Member
Hi,
I try to upgrade to v2.6.0 and I get an error after the Beginning SQL Upgrades:
--------------------
Checking if SQL permissions to perform the upgrade are avaliable
Disable the forum
Forum is now disabled
Beginning the file upgrade process
Begining to decompress the archive
Finished decompressing the archive
File Upgrade Complete
Any changed files were backed up to: "/home/www/web17/html/forum/errors/.backup/"

Beginning SQL Upgrades
MySQL Error: #1044 (Access denied for user: 'web17@localhost' to database 'usr_web17_1'): CREATE INDEX fud25_action_log_i_ul ON fud25_action_log (user_id,logtime)
-----------------------
what can I do?

Report message to a moderator

Re: Upgrade-error: MySQL Error: #1044 (Access denied for user: ... [message #16059 is a reply to message #16056] Tue, 13 January 2004 14:00 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Make sure your MySQL account has permissions to create & drop indexes.

FUDforum Core Developer

Report message to a moderator

Re: Upgrade-error: MySQL Error: #1044 (Access denied for user: ... [message #16065 is a reply to message #16059] Tue, 13 January 2004 14:54 Go to previous messageGo to next message
nino is currently offline  nino   Germany
Messages: 19
Registered: May 2003
Karma: 0
Junior Member

YES, I can create Index:
ALTER TABLE `test2` ADD PRIMARY KEY ( `field1` ( 6 ) )
(it works)

Report message to a moderator

Re: Upgrade-error: MySQL Error: #1044 (Access denied for user: ... [message #16066 is a reply to message #16065] Tue, 13 January 2004 14:58 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Try running CREATE INDEX fud25_action_log_i_ul ON fud25_action_log (user_id,logtime);

That query didn't work and it didn't work because as the error message said the user it was connecting as didn't have permissions to run it.

FUDforum Core Developer

Report message to a moderator

Re: Upgrade-error: MySQL Error: #1044 (Access denied for user: ... [message #16067 is a reply to message #16066] Tue, 13 January 2004 15:11 Go to previous messageGo to next message
nino is currently offline  nino   Germany
Messages: 19
Registered: May 2003
Karma: 0
Junior Member
but what is logtime?

Report message to a moderator

Re: Upgrade-error: MySQL Error: #1044 (Access denied for user: ... [message #16068 is a reply to message #16067] Tue, 13 January 2004 15:12 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
it's a field inside the table.

FUDforum Core Developer

Report message to a moderator

Re: Upgrade-error: MySQL Error: #1044 (Access denied for user: ... [message #16069 is a reply to message #16068] Tue, 13 January 2004 15:14 Go to previous messageGo to next message
nino is currently offline  nino   Germany
Messages: 19
Registered: May 2003
Karma: 0
Junior Member
CREATE INDEX fud25_action_log_i_ul ON fud25_action_log(

user_id,
logtime
)

MySQL meldet:


Access denied for user: 'web17@localhost' to database 'usr_web17_1'

Report message to a moderator

Re: Upgrade-error: MySQL Error: #1044 (Access denied for user: ... [message #16070 is a reply to message #16069] Tue, 13 January 2004 15:15 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
There you go...

FUDforum Core Developer

Report message to a moderator

Re: Upgrade-error: MySQL Error: #1044 (Access denied for user: ... [message #16071 is a reply to message #16070] Tue, 13 January 2004 15:24 Go to previous messageGo to next message
nino is currently offline  nino   Germany
Messages: 19
Registered: May 2003
Karma: 0
Junior Member
Thank you!
But what can I do now?
1. Call my web-hoster to ask him to change my account permissions?
2. or I try to uninstall v2.5.0 and install it again (I made forum datadump)
3. If I install v2.6.0 could I be able to restore/import those forum data

Report message to a moderator

Re: Upgrade-error: MySQL Error: #1044 (Access denied for user: ... [message #16072 is a reply to message #16071] Tue, 13 January 2004 15:27 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
#1 is your best bet.

#2 would work too, but 2.5.0 is no longer supported, so if you encounter any bugs, you are on your own.

#3 during new 2.6.0 installation you will likely encounter the same problem as you got while trying to upgrade the forum.

FUDforum Core Developer

Report message to a moderator

Re: Upgrade-error: MySQL Error: #1044 (Access denied for user: ... [message #16073 is a reply to message #16072] Tue, 13 January 2004 15:39 Go to previous messageGo to next message
nino is currently offline  nino   Germany
Messages: 19
Registered: May 2003
Karma: 0
Junior Member
thank you very much!
I'll do #1.

But how can I explan them, what I wont/need for my account?
Cann you tell me, please?
I can't understand how can this work with my account: (ALTER TABLE `test2` ADD PRIMARY KEY ( `field1` ( 6 ) ) !!!

by the way, I looked into fud25_action_log and I've found 1 index there (see attachment).

  • Attachment: index.jpeg
    (Size: 55.36KB, Downloaded 900 times)

Report message to a moderator

Re: Upgrade-error: MySQL Error: #1044 (Access denied for user: ... [message #16074 is a reply to message #16073] Tue, 13 January 2004 15:48 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You need to show them the query that failed (so they understand the problem) and tell them you need the ability to modify your tables and create new indexes.

FUDforum Core Developer

Report message to a moderator

Re: Upgrade-error: MySQL Error: #1044 (Access denied for user: ... [message #16075 is a reply to message #16074] Tue, 13 January 2004 15:52 Go to previous message
nino is currently offline  nino   Germany
Messages: 19
Registered: May 2003
Karma: 0
Junior Member
Thank you, Ilia.
best regards
Nick

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Blank Consistency checker page
Next Topic: Installation stoped in the middle
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 23:06:48 GMT 2024

Total time taken to generate the page: 0.02264 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software