155
edits
No edit summary |
No edit summary |
||
| Line 328: | Line 328: | ||
Note.- When you will these follow steps for the host and port for your particular installation, should be different than shown in this example. | Note.- When you will these follow steps for the host and port for your particular installation, should be different than shown in this example. | ||
Note2. - In this step, we also could create a different data base and a different owner, because be have the superuser credentials of MySQL, but this step does not touch it here today. | |||
Click Next Step and displays the following window. | |||
Image 35<br /> | |||
[[File:Confirm_configuration.JPG|500px]] | |||
This screen basically tells us that the connection to the database has been established and this information is saved in the configuration file conf.php of dolibarr. | |||
Click Next Step and start creating tables in the database, necessary for the work of Dolibarr. | |||
Image 36<br /> | |||
[[File:Database_susetfull_created.JPG|500px]] | |||
This screen reports that have completed the creation of the tables. | |||
Click in Next step. | |||
Image 37<br /> | |||
[[File:Insert_admin_credentials.JPG|500px]] | |||
We fill the fields with the username and password, which will be the administrator, for this example I used admin/admin. For the real case should be a stronger password. | |||
Click in Next step. | |||
Click in Go to Dolibarr (setup area). | |||
Insert the username and password of the administrator, as defined above and Viola. We are within Dolibarr. | |||
== Connection remote MySQL == | |||
As a final step, we will see the connection from a local client database, to our remote MySQL. | |||
For this example I will use HeidiSQL, which serves both MySQL or PostgreSQL database and is Free. | |||
Open HeidiSQL. | |||
The first thing to do is select MySQL (SSH tunnel) Network type drop down, in so doing, HeidiSQL adds a new tab called SSH tunnel, as shown in the image below. | |||
image 41<br /> | |||
[[File:Ssh_tunnel_HeidiSQL.JPG|500px]] | |||
edits