cybercookie72
asked on
trying to move to a new web host and set up phpmyadmin
Greetings all
I am pretty rusty so please bare with me. I am working on changing web hosts for my website. The site is pretty much php based and I use phpmyadmin to setup/backup the tables. The current host setup phpmyadmin and uses MySQL client version: 4.1.22. besides using phpmyadmin I am not sure how to set it up.
The new host is using the same version of MYSQL and has set up a root user but I am expected to setup phpmyadmin. I see that in the / web folder there is a phpmyadmin folder and I am assuming that is where the magic happens...but my question is what configuration file or files would I need to change to get it to work on the new server??
or should I setup from scratch and if so how?
this is a business site so would really like it to be as secure as possible
thanks ahead of time..
I am pretty rusty so please bare with me. I am working on changing web hosts for my website. The site is pretty much php based and I use phpmyadmin to setup/backup the tables. The current host setup phpmyadmin and uses MySQL client version: 4.1.22. besides using phpmyadmin I am not sure how to set it up.
The new host is using the same version of MYSQL and has set up a root user but I am expected to setup phpmyadmin. I see that in the / web folder there is a phpmyadmin folder and I am assuming that is where the magic happens...but my question is what configuration file or files would I need to change to get it to work on the new server??
or should I setup from scratch and if so how?
this is a business site so would really like it to be as secure as possible
thanks ahead of time..
If you have files in the phpMyAdmin folder then you should be able access it via "your website" /phpmyadmin. It uses your mySQL credentials so no real setup.
ASKER
Hi Ray...I'm not the boss unfortunately, so I don't get to choose where the files go...I just got to figure out how to make them happy so they work again
Hi Number-1 .... yes that is how we accessed it website/phpMyAdmin, But wouldn't that access the old host's database if I just move the folder over because it has the user name and or the IP of the old host??? Both hosts are running atm while I figure this out. How would I get phpMyAdmin to point to or use the current host
Or is it just going to use the IP of where the files reside and the folder itself doesn't actually have anything to do with the validation of username/password it just passes it on and the host engine does the rest...hmmm
thank you guys for your help so far
Hi Number-1 .... yes that is how we accessed it website/phpMyAdmin, But wouldn't that access the old host's database if I just move the folder over because it has the user name and or the IP of the old host??? Both hosts are running atm while I figure this out. How would I get phpMyAdmin to point to or use the current host
Or is it just going to use the IP of where the files reside and the folder itself doesn't actually have anything to do with the validation of username/password it just passes it on and the host engine does the rest...hmmm
thank you guys for your help so far
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK Number-1 ....
yes the new host set up a username and password already...
I will check that out tonight !!!
thanks
yes the new host set up a username and password already...
I will check that out tonight !!!
thanks
ASKER
OK it looks like Number-1 is right about moving the folder over but I am currently having issues logging in to the database....error 2003 Can't connect to MySQL server
I get this error from phpMyAdmin AND the website pages ....
I have a config.php file for the web pages
$host=
$username=
$password=
$database=
are all correct according to tech support but I still get the error 2003
I changed config.inc.php for phpMyAdmin before uploading the directory
$cfg['Servers'][$i]['host' ]
$cfg['Servers'][$i]['contr oluser']
$cfg['Servers'][$i]['contr olpass']
are all what tech support told me they should be.....
sooo I was wondering if this is an updating issue? I uploaded the files and then changed the config files and uploaded them overwriting the old files.
also what is "The configuration file now needs a secret passphrase (blowfish_secret). " error
I get that and I set that var and it goes away but Im not sure what it's for?? could this be causing issues?
thanks again all
I get this error from phpMyAdmin AND the website pages ....
I have a config.php file for the web pages
$host=
$username=
$password=
$database=
are all correct according to tech support but I still get the error 2003
I changed config.inc.php for phpMyAdmin before uploading the directory
$cfg['Servers'][$i]['host'
$cfg['Servers'][$i]['contr
$cfg['Servers'][$i]['contr
are all what tech support told me they should be.....
sooo I was wondering if this is an updating issue? I uploaded the files and then changed the config files and uploaded them overwriting the old files.
also what is "The configuration file now needs a secret passphrase (blowfish_secret). " error
I get that and I set that var and it goes away but Im not sure what it's for?? could this be causing issues?
thanks again all
Do you have your mySQL database setup or did you plan on creating the database via phpMyAdmin?
The secret passphrase is not your problem but you should note it for future reference.
If you can get your tech support on the phone or chat they may be able to get you logged into phpMyAdmin quicker than trying to debug it. They may have given you incomplete/incorrect info and it should be apparent when they try to login themselves.
The secret passphrase is not your problem but you should note it for future reference.
If you can get your tech support on the phone or chat they may be able to get you logged into phpMyAdmin quicker than trying to debug it. They may have given you incomplete/incorrect info and it should be apparent when they try to login themselves.
ASKER
the host set it up(gave it the old db name)....gave us a new username and password
yeah I was on the phone with them and i got the "it's a content problem" answer and they don't deal with that
yeah I was on the phone with them and i got the "it's a content problem" answer and they don't deal with that
ASKER
OK...
It is magically working after the tech support tech and I parted ways???
I didn't change anything and logged in tonight to change config stuff and when the tab refreshed was able to log in???
but anyway around Number-1 was right .... thank you for all your help
It is magically working after the tech support tech and I parted ways???
I didn't change anything and logged in tonight to change config stuff and when the tab refreshed was able to log in???
but anyway around Number-1 was right .... thank you for all your help
ASKER
Thank you for the fast and accurate solution
Consider ChiHost, HostGator and LiquidWeb. If you call Nick Gilbert at ChiHost and tell him I sent you, I'll bet they will move your site for free and show you where to find the pre-installed phpMyAdmin in your cPanel!