Hi all,
I am trying to migrate a PHP website onto a new server, in a new domain. I have installed the same version of EasyPHP and copied the files from old server onto the new one.
I am able to browse the old site but if I try and access any page that pulls data from the My SQL database I get access denied. I think this makes sense as I will be using different credentials now. My question is how do I manage My SQL and the permissions used to access it? I have never used My SQL before.
If I browse into the EasyPHP folder there is a My SQL folder and the below subfolders. I presume this is the database!!?
Structure
My SQL
Bin
data
docs
share
Inside the data folder there is a number of MYD, FRM, and MYI files.
Is there away I can install Adminer and gain access to the database and manage it this way.
As you can probably tell im stuck and lack experience in the database area.
Any questions let me know.
I am trying to migrate a PHP website onto a new server, in a new domain. I have installed the same version of EasyPHP and copied the files from old server onto the new one.
I am able to browse the old site but if I try and access any page that pulls data from the My SQL database I get access denied. I think this makes sense as I will be using different credentials now. My question is how do I manage My SQL and the permissions used to access it? I have never used My SQL before.
If I browse into the EasyPHP folder there is a My SQL folder and the below subfolders. I presume this is the database!!?
Structure
My SQL
Bin
data
docs
share
Inside the data folder there is a number of MYD, FRM, and MYI files.
Is there away I can install Adminer and gain access to the database and manage it this way.
As you can probably tell im stuck and lack experience in the database area.
Any questions let me know.