Im having some trouble getting my ikonboard to use mySQL. On my previous host, I just asked the admin to set up the mySQL database for me and send me the user/pass and database name. He did and all worked well.

I've since switched to rackshack, and the tech support here 'doesn't cover' this issue, whatever that means. I'll save my rant on that subject.

What I need is one of you knowledgable people in here to help me set up the mySQL database, user and pass properly so I know how to do it and get my board to work.

It installs fine, and when it asks for the mySQL user, pass and database, it accepts them all fine. I encounter the problem when I try to import a previous database, it then gives me this error:

Ikonboard CGI Error
--------------------------------------------------------------------------------
Ikonboard has exited with the following error:

Cant connect to mySQL database. Access denied for user: husker5@localhost (Using password: NO)

This error was reported at: Sources/iDatabase/Driver/mySQL.pm line 55.

Please note that your real paths have been removed to protect your information.


I indeed did put in the password where it asked, so I am thinking I didnt actually set it up right, or maybe permissions arent set (I dont know how to set them).

Any help would be much appreciated. Thank you.

you have to create EXACTLY the same username/database_name and pw as you have on your old host in the new account. For example:

you have:

username: you
database_name: you
pw: you

Then on the new host (at RS using Cpanel) you have to create the samething. First, create username/pw, then database THEN add the user to the database.

Then log in SSH and run this:

mysql -u USERNAME -p DATABASE_NAME < /home/your_username/backup.sql

Ok, thanks. That actually makes sense. I will give it a go this evening!

Hiya, I tried this. I wanted to see if I could get it running fron scratch, since I couldnt remember what the first username was.

So I made the user/pass, then the database, then added the user to the database. But when I tried to run the line:

mysql -u husker5_spap -p husker5_cyberplant < /home/husker5/backup.sql

it said: bash: /home/husker5/backup.sql: No such file or directory

What is this line supposed to do anyway?

Here's a question: My username for this account in general is husker5. When making the user and database for mySQL, I picked spap for the user and cyberplant for the databse. When looking at it now, it says the username is husker5_spap and the database is husker5_cyberplant.

When putting in the user and database name into ikonboard setup, do I put in husker5_spap & husker5_cyberplant or just spap and cyberplant?

Im not so worried about the old databses anymore, I just want to get mySQL running with ikonboard, from scratch would be fine.

yes you have to use this husker5_spap & husker5_cyberplant

ok, those are what i have been using. I set up the name, the database then added the name to the database. What does that command line that you specified actually do? Is that what sets the permissions?

moved to EV1Servers Forums > Cpanel/WebHost Manager > Cpanel Add-Ons and Developments >
the how to sections are for informative posts only

Ok, I see it got moved. Now can anyone help answer my questions so I can finally get ikonboard running with mySQL?