Databases
StackOverflow2013
Postsdbo
POConnecting from VM to MySQL
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POConnecting from VM to MySQL
    primarykey
    data
    text
    <p>I'm having trouble connecting to a MySQL database on my host OS (Win 7) from my Oracle VirtualBox running Ubuntu. I wrote this php code in order to connect but I keep receiving an error connecting:</p> <pre><code>&lt;?php $dsn = 'mysql:host=192.168.1.9;dbname=finance'; $db_username = 'sdb_user'; $db_password = 'password'; try { $db = new PDO($dsn, $db_username, $db_password); }catch (PDOException $e) { $error_message = $e-&gt;getMessage(); include('../errors/database_error.php'); exit(); } $query = 'SELECT * FROM books'; $books = $db-&gt;query($query); foreach ($books as $book) { echo $book['title']; } ?&gt; </code></pre> <p>I know the code works, because I can get it to run from my Windows 7 host OS using localhost instead of the IP address, and I know that both Linux on VirtualBox and Windows 7 are on the same subnet because I can successfully ping the other from each side. </p> <p>I'm fairly certain that I opened port 3306 correctly on the windows side also, but I have no idea how to check if that's the problem or not.</p> <p>What else should I be doing to get the code to connect to the MySQL db?</p> <p>EDIT: The problem was that the port was not open for remote connections. After I opened the port I got the error message stating I was not allowed to connect to the sql server. From there I created a new user on the Windows MySQL with the username "home" and password "home" and was able to connect to it using:</p> <pre><code>$ mysql -h 192.168.1.9 -u home -p </code></pre> <p>However, when I run my file, which now reads:</p> <pre><code>$dsn = 'mysql:host=192.168.1.9;dbname=finance'; $db_username = 'home'; $db_password = 'home'; </code></pre> <p>I still get the 'database error' Any suggestions?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser2981293
    1. USuser2981293
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COTry to check avaliablility of your MySQL from VB, using `nmap` and `mysql` from command line
      singulars
      1. POConnecting from VM to MySQL
      1. USmega.venik
    2. COFrom your Linux box `telnet 192.168.1.9 3306` should show if 3306 is open and if MySQL is listening
      singulars
      1. POConnecting from VM to MySQL
      1. USMachavity
    3. CO@machavity I think this might be the problem. When I do it from VB it times out, but when I run netstat from windows command prompt, it shows up as listening. Any idea why this might be?
      singulars
      1. POConnecting from VM to MySQL
      1. USuser2981293
 

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