Help - Search - Members - Calendar
Full Version: An error occurred while loading data
Movable Type Community Forum > Installing and Upgrading > Databases
Maggie
While trying to run MySQL I got this error message:

An error occurred while loading data:

Connection error: Access denied for user: 'divamaggie@localhost' (Using password: YES)


Could anyone help me with this?  Thanks.
bmk
Make sure that you as a user have the proper permissions for the database.... you need to be able to create tables and everything.

And make sure you have the password and user name right.  

Brenna
Maggie
When I ran my mt-check.cgi it said "DBD::mysql...
       Your server has DBD::mysql installed."  
In my control panel it goes on to say "Due to security implications, users do not have the MySQL file privilege. However you can still import datafiles by adding the "local" keyword. Here is an example:

% mysql -u your_user_name -p

mysql> use your_database_name;
mysql> LOAD DATA local INFILE "/home/your_username/your_datafile" INTO TABLE your table_name;"

Does this make any sense?
bmk
Somebody said that same thing yesterday!  I'm not sure what that means. ("Due to security implications, users do not have the MySQL file privilege.").  added, oh... it was you.  smile.gif

MT needs to create some tables in there, is that message saying it can't?  It won't work to just import your entries into a database like the message suggests because MT needs to write the data when you add a new entry and stuff.

Could your host shed some light on this?

Brenna  huh.gif
Maggie
Thank you bmk!  I guess I will check with my host.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2010 Invision Power Services, Inc.