MySQL Issues On Stoli

[Shotgun202]

I did all of what you said to do, but I am getting the following errors.

For my PhpBB Forum.

SQL ERROR
 
Unknown MySQL server host 'mysql.x10hosting.com ' (3) [2005]
 
An sql error occurred while fetching this page.

For my Wordpress

this is your issue; after mysql.x10hosting.com you have a space; get rid of that space and it should work
Edit:

I too am having issues with Fantastico. Keep getting:

Fantastico is unable to connect to your MySQL server at this time. Please contact your host for assistance.


I was successful in adding Stoli, but I am still stomped on changing localhost to mysql.x10hosting.com.

I thought that I would be able to change this in the MySQL databases section of cPanel but was not successful. Any suggestions?

This is the easy solution to you Garlund; go to the product's website download it and install it the good old fashion way; that's what i had to do; i know it's a pain but you gotta do what you gotta do.
Edit:
As for Josh1 contact me on xfire: S1ho1tgu1n2012 (Remove all the '1's and i'll help you all I can

 

[skillzdatkillz]

I have done all this and now my site, www.skillzgaming.com, is down..

 

[Garlund]

Okay you lost me with the Products thing. I can assure you I am not slow, but am just not looking in the right area. Where is the Products link at? Or do you mean I have to download and install Fantastico?

And thank you for the quick reply! Seriously! I appreciate any help

 

[amw_drizz]

Cory, I just joined, and cant beleive the services x10 offers for free or for the placement of ad(s) on the site for use, love it. great job. wish i caught this thread and your other one earlier to lend you a hand with MySQL, but any ETA when fantastico will be working again?

See for me dialup + uploading a 10 meg sub site for support/forums/etc takes a long time.

And dont flame me about dialup, its all i got here and i am dealing with it. (and to answer any questions) i cant get hispeed out here unless i drop over $1500 for either sat or a dedicated t1 install, (both are the same for install just different monthly payments) so it is out of the question.

 

[sonicsshadow]

I'm using phpbb, what do I do with the mysql.x10hosting.com?

 

[knutico]

u cant do nothin intil http is back up, and yeah, what to do in case of phpbb3?

 

[crazywhite1989]

I'm using phpbb, what do I do with the mysql.x10hosting.com?

u cant do nothin intil http is back up, and yeah, what to do in case of phpbb3?

1. Open up Cpanel
2. Remote MySQL
3. stoli.x10hosting.com as a host name
(If you haven't done this, cory said it improved mysql or something like that )

For phpBB3, you need to manually change the host name

1. Open up FTP
2. Go to your phpBB3 config.php
3. change $dbhost = 'localhost'; to $dbhost = 'mysql.x10hosting.com';
(I don't know if it's the same for phpBB2)

 

[Corey]

I had to modify some things with Apache, it crashed. It should be online and working now.

 

[sonicsshadow]

1. Open up Cpanel
2. Remote MySQL
3. stoli.x10hosting.com as a host name
(If you haven't done this, cory said it improved mysql or something like that )

For phpBB3, you need to manually change the host name

1. Open up FTP
2. Go to your phpBB3 config.php
3. change $dbhost = 'localhost'; to $dbhost = 'mysql.x10hosting.com';
(I don't know if it's the same for phpBB2)

Thank you very much.
It is the same on PHPBB2 by the way .

 

[pirata7z]

how can i change the database hostname from localhost to 'mysql.x10hosting.com' (im using smf forums)

 

[cooljais]

thx for the update but my MySQL still shows offline , even after changing to remote SQL?

 

[G0ssam3r]

This is wonderful and stuff but i have no clue where to edit the 'localhost' in my script i use Nuke Platinum...Yes Im still a complete noob at this...

 

[Jamesy]

I did all of what you said to do, but I am getting the following errors.

For my PhpBB Forum.

SQL ERROR
 
Unknown MySQL server host 'mysql.x10hosting.com ' (3) [2005]
 
An sql error occurred while fetching this page.

For my Wordpress

I justed edited wp-config.php and it worked =/

 

[mr kennedy]

wow I should do a tut on this if i have the time

 

[cooljais]

i dont know why but the scripts on my IPB are not working, can you help me fix them??

 

[mr kennedy]

i dont know why but the scripts on my IPB are not working, can you help me fix them??

http://forums.x10hosting.com/free-hosting/42260-mysql-problems-stoli-follow-tutorial.html#post248930

 

[ghosty]

how can i change the database hostname from localhost to 'mysql.x10hosting.com' (im using smf forums)

Easy..

With cPanel, use 'Legacy File Manager' or 'File Manager'. Select the 'Web Root (public_html/www)' directory and click 'Go'. (for this tut i'll be using Legacy File Manager)

In the page that opens, scroll down and find 'Settings.php'.
Click on the name and on the right hand side a pane will now give you all kinds of different options.
Click on.. 'Edit File With Code Editor'
A new page will now open that you can edit
In that page (it should be on line 39 and 40) find this....

########## Database Info ##########
$db_server = 'localhost';

Now simply change the 'localhost' to 'mysql.x10hosting.com' like this...

########## Database Info ##########
$db_server = 'mysql.x10hosting.com';

Lastly, at the top of the page, click the 'Save Changes' button and...
Voila! That's all.

 

[mr kennedy]

Easy..

With cPanel, use 'Legacy File Manager' or 'File Manager'. Select the 'Web Root (public_html/www)' directory and click 'Go'. (for this tut i'll be using Legacy File Manager)

In the page that opens, scroll down and find 'Settings.php'.
Click on the name and on the right hand side a pane will now give you all kinds of different options.
Click on.. 'Edit File With Code Editor'
A new page will now open that you can edit
In that page (it should be on line 39 and 40) find this....

########## Database Info ##########
$db_server = 'localhost';

Now simply change the 'localhost' to 'mysql.x10hosting.com' like this...

########## Database Info ##########
$db_server = 'mysql.x10hosting.com';

Lastly, at the top of the page, click the 'Save Changes' button and...
Voila! That's all.

I'm definitely gonna link that! thanks

 

[ghosty]

I'm definitely gonna link that! thanks

That'll be cool, go for it! :biggthump

 

[Dazz]

Nice one for all the updating going on at the moment but I followed your instructions and well

1. Added to remote sql - ok
2. Tried to change script through fantastico - cant access mysql
3. Downloaded config.php through ftp, altered local host to the new remote
4 uploaded new config.php file through ftp

From the instructions given, this should have worked but im getting this error instead -

Fatal error: Call to undefined function wp() in /home/daz*****/public_html/wp-blog-header.php on line 18

I have wordpress installed on my site and this is what Im trying to sort out.

Any help is greatly appreciated ;-)

EDIT - Don't worry, it turns out it was my fault lol, for one I accidently copied and pasted an extra ' , and two I edited my config.php file with notepad instead of notepad2 and so lost all the formatting when I saved it lol. Managed to re-build it though and working fine now. Thanks ;-)