llz925 Posted May 5, 2010 Share Posted May 5, 2010 Hi - I am helping someone move their site and store over from one hosting company to another. I did not set this site up originally, so I'm going off what they have given me. So far everything is working but the database. I have created a new database but when I import the backup SQL file it gives me this error: Error SQL query: -- phpMyAdmin SQL Dump -- version 2.6.3-pl1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Apr 21, 2010 at 01:50 PM -- Server version: 4.1.20 -- PHP Version: 5.0.4 -- -- Database: `mydatabasename` -- CREATE DATABASE `mydatabasename` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; MySQL said: Documentation #1044 - Access denied for user 'username'@'%' to database 'mydatabasename' In searching the forums I think it has something to do with the permissions of the username in the database, but I have no clue as to how to change this. And help would be appreciated - thanks Link to comment Share on other sites More sharing options...
Guest Posted May 5, 2010 Share Posted May 5, 2010 did you create the database using the same old database user-name? Also did you create a user Link to comment Share on other sites More sharing options...
llz925 Posted May 5, 2010 Author Share Posted May 5, 2010 did you create the database using the same old database user-name? Also did you create a user when I set up the database it didn't ask me directly for a user, but had a line for "database name/user". Is this where the user name is made? There were no other option for it. And I only have the info that was in the configure.php files to go by. I used the info in there to name the database. I'm hoping this was all correct Link to comment Share on other sites More sharing options...
Guest Posted May 5, 2010 Share Posted May 5, 2010 when I set up the database it didn't ask me directly for a user, but had a line for "database name/user". Is this where the user name is made? There were no other option for it. And I only have the info that was in the configure.php files to go by. I used the info in there to name the database. I'm hoping this was all correct Hi did you create the database in phpmyadmin your username and password would be the one you used to login to your CP or login for phpmyadmin also are you restoring the database using the oscommerce restore instead of importing your database in phpmyadmin. 1044 usually means there is something up with your configuration.php file check the username, dbname, host name and password. Link to comment Share on other sites More sharing options...
Guest Posted May 6, 2010 Share Posted May 6, 2010 Hi did you create the database in phpmyadmin your username and password would be the one you used to login to your CP or login for phpmyadmin also are you restoring the database using the oscommerce restore instead of importing your database in phpmyadmin. 1044 usually means there is something up with your configuration.php file check the username, dbname, host name and password. Just an after thought You could delete the new database you created then create a new one with the missing information.. "database name/user" Link to comment Share on other sites More sharing options...
llz925 Posted May 8, 2010 Author Share Posted May 8, 2010 Hi did you create the database in phpmyadmin your username and password would be the one you used to login to your CP or login for phpmyadmin also are you restoring the database using the oscommerce restore instead of importing your database in phpmyadmin. 1044 usually means there is something up with your configuration.php file check the username, dbname, host name and password. Hi - I set the new database up through the website hosting control panel. I used the info that was listed in the configure.php file to set it up. The only thing though that I changed was the password. This new hosting company needed a more secure password than what was in the configure.php file. I made a new password and made sure to change the password that was in both configure.php files. I've tried just deleting what I setup before and start over again, but it keeps giving me the same errors. I'm either not setting this up right I think or I'm just really clueless! Link to comment Share on other sites More sharing options...
llz925 Posted May 9, 2010 Author Share Posted May 9, 2010 Hi - I set the new database up through the website hosting control panel. I used the info that was listed in the configure.php file to set it up. The only thing though that I changed was the password. This new hosting company needed a more secure password than what was in the configure.php file. I made a new password and made sure to change the password that was in both configure.php files. I've tried just deleting what I setup before and start over again, but it keeps giving me the same errors. I'm either not setting this up right I think or I'm just really clueless! Update: I still cannot get the old sql file to import. I've made another new database and reset the config files and it still is giving me the #1044 error. I'm sure I've got this setup right, I have another store setup on this same hosting company on a different account and everything looks like I've got it plugged in correctly based on that setup. Can anyone shed some light on this? Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.