Something wront with my MySQL?
Posted by: david82213 (---.bchsia.telus.net)
Date: May 16, 2008 08:06PM

HI, I am new to WampServer. I downloaded it and start. My wamp icon is 75% yellow and 25% white.
When I typed [127.0.0.1] on my browser, it just say " It Works "
But when I left click on Wamp then click on phpMyAdmin, it says "404 Not Found" on my browser.
Can anyone please help me?
Thank you.

Options: ReplyQuote
Re: Something wront with my MySQL?
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: May 16, 2008 08:19PM

just post up your mysql log.. form c:/wamp/logs /mysql


phpmyadmin should still open but not connect if mysql is not running..



so just check which serviceis running...

LEFT CLICK wamp icon, goto APACHE , APACHE SERVICE, and see if START/RESUME SERVICE is clickable or greyed out

then do the same for MYSQL, MYSQL SERVICE, and see if START/RESUME SERVICE is clickable or greyed out

which ever is grey is the one that IS running


which ever is clickable is the one that IS NOT running

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: Something wront with my MySQL?
Posted by: yfastud (Moderator)
Date: May 16, 2008 09:30PM

You have to disable IIS since IIS and apache/wamp are both web server and both use port 80, so you have to disable IIS in order for wamp to work

Disable IIS in Vista:

Uninstall Programs, Turn Widows Features On or Off, uncheck Internet Information Services

Disable IIS in XP:

Add/Remove Programs, Add/Remove Windows Components, uncheck Internet Information Services (IIS)

Restart computer, then restart wamp

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: Something wront with my MySQL?
Posted by: david82213 (---.bchsia.telus.net)
Date: May 16, 2008 10:15PM

right now. only MySQL is not working.
Here is the mysql log:
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
080516 10:23:03 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080516 10:23:04 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080516 10:23:04 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
080516 10:23:05 InnoDB: Started; log sequence number 0 0
080516 10:23:05 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080516 10:23:05 [ERROR] Aborting

080516 10:23:05 InnoDB: Starting shutdown...
080516 10:23:07 InnoDB: Shutdown completed; log sequence number 0 43655
080516 10:23:07 [Note] wampmysqld: Shutdown complete

080516 10:23:27 InnoDB: Started; log sequence number 0 43655
080516 10:23:27 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080516 10:23:27 [ERROR] Aborting

080516 10:23:27 InnoDB: Starting shutdown...
080516 10:23:29 InnoDB: Shutdown completed; log sequence number 0 43655
080516 10:23:29 [Note] wampmysqld: Shutdown complete

080516 10:23:36 InnoDB: Started; log sequence number 0 43655
080516 10:23:36 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080516 10:23:36 [ERROR] Aborting

080516 10:23:36 InnoDB: Starting shutdown...
080516 10:23:38 InnoDB: Shutdown completed; log sequence number 0 43655
080516 10:23:38 [Note] wampmysqld: Shutdown complete

080516 10:32:31 InnoDB: Started; log sequence number 0 43655
080516 10:32:31 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080516 10:32:31 [ERROR] Aborting

080516 10:32:31 InnoDB: Starting shutdown...
080516 10:32:34 InnoDB: Shutdown completed; log sequence number 0 43655
080516 10:32:34 [Note] wampmysqld: Shutdown complete

080516 10:36:38 InnoDB: Started; log sequence number 0 43655
080516 10:36:38 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080516 10:36:38 [ERROR] Aborting

080516 10:36:38 InnoDB: Starting shutdown...
080516 10:36:40 InnoDB: Shutdown completed; log sequence number 0 43655
080516 10:36:40 [Note] wampmysqld: Shutdown complete

080516 10:37:20 InnoDB: Started; log sequence number 0 43655
080516 10:37:20 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080516 10:37:20 [ERROR] Aborting

080516 10:37:20 InnoDB: Starting shutdown...
080516 10:37:23 InnoDB: Shutdown completed; log sequence number 0 43655
080516 10:37:23 [Note] wampmysqld: Shutdown complete

080516 10:39:18 InnoDB: Started; log sequence number 0 43655
080516 10:39:18 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080516 10:39:18 [ERROR] Aborting

080516 10:39:18 InnoDB: Starting shutdown...
080516 10:39:20 InnoDB: Shutdown completed; log sequence number 0 43655
080516 10:39:20 [Note] wampmysqld: Shutdown complete

080516 10:39:33 InnoDB: Started; log sequence number 0 43655
080516 10:39:33 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080516 10:39:33 [ERROR] Aborting

080516 10:39:33 InnoDB: Starting shutdown...
080516 10:39:35 InnoDB: Shutdown completed; log sequence number 0 43655
080516 10:39:35 [Note] wampmysqld: Shutdown complete

080516 10:43:31 InnoDB: Started; log sequence number 0 43655
080516 10:43:31 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080516 10:43:31 [ERROR] Aborting

080516 10:43:31 InnoDB: Starting shutdown...
080516 10:43:34 InnoDB: Shutdown completed; log sequence number 0 43655
080516 10:43:34 [Note] wampmysqld: Shutdown complete

080516 10:45:33 InnoDB: Started; log sequence number 0 43655
080516 10:45:33 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080516 10:45:33 [ERROR] Aborting

080516 10:45:33 InnoDB: Starting shutdown...
080516 10:45:36 InnoDB: Shutdown completed; log sequence number 0 43655
080516 10:45:36 [Note] wampmysqld: Shutdown complete

080516 10:50:03 InnoDB: Started; log sequence number 0 43655
080516 10:50:03 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080516 10:50:03 [ERROR] Aborting

080516 10:50:03 InnoDB: Starting shutdown...
080516 10:50:06 InnoDB: Shutdown completed; log sequence number 0 43655
080516 10:50:06 [Note] wampmysqld: Shutdown complete

080516 13:09:40 InnoDB: Started; log sequence number 0 43655
080516 13:09:40 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080516 13:09:40 [ERROR] Aborting

080516 13:09:40 InnoDB: Starting shutdown...
080516 13:09:43 InnoDB: Shutdown completed; log sequence number 0 43655
080516 13:09:43 [Note] wampmysqld: Shutdown complete

080516 13:10:33 InnoDB: Started; log sequence number 0 43655
080516 13:10:33 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080516 13:10:33 [ERROR] Aborting

080516 13:10:33 InnoDB: Starting shutdown...
080516 13:10:35 InnoDB: Shutdown completed; log sequence number 0 43655
080516 13:10:35 [Note] wampmysqld: Shutdown complete

080516 13:11:33 InnoDB: Started; log sequence number 0 43655
080516 13:11:33 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080516 13:11:33 [ERROR] Aborting

080516 13:11:33 InnoDB: Starting shutdown...
080516 13:11:36 InnoDB: Shutdown completed; log sequence number 0 43655
080516 13:11:36 [Note] wampmysqld: Shutdown complete


@yfastud
My Internet Information Services (IIS) is already unchecked.

Options: ReplyQuote
Re: Something wront with my MySQL?
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: May 16, 2008 10:22PM

well u may have iiis unchecked but you have another copy of mysql installed.



simple solution is to open my.ini file in c:/wamp/bin/mysql/mysql5.0.45 and change port =3306 to 3307. it is written 3 times in the file


the best solution is to delete the other mysql

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: Something wront with my MySQL?
Posted by: david82213 (---.bchsia.telus.net)
Date: May 16, 2008 10:30PM

Yay! Its working now.
Thank you so much!
I used the simple solution.
I dont get where to delete the other mysql. xD

Oh. and one more question >"<
I put php files into C:\wamp\www
Now, I can see my website.
So, how can I make it public so everyone can see?



Edited 1 time(s). Last edit at 05/16/2008 10:36PM by david82213.

Options: ReplyQuote
Re: Something wront with my MySQL?
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: May 16, 2008 10:45PM

search in windows for mysql.... all wamps files are contained in wamp folder .. so you should see where the other mysql is stored,,


follow my guide here to get your site on the web. >>> [pampserver.com]


if you have your own domain name then dont use no-ip and instead goto www.freedns.org

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: Something wront with my MySQL?
Posted by: david82213 (---.bchsia.telus.net)
Date: May 17, 2008 06:13AM

thank you so much.
ur guide is very helpful. ^^

Options: ReplyQuote
Re: Something wront with my MySQL?
Posted by: yfastud (Moderator)
Date: May 17, 2008 06:14AM

Quote

