vb.org Archive - How i can have mysql on one server and the vb php files on another

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Big Board Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=172)

- - How i can have mysql on one server and the vb php files on another (https://vborg.vbsupport.ru/showthread.php?t=129960)

TheRealRage

10-25-2006 10:23 PM

How i can have mysql on one server and the vb php files on another

The topic title shoud explain very well what im trying to figure out.

I wanna have the mysql database of vb on one server and the php files on a diffrent one,
does anybody have and idea if thats possible and when ya how.

Regards

sebbe

10-25-2006 11:46 PM

PHP Code:


		
			
    //    ****** MASTER DATABASE SERVER NAME AND PORT ******

    //    This is the hostname or IP address and port of the database server.

    //    If you are unsure of what to put here, leave the default values.

$config['MasterServer']['servername'] = 'localhost';

$config['MasterServer']['port'] = 3306;

Change these values in includes/config.php

TheRealRage

10-26-2006 01:17 AM

so i change localhost to the ip of the server where the databse is on right ?

If ya that didnt worked out well nothing happends when i got to the server with the php files... the server where the database is on runs under plesk maybe the port is diffrent or such ... does somebody might know where i find the port of the mysql ....

any idea someone ?

Ntfu2

10-27-2006 02:26 AM

Yes, but be warned if you are transfer your database over public network you'll need a port speed of atleast 100mbps, and tons of spare bandwidth. Its best to have private connection between the two servers since most the time private bandwidth is free.

And i think plesk mySQL uses 8306 for connections, or something like that

jason|xoxide

10-31-2006 03:07 PM

The port Plesk uses is the default mysql port. However, DB users created through the Plesk interface can only access the DB from the localhost. If you want to connect from a remote system then you'll need to log into the mysql console and add a user that can connect remotely.

Ntfu2

10-31-2006 04:08 PM

Code:

GRANT ALL PRIVILEGES ON database_name.* TO 'database_user'@'db.server.ip.address' IDENTIFIED BY 'password';

All times are GMT. The time now is 10:57 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03333 seconds Memory Usage 1,727KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: