Databases
StackOverflow2013
Postsdbo
POHow to allow MySQL on Windows Server for external remote access?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to allow MySQL on Windows Server for external remote access?
    primarykey
    data
    text
    <p>i have installed xampp on my windows server 2008 R2. I'm running a script there that stores me data over the day. Now i want to retrieve the data from my own computer or just external by connecting the database via mysql_connect("hostname","username","pw"). after some research i have got told that i have to commend</p> <pre><code>&gt; [...] &gt; #bind-address = 127.0.0.1 &gt; #skip-networking [...] </code></pre> <p>in /etc/mysql/my.cnf</p> <p>didn't find the my.cf file in mysql but found one in xampp/mysql/bin/my.ini . But when i opened the file i found the lines even commented so hadn't got to change anything..... strange.</p> <p>then i got told to create a new user with the host setted %. So i did. now i tried to acces the database on my pc (xampp) but when i want to connect the database, i just get the error message, that the connection failured. Where is the mistake ?</p> <p>thanks </p> <p>edit:</p> <p>thats howi exactly connect</p> <pre><code>$connection=mysql_connect("hostname","usrname","password")or die(mysql_error()); mysql_select_db("dbname")or die(mysql_error()); </code></pre> <p>and the error message i get is german you can trabslate.</p> <p>Warning: mysql_connect(): Ein Verbindungsversuch ist fehlgeschlagen, da die Gegenstelle nach einer bestimmten Zeitspanne nicht richtig reagiert hat, oder die hergestellte Verbindung war fehlerhaft, da der verbundene Host nicht reagiert hat. in C:\xampp\htdocs\tickerdata\get.php on line 4</p> <p>just means as much as connection failured because remote didnt react in certain time period or connection was faulty because host didnt react...</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USemaillenin
    1. USsami_analyst
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to allow MySQL on Windows Server for external remote access?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow to allow MySQL on Windows Server for external remote access?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan you give us the exact error message? The "my.ini" file is correct for a windows machine (the "/etc/mysql/my.cnf" file would be on a Linux machine). The MySQL user with a host of `%` means that that user can log in from anywhere, not just localhost.
      singulars
      1. POHow to allow MySQL on Windows Server for external remote access?
      1. USjakerella
    2. CO1. "usrname" is spelled "username", im not sure if this would help but its worth a glance :\ have you tried googling this problem? (even just the error message) there is usually someone who has an answer :\
      singulars
      1. POHow to allow MySQL on Windows Server for external remote access?
      1. USSteve P
    3. CO[one question from stack overflow that might help...](http://stackoverflow.com/questions/3837051/mysql-connection-string-using-php)
      singulars
      1. POHow to allow MySQL on Windows Server for external remote access?
      1. USSteve P
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload