Shoutbox

How do you reset port 3306? - Printable Version

-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: Skype & Technology (/forumdisplay.php?fid=9)
+---- Forum: Tech Talk (/forumdisplay.php?fid=17)
+----- Thread: How do you reset port 3306? (/showthread.php?tid=78943)

How do you reset port 3306? by Quantum on 11-11-2007 at 11:27 AM

How do you reset port 3306 so theres not data on it? Also make shure that its only mysql thats running via it nothing else?



I am trying to set-up another webserver and when i click start mysql/apache it just starts then stops.

[Image: attachment.php?pid=861692]
RE: How do you reset port 3306? by ShawnZ on 11-11-2007 at 11:48 AM

how the fuck do you "reset" a stream? do you wash out your network cables so there's no ones or zeros in them, too?


RE: How do you reset port 3306? by Quantum on 11-11-2007 at 11:49 AM

quote:
Originally posted by ShawnZ
how the fuck do you "reset" a stream? do you wash out your network cables so there's no ones or zeros in them, too?

Calm down. Well how do i clear it?
RE: How do you reset port 3306? by ShawnZ on 11-11-2007 at 11:50 AM

quote:
Originally posted by john-t
quote:
Originally posted by ShawnZ
how the fuck do you "reset" a stream? do you wash out your network cables so there's no ones or zeros in them, too?

Calm down. Well how do i clear it?

did you miss my entire post or something?
RE: How do you reset port 3306? by Quantum on 11-11-2007 at 12:07 PM

In the screen shot  i posted you can see that apache and mysql is not running. When i click start nothing happens. In the staus box it says busy... then running (but its not)

When i try to start mysql it starts then stops.

In the mysql control panel it looks like this:

[Image: mypy4.png]


RE: How do you reset port 3306? by Underlord on 11-11-2007 at 12:17 PM

http://www.apachefriends.org/f/viewtopic.php?p=109486
http://www.php-editors.com/forums/apache-help/498...-apache-xampp.html
http://www.apachefriends.org/f/viewtopic.php?p=108970


RE: How do you reset port 3306? by Quantum on 11-11-2007 at 12:39 PM

Got it! Thanks guys!

What happened was i was testing XAMP lite and ran MySql and apache from there and it block the other XAMP.

is it better to run things as a service or normal?


RE: How do you reset port 3306? by Underlord on 11-11-2007 at 12:42 PM

A service would be preferable if it's always on.


RE: How do you reset port 3306? by Quantum on 11-11-2007 at 12:58 PM

Ok. I cant find how to turn safe mode on (php) anyone know were. I am using XAMMP for windows. php5+++

Thanks,


RE: How do you reset port 3306? by -dt- on 11-11-2007 at 01:53 PM

quote:
Originally posted by john-t
Ok. I cant find how to turn safe mode on (php) anyone know were. I am using XAMMP for windows. php5+++

Thanks,
you don't want to. Leave it off
RE: How do you reset port 3306? by Quantum on 11-11-2007 at 01:58 PM

I do.

Also when i open a php file on my pc i get:

code:

$comments_number); //get video rating stars ---reusable ------------------------------------------------------------------------------- $stars_array = array(); $stars_array = stars_array($video_id); //-------------------------------------------------------------------------------------------------------------------- //merge comments array and video array $result2 = @array_merge($result1, $comments_array, $stars_array); $result_featured[] = $result2; } //getrandom video to play $sql = "SELECT * FROM videos WHERE approved='yes' AND public_private = 'public' ORDER BY RAND()"; $query = @mysql_query($sql); $result = @mysql_fetch_array($query); $video_play = $result['video_id'].'.flv'; $video_thumb = $result['video_id'].'.jpg'; //show any errors/notifications if ($codes == "") {//only if page is not trying to load refer error. $codes = $codes_internal; } $error_code = errorcodes($codes); if (!empty($error_code)) { $blk_code = $error_code['error_display']; $code_type = $error_code['error_type']; $code_message = $error_code['error_message']; } //what to display when user logged in if ($loggedin ==1){ $blk_id = 0;//html table - error block $template = "templates/main_1.htm"; $inner_template1 = "templates/inner_index_2.htm";//middle of page $TBS = new clsTinyButStrong; $TBS->NoErr = true;// no more error message displayed. $TBS->LoadTemplate("$template"); $TBS->MergeBlock('mp', $recent); $TBS->MergeBlock('blkfeatured', $result_featured); $TBS->Render = TBS_OUTPUT; $TBS->Show(); @mysql_close(); die(); } $blk_id = 0;//html table - error block $template = "templates/main_1.htm"; $inner_template1 = "templates/inner_index.htm";//middle of page $TBS = new clsTinyButStrong; $TBS->NoErr = true;// no more error message displayed. $TBS->LoadTemplate("$template"); $TBS->MergeBlock('mp', $recent); $TBS->MergeBlock('blkfeatured', $result_featured); $TBS->Render = TBS_OUTPUT; $TBS->Show(); @mysql_close(); die(); ?



