![]() ![]() To access online server database from XAMPP, you need to configure the XAMPP configuration files-the php.ini file and the my.ini file-to enable remote connections to the MySQL server.ġ) Open your XAMPP control panel on your machine and start Apache & MySQL modules if not running already.Ģ) Open phpmyadmin by going to in a browser window or simply click on admin option shown beside MySQL module in control panel as given below:ģ) Once you open phpMyAdmin page, select any existing databases or create a new one by clicking on Databases tab at navigation menu at top of page as shown below:Ĥ) After creating or selecting existing database for connection with external remote host (online server), Select it from left pane of phpMyAdmin window as shown below:ĥ) Click on Privileges option from top navigation menu as shown here:Ħ) You will be presented with list of all users with their privileges assigned Now click “Add New User” button at bottom of page as given here:ħ) You need to provide details like username & hostname (IP address / domain name ), password etc., after filling these details make sure you have checked box “Grant all privileges” so that this user has maximum access rights over selected database else select specific options using check boxes provided beside each privilege type (as marked red in screenshot). ![]() It consists of Apache HTTP Server, MariaDB database, and interpreters for scripts written in the PHP and Perl programming languages. XAMPP is an open-source web server solution stack package.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |