whitewiddow Posted December 10, 2006 Share Posted December 10, 2006 hi, i backed up the database for my forum the other day by exporting it and when i try and import it now i get the message:[color=red]#1044 - Access denied for user 'user'@'localhost' to database 'user_phpb1'[/color]can you help ??the full message reads:[color=red] -- phpMyAdmin SQL Dump-- version 2.8.0.2-- http://www.phpmyadmin.net-- -- Host: localhost-- Generation Time: Dec 10, 2006 at 06:18 AM-- Server version: 4.1.21-- PHP Version: 4.4.2-- -- Database: `user_phpb1`-- CREATE DATABASE `user_phpb1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;MySQL said: Documentation#1044 - Access denied for user 'user'@'localhost' to database 'user_phpb1[/color] Quote Link to comment https://forums.phpfreaks.com/topic/30122-major-prob-need-help-asap/ Share on other sites More sharing options...
Crusader Posted December 10, 2006 Share Posted December 10, 2006 It seems like you've either got the wrong password or the mysql account you're trying to import with doesn't have the correct permissions.Is the database user_phpb1 already made? If so, and you know for sure your backup works, empty it and comment out the create database line in your backup. Otherwise, if there is no user_phpb1 database created, create it and import the dump again (again with the line create database commented out).Hope that helps and don't go emptying or deleting tables unless you're 100% sure. Quote Link to comment https://forums.phpfreaks.com/topic/30122-major-prob-need-help-asap/#findComment-138470 Share on other sites More sharing options...
whitewiddow Posted December 10, 2006 Author Share Posted December 10, 2006 thankyou that helps a lot... but i dont actually know how to comment out the create database line ? Quote Link to comment https://forums.phpfreaks.com/topic/30122-major-prob-need-help-asap/#findComment-138477 Share on other sites More sharing options...
Crusader Posted December 10, 2006 Share Posted December 10, 2006 I think you just have to put a -- infront of that part. Quote Link to comment https://forums.phpfreaks.com/topic/30122-major-prob-need-help-asap/#findComment-138665 Share on other sites More sharing options...
chronister Posted December 11, 2006 Share Posted December 11, 2006 to comment it out.... //CREATE DATABASE `user_phpb1` DEFAULT CHARACTER SET latin1 COLLATE //latin1_swedish_ci;or /* CREATE DATABASE `user_phpb1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; */ Quote Link to comment https://forums.phpfreaks.com/topic/30122-major-prob-need-help-asap/#findComment-138735 Share on other sites More sharing options...
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.