Avatar of cybercookie72
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..
PHPMySQL Server

Avatar of undefined
Last Comment
cybercookie72

8/22/2022 - Mon
Ray Paseur

Good grief!  You have a professional hosting company that does not offer phpMyAdmin as part of the package?  I would get out of there as fast as I could.

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!
Randy Downs

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.
cybercookie72

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
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER CERTIFIED SOLUTION
Randy Downs

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
cybercookie72

ASKER
OK Number-1 ....

yes the new host set up a username and password already...

 I will check that out tonight !!!

 thanks
cybercookie72

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]['controluser']  
$cfg['Servers'][$i]['controlpass']  

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
Randy Downs

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
cybercookie72

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
cybercookie72

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
cybercookie72

ASKER
Thank you for the fast and accurate solution
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23