MySQL Problems on Stoli? Follow this tutorial!

[mr kennedy]

Hey what's up guys? I had some free time today and I just created this tutorial for all the people that are on the stoli server.

WARNING! HUGE RESOLUTION: 1280x1800!

http://img456.imageshack.us/img456/2798/stolimysqlguidesy6.png

Tutorial for popular scripts:

BIG Thanks to misioooo for this

1. Login to your cPanel
2. Do my tutorial for MySql on my first post.
3. Go to your File manager
4. Go to your PHPBB2's Installation folder
5. find config.php and edit it
6. replace localhost with mysql.x10hosting.com
7. save

1. Login to your cPanel
2. Do my tutorial for MySql on my first post.
3. Go to your File manager
4. on file manager, go to your Joomla's installation folder
5. find your configuration.php on your Joomla's installation folder and click edit.
6. find this:

$mosConfig_host = 'localhost';	// This is normally set to localhost

7. Replace 'localhost' with 'mysql.x10hosting.com'
8. Save and see if your Joomla! works

1. Login to your cPanel
2. Do my tutorial for MySql on my first post.
3. Go to your File manager
4. On File manager, go to your vBulletin's Installation folder
5. go to 'Includes'
6. find config.php and click edit
7. find:

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

8. change localhost to mysql.x10hosting.com
9. save

more to come

BIG Thanks to ghosty for this (original post)

1. Login to your cPanel
2. Do my tutorial for MySql on my first post.
3. Go to your File manager
4. On File manager, go to your SMF's Installation folder
5. Find Settings.php and click edit
6. Find:

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

7. Replace:

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

8. Save

1. Login to your cPanel
2. Do my tutorial for MySql on my first post.
3. Go to your File manager
4. On File manager, go to your Wordpress' Installation folder
5. Find wp-config.php and click edit
6. Find

define('DB_HOST', 'localhost');

7. Replace with

define('DB_HOST', 'mysql.x10hosting.com');

8. Save

1. Login to your cPanel
2. Do my tutorial for MySql on my first post.
3. Go to your File manager
4. On File manager, go to your ZenCart's Installation folder
5. Go to directory '/admin/includes'.
6. find 'dist-configure.php' and click edit.
7. find:

  define('DB_SERVER', 'localhost');

8. Replace with 'mysql.x10hosting.com' and save.
9.Go back up to your public_html folder
10. go to folder '/includes/'
11. find 'dist-configure.php' and click edit.
12. find:

  define('DB_SERVER', 'localhost');

13. Replace with 'mysql.x10hosting.com' and save.
______________________________________________________________
Hey, If any of you guys can make tuts for editing config files of popular scripts like WordPress and PHPBB and SMF and etc etc, you can help the guys on stoli by creating a tut on how so that we can compile it with a common config editing index.

P.S.: I am dgenx210

Feedbacks are very warmly welcome

EDIT: Ok I am willing to provide support BUT PLEASE PLEASE, browse the whole thread before asking another question

Thank you

 

[casnet]

Hi there

How do I edit scripts. I used fantastico to install my joomla.

 

[mr kennedy]

ok. I'll try to find out and reply with the answer as soon as I find it

 

[misioooo]

You can use File Manager in cPanel. Right-click on file to edit and select Edit
In case of phpBB2 you must edit file config.php in main forum directoery. Just replace localhost with mysql.x10hosting.com

I did it like tutorial said - and guess what - my forum now works! Thanks for this tutorial

 

[mr kennedy]

no problem, and I'm linking your post for PHPBB2

 

[casnet]

thanks
Edit:
is mysql still down

 

[mr kennedy]

why? it's not working?

 

[casnet]

Never mind it is working now, thanks for the help

 

[JustBringIt]

Wow man thanks for this tutorial. I was having a problem accesing my DB but now its all fixed. Thank you very much

 

[mr kennedy]

my pleasure

 

[Jarryd]

Nice tutorial, should have been posted in off-topic or tutorials section i believe though.

 

[Livewire]

Nice tutorial, should have been posted in off-topic or tutorials section i believe though.

While that might've been where it shoulda gone, it actually is doing its job quite well posted in Free Hosting as well - mine was giving a DB problem and I saw this topic when I was hunting around to see if it was just me XD

In any case this oughta get stickied then reposted by a mod in tutorials as well (maybe site management, assuming Corey doesn't post something like this in Server Alerts anyways).


And it's times like this that I'm glad that even though my php code is the ugliest monstrosity I've ever had the displeasure of having to debug, that I was smart enough to put the mysql login's in their own includes (mostly for ease of transfer between localhost and x10, cause the login's were different). Made it a quick fix once I followed the tutorial to get the cpanel side of it working


Thanks much!

 

[Alohran]

A billion thanks on the tutorials , i was missing quite a silly detail xD.

 

[kemraj]

this is my config on phpbb4 rc 8

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysqli';
$dbhost = '';
$dbport = '';
$dbname = 'can't tell you this';
$dbuser = 'can't tell you this';
$dbpasswd = 'can't tell you this';

$table_prefix = 'php';
$acm_type = 'file';
$load_extensions = '';

@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>

as you can see their is no part of this file write local host could you tell me where it has to go please

 

[GamingX]

Nice tutorial. The SMF came in useful for me. Have anything for Joomla?

 

[powersports]

O M F G !!!

You saved my life, when i saw that my site was f'd up I allmost freaked because I needed it for a semester project!!! THANK YOU SO MUCH!!!

THANK YOU!!!

YOUR A GENIUS!!!

HAHAHHAh!!! it works again!!!

 

[Christopher]

Sticked since this is very helpful.
Thanks!

 

[xHitmanx]

Thanks for this man. Now my SMF works right.

 

[Garlund]

Hey everyone, my MySQL is still offline. Been this way all day. I followed every trouble shooting step provided on this thread and the one created by Corey on what to do with going to the remote mysql and adding stoli.x10hosting.com, and changing 'localhost' to 'mysql.x10hosting.com'. Still saying MySQL offline. I don't wanna sound demanding, I totally appreciate free hosting ^_^ ; and Corey is da man! But I'm really stomped. If anyone has any other suggestions please let me know. Any troubleshooting will be greatly appreciated and followed 100%. Knowing me, its either my bad luck or my stupidity wned:.

Also, if I posted this in the wrong area, I want to appologize in advance Honest mistake.

Thanks again! x10hosting is the best!
Edit:
I'm sitting here thinking of stuff that I may need to do and I thought about this:

Should I delete my current database and username, then start over again?

Maybe this is why I still offline.... I'll try and post the outcome.
Edit:
Nope.... Didn't work...

 

[Corey]

You tried creating a new database and it still does not work?

Note: MySQL will appear offline until we update our status scripts to check the remote server.