Whats wrong with php?
RE: How do you reset port 3306? by RoySmeding on 11-11-2007 at 02:23 PM

What are you opening it with?

If it's with your web browser, duh, it treats it as a text file. Access files through your Apache install if you want them executed.

If it's through apache already, you haven't got Apache configured to parse PHP files. Figure that one out yourself.

And if it's in Notepad, it's a file made on Linux or MacOS, which handle linebreaks in different ways. Try opening it with Wordpad or a different editor.


RE: How do you reset port 3306? by Quantum on 11-11-2007 at 03:14 PM

If i go to

ftp://localhost/home/home/index.php

i get the junk

if i go to

http://localhost/home/home/index.php

i get a 404 :S


RE: How do you reset port 3306? by RoySmeding on 11-11-2007 at 03:23 PM

Well, yeah, your FTP server doesn't process PHP, and that's not what it's meant to do, either. You also might want to password-protect FTP access.
As for HTTP, check if your server is running and if the web pages to be served are in the DocumentRoot. If you don't know what that means, look it up, we're not here to do everything for you.


RE: How do you reset port 3306? by Quantum on 11-11-2007 at 03:26 PM

FTP is protected.
Server running.
It is saved in the document root.


RE: RE: How do you reset port 3306? by Snake on 11-11-2007 at 05:36 PM

quote:
Originally posted by Underlord
http://www.apachefriends.org/f/viewtopic.php?p=109486
http://www.php-editors.com/forums/apache-help/498...-apache-xampp.html
http://www.apachefriends.org/f/viewtopic.php?p=108970

You need to read the help files...
RE: How do you reset port 3306? by Quantum on 11-11-2007 at 09:44 PM

All i want to know is were do i upload a file to?


RE: How do you reset port 3306? by Jhrono on 11-11-2007 at 11:56 PM

You should first read and search the forums for such questions. If you don't know the answer to those, I don't think you're ready to work out a webserver. You should go easy first, read the basics and then start out! :)


RE: RE: How do you reset port 3306? by rav0 on 11-13-2007 at 01:04 AM

quote:
Originally posted by john-t
If i go to

ftp://localhost/home/home/index.php

i get the junk

if i go to

http://localhost/home/home/index.php

i get a 404 :S
Maybe the paths aren't mapped like you expected. Also try
http://localhost/home/index.php
and
http://localhost/index.php
or even
http://localhost/home/home/home/home/index.php
and
http://localhost/home/home/home/index.php

Also just try using basic HTML files, once you get that working consistently then try PHP.
RE: How do you reset port 3306? by YottabyteWizard on 11-13-2007 at 04:51 PM

Locate on the php installation folder (most probably inside XAMP folder) a file called "httpd.conf" (obviously without the quotes), and open it with notepad or something. There should be something saying DocumentRoot, that's the folder apache will be serving files.

Also, for PHP in safe mode, go to your PHP installation folder (also probably inside XAMP folder), there should be a file called "php.ini". There must be a line saying SAFEMODE=    if you open this file with notepad, CTRL + F and type SAFE and search for it. The only thing you need to do is change it to ON.