Forwarding MySQL
Posted by: Karuse (---.static.upcbusiness.at)
Date: October 21, 2016 10:04AM

Hello,

Wamp is running on a Windows 7 with Vhosts and all, whitout any problem.
But Wordpress access an MySQL server like 0815.mydb.com_3306
How can i forward this to localhost:3306?

Best regards,
Karuse

Options: ReplyQuote
Re: Forwarding MySQL
Posted by: RiggsFolly (Moderator)
Date: October 21, 2016 01:31PM

Check the WordPress site.

You will probably have to amend the config file, but thats a bit of a guess

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Forwarding MySQL
Posted by: Karuse (---.static.upcbusiness.at)
Date: October 24, 2016 11:25AM

I know, that i have to adjust the wp-config file.
But it whould be easier, to forward the MySQL Server.
Then i have to do no changes and no fault be happen.

Options: ReplyQuote
Re: Forwarding MySQL
Posted by: RiggsFolly (Moderator)
Date: October 24, 2016 12:19PM

Problem with that idea is that you will be testing against your LIVE database ( I assume this is your live database)

Thats never a good idea

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Forwarding MySQL
Posted by: Otomatic (Moderator)
Date: October 24, 2016 02:04PM

Hi,

From a local server as Wampserver and from a server "online", you can not connect to a MySQL server other than the server on which you are.

No web host can connect to the MySQL server from a server other than his own.
A web host that would allow such a thing is to avoid like the plague.

You MUST export your Wordpress database to a SQL file from the "online" server and import it into Wampserver.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Options: ReplyQuote
Re: Forwarding MySQL
Posted by: Karuse (---.static.upcbusiness.at)
Date: October 25, 2016 03:54PM

I know this.
I exported the hosters MySQL in a file and reimport it into my local Mysql.
I add the user and pass same then the hosters Mysql account.
I just have to change the 0815.dbserv.com to localhost in the wp-config file.

So i ask, is it possible to route the 0815.dbserv.com access from wordpress to localhst?
So nothing whould needed to be changed?

Options: ReplyQuote
Re: Forwarding MySQL
Posted by: Otomatic (Moderator)
Date: October 25, 2016 04:02PM

Hi,

> So i ask, is it possible to route the 0815.dbserv.com access from wordpress to localhst?
NO.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Options: ReplyQuote


Sorry, only registered users may post in this forum.