L* R*
HOME FORUM DOWNLOADS
Content
  Links
     Browse SVN
     SVN Commit log
     Documentation (Wiki)
  Developers
     Taskmanager
User
Welcome, Guest. Please login or register.
Did you miss your activation email?
December 02, 2008, 11:22:35 PM

Login with username, password and session length
Search



Advanced search
Support GoPHP5.org
BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Development > Coding and development discussion > Topic: [Resolved] Connecting to Remote Host for MySQL
Pages: [1]   Go Down
« previous next »
Print
Author Topic: [Resolved] Connecting to Remote Host for MySQL  (Read 534 times)
0 Members and 1 Guest are viewing this topic.
Madame
Freshman
*
Offline Offline

Posts: 7


[Resolved] Connecting to Remote Host for MySQL
« on: April 16, 2008, 11:30:19 PM »

Hunted around for a good bit and couldn't find a straight up guide for connecting to a remotely hosted MySQL database so..

I am looking for some sort of a walk through to doing this... I have a few MySQL databases available. Seeing as how hosting and such is not my specialty at all and trial and error for 30 minutes got me absolutely nothing someone who knows what they're up to would be loved on so many levels about now. Smiley

I have set up the database on the host side but cannot for the life of me figure out how to get the bot to find/access/cooperate with it via the conf/MySQL.conf . Assistance would be loved Smiley And I suppose I should post some of my customs while I wait.... >.>... Thanks in advance Smiley
« Last Edit: April 17, 2008, 12:21:01 AM by Madame » Logged
Temar
BeBot Developer
Grandmaster
********
Offline Offline

Gender: Male
Posts: 877



WWW
Re: Connecting to Remote Host for MySQL
« Reply #1 on: April 16, 2008, 11:50:57 PM »

you need to put the details of the server in the .conf
like the address the mysql server is at
and make sure ur server allows remote access with the login details u put in the .conf
Logged

MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
Madame
Freshman
*
Offline Offline

Posts: 7


Re: Connecting to Remote Host for MySQL
« Reply #2 on: April 17, 2008, 12:03:41 AM »

:takes a deep breath and tries it all again: well at least it seems like I'm going in the right direction with it.... do need to confirm I can remotely access the database... but I assume I would be able to.... Perhaps this would help me more since this seems to be what confounds me repeatedly

<?php
   /*
   Database name
   */
   $dbase = "notsure";    <- all my db's come in the format 'screename_dbname'. So... this would be the full 'screename_dbname' I would assume..... please correct if I'm way off (or even slightly Wink )

   /*
   Database username
   */
   $user = "woohoo";    <-- obvious..

   /*
   Database password
   */
   $pass = "toodles";    <-- obvious..

   /*
   Database server (usually localhost)'
   */
   $server = "localhost";      <-- This would... become the exact address of that databse.. or.. the IP or........ :keeps trying things:


Trial and error.. I'll get this eventually :gets out large stick to start thumping things to make them work:
Logged
Temar
BeBot Developer
Grandmaster
********
Offline Offline

Gender: Male
Posts: 877



WWW
Re: Connecting to Remote Host for MySQL
« Reply #3 on: April 17, 2008, 12:08:16 AM »

well when i used to have shared hosting were i dont have control over SQL, the DB was Localhost only

glad i dont use that no more, i got a VDS where i can do wat i want!
Logged

MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
Madame
Freshman
*
Offline Offline

Posts: 7


Re: Connecting to Remote Host for MySQL
« Reply #4 on: April 17, 2008, 12:13:32 AM »

Well, this is running from my home PC and accessing a remote database >.>... Preferred this to trying to figure out how to get the website to talk to the bot or my resident db. I know how to make the page talk to the db but not the bot to talk to the db... :starts swinging thumping stick wildly:

"
Warning: mysql_connect(): Access denied for user 'bot'@'my.location.com'
...."

Really tiring of that message... going to try a few more things then call it a night and hope someone trots along with the piece that I'm missing.... :/
Logged
Temar
BeBot Developer
Grandmaster
********
Offline Offline

Gender: Male
Posts: 877



WWW
Re: Connecting to Remote Host for MySQL
« Reply #5 on: April 17, 2008, 12:15:08 AM »

why dont u just run mysql on ur pc too?
Logged

MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
Temar
BeBot Developer
Grandmaster
********
Offline Offline

Gender: Male
Posts: 877



WWW
Re: Connecting to Remote Host for MySQL
« Reply #6 on: April 17, 2008, 12:16:08 AM »

BTW if the Details are Correct like username and password im pretty sure access denied is because its localhost only and u can remote access it
Logged

MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
Madame
Freshman
*
Offline Offline

Posts: 7


Re: Connecting to Remote Host for MySQL
« Reply #7 on: April 17, 2008, 12:20:36 AM »

Holy flying english muffins! (Translation: It works.)

Seems the host tosses an additional tidbit on all of my usernames (xxx_username) that I was missing.

And I'm not hosting from my own pc because I would like to have backup bots on other computers with up to date db's. I have many modules that are highly variable and I would like to have the bot transition seemless. I commute regularly and if my host computer goes down to the point where I can't remote access it to resolve the issue I want to be able to call my orgmate and have him boot up his bot that uses the same database. Cheesy

Anyways, I'm ECSTATIC atm so yes.... Chicago beware o.o.....

Thanks for making me not go attacking things with further objects. The thumping stick seemed to work well enough Cheesy
Logged
Temar
BeBot Developer
Grandmaster
********
Offline Offline

Gender: Male
Posts: 877



WWW
Re: [Resolved] Connecting to Remote Host for MySQL
« Reply #8 on: April 17, 2008, 12:27:10 AM »

i just have my all my bots running on my server, i can manage anywere Cheesy

i see you use Support Forums, (changed Topic to Resolved) :p
Logged

MSN messenger: chris_smith96 at hotmain dot com
Xfire: chriss96
Madame
Freshman
*
Offline Offline

Posts: 7


Re: [Resolved] Connecting to Remote Host for MySQL
« Reply #9 on: April 17, 2008, 11:12:47 AM »

Well I saw it on another post by one of the gods of these forums so I figured I might as well keep in taste Wink

And I would run it all on my own server but..... this is free Smiley And.. free is good Smiley
Logged
Pages: [1]   Go Up
Print
BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Development > Coding and development discussion > Topic: [Resolved] Connecting to Remote Host for MySQL
« previous next »
 
Jump to:  

Recent
!items database
by Zeephonz
[Today at 08:05:21 PM]

Log playtime from buddys ...
by IKShadow
[Today at 06:48:12 AM]

[request] Raid timers
by Elesar1
[December 01, 2008, 04:41:09 PM]

Shared DB online list
by Temar
[December 01, 2008, 01:55:47 AM]

relay colors
by Temar
[December 01, 2008, 01:54:56 AM]

BeBot v0.6.0 released
by Alreadythere
[November 30, 2008, 05:32:00 PM]

Change to Bid.php
by Temar
[November 30, 2008, 11:41:44 AM]

OnlineOrg
by Jiheld
[November 29, 2008, 12:44:27 PM]

Silly Newbie Question.
by Temar
[November 29, 2008, 12:00:02 PM]

massive_pvp_time_table 1
by gerborg
[November 29, 2008, 06:55:35 AM]
Stats
Members
Total Members: 1244
Latest: Armonkens
Stats
Total Posts: 11146
Total Topics: 1505
Online Today: 25
Online Ever: 168
(July 01, 2007, 09:30:02 PM)
Users Online
Users: 2
Guests: 16
Total: 18
Elesar1
Vain

Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC
TinyPortal v0.9.8 © Bloc | NewDef design by Bloc
Page created in 0.254 seconds with 28 queries. (Pretty URLs adds 0.029s, 4q)
Loading...