Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

How do I create the database tables?

Quote Reply
How do I create the database tables?
I am trying to install Links SQL 2 and I am having some problems creating the database tables. I have created a new database using mysqladmin, and the database folder is now completely empty. When I go through the install process, everything seems to run fine, but no tables are ever created. When I run setup, the following error occurs:

"Error: Could not connect to database. Reason: Access denied for user: 'redirect123@localhost' (Using password: YES)"

In the 2.0 readme file, there isn't even any mention of the database or the tables, but in the 1.13 documentation, it says they are supposed to be created for you.

Is there an easy way for me to create the tables myself, or is there something else that is causing the problem? i.e., is this actually a problem with user permissions or something? If so, what command should I use to make sure that the right permissions are granted so I will be able to complete the setup process? Is anyone here familiar with what might be causing this error message?

Thank you,

Rob Bartlett

Quote Reply
Re: Problems connecting to database. In reply to
You need to use the following info in the login page of the setup.cgi script:

HOST: localhost
USERNAME: your username
PASSWORD: your MySQL password (most likely differs from your regular account password)

NOW, if your hosting company has not locked down access to the MySQL server via a password, then try leaving the PASSWORD field blank and simply provide the other info I gave.

Good luck!

Regards,

Eliot Lee
Quote Reply
Re: Problems connecting to database. In reply to
I have actually been trying to run setup with the root username and password, which I assumed should work. I just went back to the page and I noticed that somehow I managed to get an extra "1" in the username, which is strange because it did not show up in the error message...

Not sure how long that was the problem for, I "hope" it wasn't like that 20 submissions ago. =P (I was just hitting the back button to resubmit after I did my troubleshooting so I could "save" myself some time.)

At least it appears to be fixed now. =)

Thanks for the suggestion!


Quote Reply
Re: Problems connecting to database. In reply to
You're welcome.

Regards,

Eliot Lee