JLBN – Windows Apache MySQL PHP – WAMP
WAMP stands for Windows, Apache, MySQL, and PHP. There are a lot of useful WAMP package out there and WampServer is one of the most easy to use and pack with very useful trayicon to manage your server and its settings.
WampServer is a Windows web development environment. It allows you to create web applications with Apache, PHP and the MySQL database. It also comes with PHPMyAdmin and SQLiteManager to easily manage your databases. WampServer installer installs automatically, and its usage is very intuitive. You will be able to tune your server without even touching the setting files.
WampServer is the only packaged solution that will allow you to reproduce your production server. Once WampServer is installed, you have the possibility to add as many Apache, MySQL and PHP releases as you want.
i am trying to set the mysqladmin utilties:
mysqladmin -u root password “mypassword”
it was successful.
but the following command doesn’t work there.
mysqladmin -u root -h localhost password “mypassword”
on the screen:
mysqladmin: connect to server at ‘localhost’ failed
error: Access denied for user ‘root’@’localhost’ (using password:NO)
what is the error there are?
iniyarajakumari, download resetmysql here
http://downloads.jlbn.net/
to setup password, follow this
http://blog.jlbn.net/?p=17
Thanx…
no any forums help me right now…
please send me your exact email address.
iniyarajakumari
iniyarajakumari, you can get that information through our Contacts page 😉
hello,
I am doing my final year project on wamp.
I have an ADMIN PAGE and INDEX PAGE problem on my project. These two pages were in looping i.e., the same page displays again and again. Please tell me what are the errors there are? The project wants the administrator name and password in the admin page and the user name and its password in the index page. What are the errors i having in my project?
iniyarajakumari
iniyarajakumari, it’s mostly in your script but hard to say what part is wrong when not seeing the script 😉 and please, do not post the whole script here but you can either consult help from some coding forums or email us the script and we will take a look for you 😉
Good tutorial
Does anyone know how to make WAMP work with osCommerce?
Everything has just been done as described in this tutorial but when calling my oscommerce index.php like htt;/localhost/oscshop I get this error?
//Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, bla bla bla…//
Everything runs OK, db is set up, .htaccess rewrite rules are the same, … I haven’t a clue what causes a “misconfiguration” since all apps seem to run smooth.
Any ideas would be greatly appreciated.
PS: Yes I did register with the forum but I can’t login and trying to register I’m told I am already registered and NO – I never received a confirmation or validation email !?!?
Mitch, to setup osCommerce, follow this
http://blog.jlbn.net/?p=114
Thanks it was just that there was no www\logs file! now it works!
I also put /VirtualHost after each but didn’t get posted above
Janie, to post codes online, use our Online Code Converter
For your error, do you have folder logs in folder www? Also make sure to enclose path with double quote as seen in example posted above
Thanks JL. I have checked everything again and still no luck. My original blog is in the www folder so I did the following – Create a folder www/domain.
Made sure no space in httpd.com after removing #
put following in httpd-hosts.conf
ServerName domain
DocumentRoot C:/wamp/www/domain
ServerName localhost
DocumentRoot C:/wamp/www
ErrorLog C:/wamp/www/logs/error.log
CustomLog C:/wamp/www/logs/access.log common
Also tried it with ” around DocumentRoot as per your example in comment above.
Added
127.0.0.1 localhost
127.0.0.1 domain
to hosts file
Restarted WAMP – the speedo icon is still yellow & I can’t access localhost.
Do you think this has something to do with the fact my first blog is installed in localhost?
Thanks again,
janie
I have Wampserver working well on my Vista PC to design a WordPress blog. I tried to use the instruction to set up VH so i could have a second blog. Now when I start WAMPserver I can’t access localhost anymore & the speedo icon is half yellow.
I have one blog already installed in the www folder already, then set up another folder called www\domain and made the changes (excluding the subdomain instructions)
Do you know what might be happening? Do I need to move my current blog to a domain too?
Thanks!
Janie, if your wamp can’t start after enable VH, you might forgot to create folder logs in 1 of your VH folder as mentioned in step 2 or you might have blank space as mentioned in step 3
Anyway, if you want to setup wordpress, you don’t need the log files for them, so you can omit those lines for logs, for example
NameVirtualHost *:80
<VirtualHost *:80>
ServerName wordpress1
DocumentRoot "C:/wamp/www/wordpress1"
</VirtualHost>
<VirtualHost *:80>
ServerName wordpress2
DocumentRoot "C:/wamp/www/wordpress2"
</VirtualHost>
well, i went into
C:\wamp\bin\mysql\mysql5.1.33\bin
and trying to config MySQLInstanceConfig.exe
but when i execute its stoped on start service box with red “X” and messege apeared,
“CANNOT CREATE WINDOWS SERVICE FOR MYSQL. ERROR 0″
zoyz, refer to this
http://bugs.mysql.com/bug.php?id=34340
Thanx for the PhpMyAdmin help, its working now but having problem with MySQL as wrote above..
I have recently downloaded Wamp 2.0h, but when i tried to configer MySql its stoped on start service and error said,
“CANNOT CREATE WINDOWS SERVICE FOR MYSQL. ERROR 0”
I have uninstalled n reinstalled about 3 times but same thing happening,
Can anyone please help me out..
Thank you.
-zoyz
zoyz, can you be a little more specific about what exactly did you try to configure MySQL?
i have recently installed WAMPSERVER 2.0h but when i clicked on phpmyadmin the error poped,
“You don’t have permission to access /phpmyadmin/ on this server.”
can anyone help me out with this issue please..
zoyz, open phpmyadmin.conf file and make sure the path is correct
Thank You… always smile
GREAT !!!!
But I had to customize the VirtualHost Setting to make it work with my Intranet:
ServerName http://www.domain.com
ServerAlias domain.com domain
DocumentRoot C:/wamp/www/domain
ErrorLog C:/wamp/www/domain/logs/error.log
CustomLog C:/wamp/www/domain/logs/access.log common
Options FollowSymLinks
AllowOverride None
Order deny,allow
Allow for all
I am having trouble with getting an account on your site for the forum.
Can you help
Chuck
Chuck, please send detail problem to contact@wampserver.com
Thanks for the reply 🙂
Seems I did the myISAM yes.
I also have a full backup of my wamp folder.
So……
I can go ahead and install latest wamp over the top of my existing installation?
Then,replace the 3 files I have changed and…..
“For database, copy the associated folder in Backups/wamp/bin/mysql/mysql5.0.xx/data to overwrite that same folder name in C:/wamp/bin/mysql/mysql5.0.xx/data folder” ?
Is that the FULL data folder or just the ‘my database name’ folder?
Sorry,I am really quite new to all of this and have no idea of mysql/phpmyadmin console commands.
Many Thanks
when upgraded, it should work w/o any modifying; backup just for safety than sorry 😉
anyway, don’t overwrite mysql folder in data folder
Hi JL and everyone 🙂
1st of all many thanks for these guides.
Now to my dilema….
I’m not sure what version of wamp I’m running.
So when I find out I probably will need to update/upgrade.
With your guides I’ve been online for quite awhile,I also run a Forum through my wamp.
If I download the latest wamp can I just install over the top?
I’m thinking yes BUT I think it will also overwrite the files I have already changed.
It has been ages since I changed the files and cannot remember which files I changed through the help of your guides?
Which files will I need to keep/copy and then replace once I’ve updated wamp?
Many Thanks
sTimulated, if you’ve already followed our backup guide here, you should already have all backups, so you only need to backup additional files such as vhosts if not setup auto sync as shown in backup guide here; however, don’t try to switch db type if already had or you will lose your current db, but use either mysql consol or phpmyadmin to backup/export then restore/import db after wamp upgraded; remember, you can only upgrade if already had wamp2.x, so check here for version changes
Correction
NameVirtualHost *:80
ServerName http://www.xronex.com
ServerAlias xronex.com domain
DocumentRoot C:/wamp/www/domain
ErrorLog C:/wamp/www/logs/xronex_error.log
CustomLog C:/wamp/www/logs/xronex_access.log common
ServerName video.xronex.com
ServerAlias video
DocumentRoot D:/My Video
ErrorLog C:/wamp/www/logs/video_error.log
CustomLog C:/wamp/www/logs/video_access.log common
ServerName music.xronex.com
ServerAlias music
DocumentRoot D:/My Music
ErrorLog C:/wamp/www/logs/music_error.log
CustomLog C:/wamp/www/logs/music_access.log common
ServerName forum.xronex.com
ServerAlias forum
DocumentRoot C:/wamp/www/forum
ErrorLog C:/wamp/www/logs/forum_error.log
CustomLog C:/wamp/www/logs/forum_access.log common
ServerName mail.xronex.com
ServerAlias mail
DocumentRoot C:/wamp/www/mail
ErrorLog C:/wamp/www/logs/mail_error.log
CustomLog C:/wamp/www/logs/mail_access.log common
ServerName localhost
DocumentRoot C:/wamp/www
ErrorLog C:/wamp/www/logs/error.log
CustomLog C:/wamp/www/logs/access.log common
NameVirtualHost *:80
ServerName http://www.xronex.com
ServerAlias xronex.com domain
DocumentRoot C:/wamp/www/domain
ErrorLog C:/wamp/www/logs/xronex_error.log
CustomLog C:/wamp/www/logs/xronex_access.log common
ServerName video.xronex.com
ServerAlias video
DocumentRoot D:/My Video
ErrorLog C:/wamp/www/logs/video_error.log
CustomLog C:/wamp/www/logs/video_access.log common
ServerName music.xronex.com
ServerAlias music
DocumentRoot D:/My Music
ErrorLog C:/wamp/www/logs/music_error.log
CustomLog C:/wamp/www/logs/music_access.log common
ServerName forum.xronex.com
ServerAlias forum
DocumentRoot C:/wamp/www/forum
ErrorLog C:/wamp/www/logs/forum_error.log
CustomLog C:/wamp/www/logs/forum_access.log common
ServerName mail.xronex.com
ServerAlias mail
DocumentRoot C:/wamp/www/mail
ErrorLog C:/wamp/www/logs/mail_error.log
CustomLog C:/wamp/www/logs/mail_access.log common
ServerName localhost
DocumentRoot C:/wamp/www
ErrorLog C:/wamp/www/logs/error.log
CustomLog C:/wamp/www/logs/access.log common
I have follow all instruction…but after I restart Wamp server, icon is yellow and not running.
I just install wamp on my PC…
And what I realize is
In httpd.conf, Wamp is running when Im not remove # symbol
# Virtual hosts
#Include conf/extra/httpd-vhosts.conf
But when I remove # symbol, icon just yellow, Wamp is not running
# Virtual hosts
Include conf/extra/httpd-vhosts.conf
Any solution? I try follow this guide carefully so many times but it doesn’t work for me…
Im using WampServer Version 2.0h
Here my config in httpd-vhosts.conf
NameVirtualHost *:80
<
ServerName http://www.domain.com
ServerAlias domain.com domain
DocumentRoot C:/wamp/www/domain
ErrorLog C:/wamp/www/domain/logs/error.log
CustomLog C:/wamp/www/domain/logs/access.log common
<
ServerName video.xronex.com
ServerAlias video
DocumentRoot D:/My Video
ErrorLog C:/wamp/www/logs/video_error.log
CustomLog C:/wamp/www/logs/video_access.log common
<
ServerName music.xronex.com
ServerAlias music
DocumentRoot D:/My Music
ErrorLog C:/wamp/www/logs/music_error.log
CustomLog C:/wamp/www/logs/music_access.log common
<
ServerName forum.xronex.com
ServerAlias forum
DocumentRoot C:/wamp/www/forum
ErrorLog C:/wamp/www/logs/forum_error.log
CustomLog C:/wamp/www/logs/forum_access.log common
<
ServerName mail.xronex.com
ServerAlias mail
DocumentRoot C:/wamp/www/mail
ErrorLog C:/wamp/www/logs/mail_error.log
CustomLog C:/wamp/www/logs/mail_access.log common
ServerName localhost
DocumentRoot C:/wamp/www
ErrorLog C:/wamp/www/logs/error.log
CustomLog C:/wamp/www/logs/access.log common
How to connect to share drive on network?
This is quoted from step 2
This is quoted from step 3
Please, check these two and also, did you setup dns for all those (sub)domains yet? if not, follow this
Setup DNS