!!blue Posted October 16, 2003 Posted October 16, 2003 Hi, getting the following error when I try to "initialize" by blog by going to mywebpage.com/mt/mt-load.cgi: Loading initial data into system... An error occurred while loading data: Connection error: Access denied for user: 'mtadmin@localhost' (Using password: YES) what did I do wrong? I created the database in the CPanel > Manage MySQL and my user name and password. I knew I shouldn't have taken on this task on my own and know I'm hopelessly lost ... thanks! !!blue Quote
Dennis Posted October 16, 2003 Posted October 16, 2003 Did you create a valid user in PHPadmin for the database and then update the config mt.cfg? Like below. ># The filesystem path to the 'db' directory, where your MT database # files are stored. You will probably need to change this when you # first install MT; instructions for doing so are in the Installation # Instructions, in INSTALLING THE MOVABLE TYPE APPLICATION CODE, Step 8. ObjectDriver DBI::mysql Database your_database DBUser your_database_user Also remeber to update the mt-db-pass.cgi with your database password..... This should see you thru..... Dennis Quote
!!blue Posted October 16, 2003 Author Posted October 16, 2003 Dennis, Yes, I did: in CPanel > Manage MySQL the database name is shown as: zobluec_mtdatabase and the user name is shown as: zobluec_mtadmin should I put exactly that in the mt.cfg file? cuz right now it's: ObjectDriver DBI::mysql Database mtdatabase DBUser mtadmin and I did enter the correct password in the mt-db-pass.cgi file. Is it that I have to use the prefix zobluec_ for database and DBUser? --------------------------------------------------------------------------- allright, I tried the above and used the prefix zobluec_ and got the following error: Loading initial data into system... An error occurred while loading data: Connection error: Access denied for user: 'zobluec_mtadmin@localhost' to database 'zobluec_mtdatabase' I think i'm going crazy ! Quote
Dennis Posted October 16, 2003 Posted October 16, 2003 Yup, you have to use the full name of which the first part before the underscore is needed...... mysite_databasename mysite_databaseuser Dennis Quote
!!blue Posted October 16, 2003 Author Posted October 16, 2003 Ok, so I did that and I still get an error message: Loading initial data into system... An error occurred while loading data: Connection error: Access denied for user: 'zobluec_mtadmin@localhost' to database 'zobluec_mtdatabase' anything else I need to do? Quote
dreamcloudwolf Posted October 16, 2003 Posted October 16, 2003 I had a similar problem like this, but my problem was forgetting to assign the user to database in Cpanel. Assigning user to database Scroll where there are 2 dropdown boxes with a button that says: [Add User to Db]. In the dropdown boxes, select your database and username, which would say: mydomainname_mtdb mydomainname_John Click [Add user to Db] Hope that helps. Quote
!!blue Posted October 16, 2003 Author Posted October 16, 2003 Yes! that did it! Thank you, thank you, thank you! Phew! One stumbling block outta the way! On to the next one! thanks again! !!blue Quote
Dennis Posted October 16, 2003 Posted October 16, 2003 Good advice, Dreamcloudwolf Glad to see your problem solved, just give a holler if you run into another;) Dennis Quote
!!blue Posted October 16, 2003 Author Posted October 16, 2003 It never ceases to amaze me how quickly everyone helps everyone here! :hug: Quote
jethrot Posted November 5, 2003 Posted November 5, 2003 OK, I feel stupid. I've done all the stuff in this thread, but I'm still getting the same error: Loading initial data into system... An error occurred while loading data: Connection error: Access denied for user: 'jethrot_mtadmin@localhost' to database 'jehtrot_mtdatabase' I've created the database in cpanel, created the user, added the user to the database: MySQL Account Maintenance Account added to Access List Added the user jethrot_mtadmin to the database jethrot_mtdatabase. Help! Thanks! Jeff Quote
jethrot Posted November 6, 2003 Posted November 6, 2003 Sheez...I feel like a complete idiot now. There was a typo in my mt.cfg file. Quote
Guest schussat Posted November 6, 2003 Posted November 6, 2003 Sheez...I feel like a complete idiot now. There was a typo in my mt.cfg file. No worries, jethrot -- if typos were commercials, we'd all be on TV. (With apologies to John Prine.) Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.