I used the simple solution.
I dont get where to delete the other mysql. xD
Did you try to create simple db and use a simple php to connect to that db? Since you changed port for mysql, php might not able to find db :-(

Here are some tutor guides for publish your website
[guides.jlbn.net]
[guides.jlbn.net]

By the way, if you only use wamp for developing, change port 80 to something else is ok, but try to avoid to change port 80 if you want your website to be access worldwide because you will lose a lot of visitors since most people don't know what is the port to type w/ your website address while other people will feel very annoying to type in the port in order to visit your website :-(

Personally, I've changed ISP more than 3 times just because they block port 80 ;-)

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides



Edited 1 time(s). Last edit at 05/17/2008 06:24AM by yfastud.

Options: ReplyQuote
Re: Something wront with my MySQL?
Posted by: david82213 (---.bchsia.telus.net)
Date: May 18, 2008 12:25AM

thank you for your awesome answer.
now I fixed my MySQL problem, but I found out my Apache isnt running now!
75% yellow 25% white. MySQL is running, Apache isnt.
>"< How to fix this? Sorry, I am new to this. T_T

Options: ReplyQuote
Re: Something wront with my MySQL?
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: May 18, 2008 12:28AM

what have you changed? post up your apche error log found at c:/wamp/logs


btw what yfastud sed about port 80 is not true... u dont need to add the port to the end when u use no-ip or freedns..

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: Something wront with my MySQL?
Posted by: david82213 (---.bchsia.telus.net)
Date: May 18, 2008 12:37AM

[Fri May 16 10:45:32 2008] [notice] Apache/2.2.8 (Win32) PHP/5.2.6 configured -- resuming normal operations
[Fri May 16 10:45:32 2008] [notice] Server built: Jan 18 2008 00:37:19
[Fri May 16 10:45:32 2008] [notice] Parent: Created child process 3480
[Fri May 16 10:45:32 2008] [notice] Child 3480: Child process is running
[Fri May 16 10:45:32 2008] [notice] Child 3480: Acquired the start mutex.
[Fri May 16 10:45:32 2008] [notice] Child 3480: Starting 64 worker threads.
[Fri May 16 10:45:32 2008] [notice] Child 3480: Starting thread to listen on port 8484.
[Fri May 16 10:50:00 2008] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Fri May 16 10:50:00 2008] [notice] Child 3480: Exit event signaled. Child process is ending.
[Fri May 16 10:50:01 2008] [notice] Child 3480: Released the start mutex
[Fri May 16 10:50:02 2008] [notice] Child 3480: All worker threads have exited.
[Fri May 16 10:50:02 2008] [notice] Child 3480: Child process is exiting
[Fri May 16 10:50:02 2008] [notice] Parent: Child process exited successfully.
[Fri May 16 10:50:02 2008] [notice] Apache/2.2.8 (Win32) PHP/5.2.6 configured -- resuming normal operations
[Fri May 16 10:50:02 2008] [notice] Server built: Jan 18 2008 00:37:19
[Fri May 16 10:50:02 2008] [notice] Parent: Created child process 2548
[Fri May 16 10:50:03 2008] [notice] Child 2548: Child process is running
[Fri May 16 10:50:03 2008] [notice] Child 2548: Acquired the start mutex.
[Fri May 16 10:50:03 2008] [notice] Child 2548: Starting 64 worker threads.
[Fri May 16 10:50:03 2008] [notice] Child 2548: Starting thread to listen on port 8484.
[Fri May 16 11:27:45 2008] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Fri May 16 11:27:45 2008] [notice] Child 2548: Exit event signaled. Child process is ending.
[Fri May 16 11:27:46 2008] [notice] Child 2548: Released the start mutex
[Fri May 16 11:27:47 2008] [notice] Child 2548: All worker threads have exited.
[Fri May 16 11:27:47 2008] [notice] Child 2548: Child process is exiting
[Fri May 16 11:27:47 2008] [notice] Parent: Child process exited successfully.
[Fri May 16 13:11:32 2008] [notice] Apache/2.2.8 (Win32) PHP/5.2.6 configured -- resuming normal operations
[Fri May 16 13:11:32 2008] [notice] Server built: Jan 18 2008 00:37:19
[Fri May 16 13:11:32 2008] [notice] Parent: Created child process 2524
[Fri May 16 13:11:32 2008] [notice] Child 2524: Child process is running
[Fri May 16 13:11:32 2008] [notice] Child 2524: Acquired the start mutex.
[Fri May 16 13:11:32 2008] [notice] Child 2524: Starting 64 worker threads.
[Fri May 16 13:11:32 2008] [notice] Child 2524: Starting thread to listen on port 80.
[Fri May 16 13:29:49 2008] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Fri May 16 13:29:49 2008] [notice] Child 2524: Exit event signaled. Child process is ending.
[Fri May 16 13:29:50 2008] [notice] Child 2524: Released the start mutex
[Fri May 16 13:29:51 2008] [notice] Child 2524: All worker threads have exited.
[Fri May 16 13:29:51 2008] [notice] Child 2524: Child process is exiting
[Fri May 16 13:29:51 2008] [notice] Parent: Child process exited successfully.
[Fri May 16 13:29:53 2008] [notice] Apache/2.2.8 (Win32) PHP/5.2.6 configured -- resuming normal operations
[Fri May 16 13:29:53 2008] [notice] Server built: Jan 18 2008 00:37:19
[Fri May 16 13:29:53 2008] [notice] Parent: Created child process 2200
[Fri May 16 13:29:53 2008] [notice] Child 2200: Child process is running
[Fri May 16 13:29:53 2008] [notice] Child 2200: Acquired the start mutex.
[Fri May 16 13:29:53 2008] [notice] Child 2200: Starting 64 worker threads.
[Fri May 16 13:29:53 2008] [notice] Child 2200: Starting thread to listen on port 80.
[Sat May 17 09:02:15 2008] [warn] pid file C:/wamp/bin/apache/apache2.2.8/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Sat May 17 09:02:15 2008] [notice] Apache/2.2.8 (Win32) PHP/5.2.6 configured -- resuming normal operations
[Sat May 17 09:02:15 2008] [notice] Server built: Jan 18 2008 00:37:19
[Sat May 17 09:02:15 2008] [notice] Parent: Created child process 2452
[Sat May 17 09:02:15 2008] [notice] Child 2452: Child process is running
[Sat May 17 09:02:15 2008] [notice] Child 2452: Acquired the start mutex.
[Sat May 17 09:02:15 2008] [notice] Child 2452: Starting 64 worker threads.
[Sat May 17 09:02:15 2008] [notice] Child 2452: Starting thread to listen on port 8484.
[Sat May 17 09:02:57 2008] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Sat May 17 09:02:57 2008] [notice] Child 2452: Exit event signaled. Child process is ending.
[Sat May 17 09:02:58 2008] [notice] Child 2452: Released the start mutex
[Sat May 17 09:02:59 2008] [notice] Child 2452: All worker threads have exited.
[Sat May 17 09:02:59 2008] [notice] Child 2452: Child process is exiting
[Sat May 17 09:02:59 2008] [notice] Parent: Child process exited successfully.
[Sat May 17 09:06:11 2008] [notice] Apache/2.2.8 (Win32) PHP/5.2.6 configured -- resuming normal operations
[Sat May 17 09:06:11 2008] [notice] Server built: Jan 18 2008 00:37:19
[Sat May 17 09:06:11 2008] [notice] Parent: Created child process 1752
[Sat May 17 09:06:11 2008] [notice] Child 1752: Child process is running
[Sat May 17 09:06:11 2008] [notice] Child 1752: Acquired the start mutex.
[Sat May 17 09:06:11 2008] [notice] Child 1752: Starting 64 worker threads.
[Sat May 17 09:06:11 2008] [notice] Child 1752: Starting thread to listen on port 8484.
[Sat May 17 09:08:27 2008] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Sat May 17 09:08:27 2008] [notice] Child 1752: Exit event signaled. Child process is ending.
[Sat May 17 09:08:28 2008] [notice] Child 1752: Released the start mutex
[Sat May 17 09:08:45 2008] [notice] Child 1752: All worker threads have exited.
[Sat May 17 09:08:45 2008] [notice] Child 1752: Child process is exiting
[Sat May 17 09:08:45 2008] [notice] Parent: Child process exited successfully.


