Connecting to a remote database from localhost can be done
in many ways. Here I am going to explain a very simple way to do so. That is,
connecting a remote database using phpmyadmin in the local server.
To do so you need to follow the simple steps given below,
Note: Hope you guys have server installed in your local
machine Xampp, Wamp etc. I am using xampp for the tutorial.
1.
Open the XAMPP control panel. You can open it
from the Xampp directory. (eg: C:\xampp ->xampp-control)
2.
Click on the Config button on the right side of
Apache and select PhpMyAdmin (config.inc) from the dropdown list.
3.
Now you need to add the connection details in
the config.inc document just before the php closing tag in the following
format.
Eg:
$i++;
$cfg['Servers'][$i]['host'] = ''; //provide
hostname and port if other than default
$cfg['Servers'][$i]['user'] = '';//user
name for your remote server
$cfg['Servers'][$i]['password'] =
'';//password
$cfg['Servers'][$i]['auth_type'] =
'config';
4.
Now save the document and restart the server.
5.
Open phpmyadmin (localhost/phpmyadmin/) and you
can see a section on the left sidebar “Current server:” with a dropdown list.
From the list you can select the remote server and do the work.
This is an awesome post. Kindly do share more post in this kinds.
ReplyDeleteSpoken English Classes in Velachery
Spoken English in Velachery
Spoken English Classes in Tambaram
Spoken English Class in Chrompet
Spoken English Classes in OMR Chennai
Spoken English Classes in Navalur
Spoken English Class in Ambattur
Spoken English Class in Avadi
Nice article I was really impressed by seeing this blog, it was very interesting and it is very useful for me.
ReplyDeleteSalesforce Training in Chennai
Salesforce Training
Ethical Hacking Course in Chennai
Angularjs Training in Chennai
CCNA Training in Chennai
Salesforce Training in Chennai
Salesforce Training in Chennai
Such a wonderful post, Your explanation way is too good and this is very easy to understand with depth content. Kindly updating for me.
ReplyDeleteCorporate Training in Chennai
Corporate Training
Oracle DBA Training in Chennai
Embedded System Course Chennai
Power BI Training in Chennai
Linux Training in Chennai
Oracle Training in Chennai
Tableau Training in Chennai
Unix Training in Chennai
Excel Training in Chennai
I am glad that I saw this post. It is informative blog for us and we need this type of blog thanks for share this blog, Keep posting such instructional blogs and I am looking forward for your future posts.
ReplyDeleteCyber Security Projects for Final Year
JavaScript Training in Chennai
Project Centers in Chennai
JavaScript Training in Chennai
In this current economic environment, no one can afford to put their career on the back burner. With so many layoffs in the last couple of years, task list templates
ReplyDeleteHi buddies, it is great written piece entirely defined, continue the good work constantly. UK RDP
ReplyDeleteI am feeling grateful to read this.you gave a nice info for us.please update more.
ReplyDeleteWeb Designing Course Training in Chennai | Web Designing Course Training in annanagar | Web Designing Course Training in omr | Web Designing Course Training in porur | Web Designing Course Training in tambaram | Web Designing Course Training in velachery
i really like this article please keep it up. https://europa-road.eu/hu/nehezgep-szallitas-arak.php
ReplyDelete