Mt Installation Problem

[shaister]

Hi All,

 

I'm attempting to install MT on my server. I set up the mt/ folder in public_html.

I got everything set up and mt-check.cgi ran without a problem.

 

However, when I tried rnning MT-load.cgi I get a message saying "Access denied for user: " and the db username I entered. It says (Using password: YES)

 

I've tried adding/deleting mySQL users but to no avail.

 

Any ideas would be much appreciated.

 

Thanks,

 

Shai

[MikeJ]

Make sure after adding a user to mysql that you added them to the database (there's two steps... adding a user, and adding them to the database).

 

Also make sure in mt-db-pass.cgi you have placed the correct password in there for the user you created (replacing the word "password"... your db password should be the only thing in that file).

 

In your mt.cfg, make sure you have all of the following lines, replacing "account" with your account login, "database" with the name of the db you created, and "dbuser" with the name of the user you created (which will show up as account_dbuser anyway in the mysql admin interface).

 

>DataSource ./db
ObjectDriver DBI::mysql
Database account_database
DBUser account_dbuser

 

Let me know if none of that helps.

[shaister]

Hi Mike,

 

I did all that, but unfortunately it still gives me the same message.

 

Is there any way to check the mySQL permissions or something?

[MikeJ]

It sounds like you aren't getting logged in, rather than a permissions error. I would try changing your mysql password for that user to something simple. Change it in mt-db-pass.cgi as well. When you get it all working, try changing it back.

 

If you want to see the permissions, though:

 

When you select Manage MySQL, make sure under the database name it says:

 

Users in database

 

account_dbuser (Privileges: ALL PRIVILEGES)

 

You need a minimum of (Privileges: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER) in order for MT to work properly.

[shaister]

Just realized that I did not in fact add the dbuser to the database. Now it works.

 

Thanks for the help!

[MikeJ]

Yay! Thumbs Up

 

Congrats on getting it running.

[TCH-Don]

Way to go Mike Thumbs Up

 

And

Welcome to the family shaister

 

as you see your family loves to help,

if you need anything, just ask.