confused now...be back in a few hours



Edited 1 time(s). Last edit at 05/18/2008 12:38AM by david82213.

Options: ReplyQuote
Re: Something wront with my MySQL?
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: May 18, 2008 12:42AM

listen 8484? why this port??

its proabably being used...


use 80? or 81 if 80 is being used byother server

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote
Re: Something wront with my MySQL?
Posted by: david82213 (---.bchsia.telus.net)
Date: May 18, 2008 05:07AM

Thank you for answer.
Now, everything has solved. ^^

Options: ReplyQuote
Re: Something wront with my MySQL?
Posted by: yfastud (Moderator)
Date: May 18, 2008 05:25AM

Quote

btw what yfastud sed about port 80 is not true... u dont need to add the port to the end when u use no-ip or freedns..
He he... he he... ;-)
First, I meant to use it directly on user's computer and I didn't say anything about no-ip or freedns
Second, I don't use either so correct me if I'm wrong. Since they forward port, the users either have to use sub-domains such as your_domain.no-ip.com or have to pay if want to use their own domain? If it's true, either one is not very convenient, right? In additions, what if users want to have subdomains for their domains? Is it like subdomain.your_domain.no-ip.com or they don't even allow to have more than 1 url per account??? Just my 2-cent ;-)

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides



Edited 1 time(s). Last edit at 05/18/2008 06:00AM by yfastud.

Options: ReplyQuote
Re: Something wront with my MySQL?
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: May 18, 2008 07:55AM

no problem your welcome,,,




@yfastud.. noip is free so yes it works like that pretty much. but freedns allow your to use your own domain and they will forward it to all ur sud domains etc. its works perfectly and again for free,,, i do agree , its not a great solution as your urls in your code end up with :8080 and some pages end up in a frame,,, but in some locations users have no option but to go with an ISP that blocks port 80

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 1 time(s). Last edit at 05/18/2008 08:15AM by stevenmartin99.

Options: ReplyQuote


Sorry, only registered users may post in this forum.