View Single Post
  #1   (View Single Post)  
Old 24th July 2012
unixjingleman unixjingleman is offline
Fdisk Soldier
 
Join Date: Jan 2011
Posts: 70
Default Can't import mysql wordpress into jail

Hi there
I installed FAMP+wordpress in a jail. I'm trying to import the wordpress database from a linux server. mysqldump completed on this Linux server with no errors. Also I can connect to the wordpress admin page on the FreeBSD host from other hosts on the network. The wordpress database has been created and the privileges have been set according to this. However when i do:
#
Code:
mysql -u root -p wordpress < /root/word_dump.sql
i get this error:
Code:
Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
The word_dump.sql got moved with mv to /root in the jail before running the above command.
I'e googled but only found, mostly stuff on phpmyadmin and quite a lot of unanswered stuff. I tried --skip-grants-table in various combinations(with -u root -p, with just -u root, on it's own) to no avail. It said unknown option. I'm not wanting you to trawl through the masses of stuff on mysql errors. I just thought someone might already know opr have experienced something similar!
Any help would be great thankyou for any replies

Last edited by unixjingleman; 25th July 2012 at 09:04 PM.
Reply With Quote