April 19th, 2009
Tutorial : Installing Apache 2.2.11, PHP 5.3, MySQL 5.1.34 & PhpMyAdmin 3.1.4 in Windows Vista/XP
The most recent version of this tutorial has been completely re-written at WebDev Codex.
Learn how to Install PHP 5.3,
To view the latest version, Goto Screencast #1 : Installing Apache 2.2, PHP 5.3, MySQL 5.1 & PHPMyAdmin 3.2 for Windows 7/Vista
If you want to see the screencast of this tutorial, then goto
Screencast #1 : Installing Apache 2.2, PHP 5.3, MySQL 5.1 & PHPMyAdmin 3.2 for Windows 7/Vista
Not everyone would spend money online to buy webspace just so that they can test out how their latest application works, Well… Welcome to Vision Master Designs Blog. This tutorial will teach you to set up a developer environment for PHP/MySQL in your computer in no time.
Index :
- Page 1 : Introduction
- Page 2 : Create Directories & Install Apache
- Page 3 : Install PHP5 & Configure php.ini
- Page 4 : Configure Apache 2.2
- Page 5 : Installing & Configuring MySQL5
- Page 6 : Installing & Configuring PhpMyAdmin
If you are aware of the basics then Click Here to jump below, else read on.
Normally we can view HTML pages on our computer without the need of uploading them to the server, since HTML is a Client Side Language. You don`t need any extra software to view html files, just any browser will do the trick.
But if you want to make your pages dynamic using any Server Side Language (PHP,ASP,JSP) & want to the see the results then you must upload the file to the webserver which supports that language so it can execute the file & return the results on your browser
We can set up a developers environment from which you can create and execute PHP/MySQL scripts by installing the above mentioned applications.
- Apache HTTP Server (2.2.11): The best open source webserver. You need this to turn your humble computer to a powerful webserver to execute your applications.
Direct Download apache_2.2.11-win32-x86-no_ssl-r2.msi
Apache Download Page – Please Download the Win32 Binary without crypto (no mod_ssl) (MSI Installer) – apache_2.2.11-win32-x86-no_ssl.msi~ 4.3MB - PHP (5.2.9) : One of the most powerful web programming languages.
Direct Download PHP 5.2.9 -2 zip package
PHP Download Page – Download the PHP 5.2.9 – 2 Zip package ~ 10MB - MySQL (5.1.34) : One of the best DBMS packages which is free.
The latest version is 5.1.34 which is stable and used in production servers. Although MySQL 5.1 and MySQL 6 are also available as beta releases, they are not used in production servers as of now.
MySQL Download Page – Please download Windows ZIP/Setup.EXE (x86) 5.1.34 ~ 35.2MB - PhpMyAdmin (3.1.4) : Used to manage your MySQL databases directly using your web browser.
Direct Download phpMyAdmin-3.1.4-all-languages.zip
PHPMyAdmin Download Page – Please download the latest release from the 3.x rooster.
The above downloads are compatible with Windows Vista/Vista SP1 (32 bit OS).
July 25, 2008 at 6:56 pm
Hey david,
The code is perfectly fine. please check the extension of the config.inc.php
it has to config.inc.php not config.inc.php.txt or any other format.
It has to be a php file !
I really feel, that must be the error. please check that
Regards
August 6, 2009 at 7:49 pm
Works perfect on Windows Vista with Service Pack 2.
Many thanks.
September 15, 2009 at 9:12 pm
I just finished with the MySQL configuration tutorial, but I get
“Forbidden
You don’t have permission to access / on this server”
when I point to it in “http://www.myserver.dev” in the browser. Please Help.
July 25, 2008 at 5:10 pm
Hi, Michael,
I got a similar error message as phuong:
#1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
I had already turned off Windows Firewall and Trend Micro-cillin protection. No green icon is present on my taskbar…
Would appreciate help as all has worked fine up til this!
Thanks!
June 11, 2009 at 12:21 pm
Hi Elliot,
Have you got any solution for this?
July 25, 2008 at 5:06 pm
Hi Mike,
Thanks for your suggestion.
I deleted the pma folder, created a new one and extracted the contents of phpMyAdmin-2.11.7-english.zip into it.
I copied the code from you last post to me into config.inc.php
Unfortunately, I am still getting the same result.
Is there anything else I can try?
Thanks,
David
July 25, 2008 at 12:53 am
Hi Michael;
I found and solved my problem
The wording of the step #2 in the installation of phpMyAdmin-2.11.7 can lead to confusion, as happened to me. Namely, this step states:
· Create a new folder called pma inside public_html. Extract all the files inside the phpMyAdmin-2.11.7-english.zip to C:\server\www\myserver.dev\public_html\pma\
When I extract all the files inside the phpMyAdmin-2.11.7-english.zip, I actually get only one file – it is a directory called phpMyAdmin-2.11.7-english. What I was doing was putting this directory into the pma directory, which was wrong. Instead, what I needed to do was to open the phpMyAdmin-2.11.7-english directory, and put all the files in this directory in the pma directory. Then it worked.
I hope that this note can help others to quickly overcome this problem that I encountered.
July 25, 2008 at 12:46 am
Hello Michael,
Thank you for all of your help. I made the changes to httpd-vhost.conf and the server came up.
I had already had PHP installed on my computer. After making the changes for the Apache server I wasn’t able to see the PHP info. In order to fix it I uninstalled PHP and reloaded it. It still did not work. I uninstalled it again and this time I reloaded PHP using the ZIP file and followed your modification instructions and rebooted the computer and everything, including phpMyAdmin, is operational.
Take care,
David M.
July 24, 2008 at 10:40 pm
HI Michael
I just tried your suggestion, but I get exactly the same problem as before. Thas is, when I point my browser to htttp://www.myserver.dev/pma/index.php, I get an HTTP 404 error.
Anything else I could try?
July 24, 2008 at 7:52 pm
hey jean,
thanks for postin in.
You can do one thing, delete the current pma folder. create a new folder ‘phpmyadmin’ and extract phpmyadmin files to it.
and repeat the instructions here http://blog.visionmasterdesigns.com/2008/07/tutorial-installing-apache-php-5-mysql-5-phpmyadmin-windows-vista-xp/6/ with the new extracted version of phpmyadmin
It should work fine, else let me know
Regards
July 24, 2008 at 7:42 pm
Hey david,
do one thing,
delete the pma folder, create another folder phpmyadmin and extract all the files there as a fresh installation.
Then copy the code
< ?php
$i = 0;
/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'config';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysqli';
/* User for advanced features */
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
?>
and save the file as config.inc.php inside the new folder.
let me know
regards
July 24, 2008 at 6:56 pm
Hello again Michael, thanks for continuing to help me.
I re-copied the contents of config.inc.php
I do see ‘mysql’ and ‘mysqli’ when phpinfo(); is executed.
When I ran the test.php script I got:
Connected to mysql successfully
But http://www.myserver.dev/pma/index.php still gives:
#1045 – Access denied for user ‘root’@'localhost’ (using password: NO)
Thanks again.
All the best,
David
All the best,
David
July 24, 2008 at 6:47 pm
This tutorial was great up to the last step 5 (i.e. Installing and Configuring PhpMyAdmin 2.11.). However, I cannot get this last step to work.
I have carried the sub-steps 1-3 to create the file config.inc.php and to save it in my pma folder. However, when I point my web browser to htttp://www.myserver.dev/pma/index.php, I get HTTP 404 (Not found).
I thought that this result was to be expected since there is no file named index.php in the pma folder. But, replacing index.php with config.inc.php still leads me only to a blank page in my browser.
Anyone can offer a suggestion to help me resolve this problem?
July 24, 2008 at 6:03 pm
Hey David
< ?php
/* Servers configuration */
$i = 0;
/* Server localhost (config:root) [1] */
$i++;
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['pmadb'] = 'pma';
/* End of servers configuration */
?>
are you sure that the above is the code that is in your config.inc.php inside your pma folder ? Sometimes, pma still shows the error, try refreshing it.
Does normal sql connections work ? did ‘mysqli’ and ‘mysql’ show up when you executed phpinfo(); ?
If you are unsure then do the following,
create a new file call it test.php and put the following code inside it.
Place it inside your public_html folder.
< ?php $conn = mysql_connect('localhost','root','root'); //('host name','username','password') if (!$conn) die('Error connecting to server!'); else echo "Connected to mysql successfully"; ?>Then point your browser http://www.myserver.dev/test.php
and let me know what was the result ?
July 24, 2008 at 5:49 pm
Hey Kurvmax,
you can change the settings by editing the httpd.conf file, but I wouldn`t suggest you edit the file, since it tends to be very confusing.
Anyways just uninstall everything and remove any previous settings, then log in as the administrator and then install everything again.
Regards
July 24, 2008 at 4:44 pm
Hey David M,
just replace ALL the code from httpd-vhosts.conf
July 24, 2008 at 4:38 pm
Hey Cris,
Thanks for reading,
Do one thing, goto Control Panel->System->Advanced System Settings->Environment Variables
scroll down in system variables and find path, edit it, see whether your directory \mysql\bin is present there ?
It should be there.
But either ways
I suggest you try installing with the settings as per the tutorial, and turn off your firewall,antivirus etc since it blocks the port no of mysql.
Regards
July 24, 2008 at 8:16 am
Hi Michael,
Thanks for the quick response. I’m able to log into mySQL with no problems using the command line interface. I tried the slashes both ways. I’m slowly remembering my Unix days from years gone by. Neither way worked.
Below is my httpd-vhost.conf file contents. If the change at the end of the file is not commented I get the failure message when I try to restart the server. However, if I comment out this section of the file then the server runs with no problem. I can get the “It Works” message but I cannot get pma running so I know that I need to get the server running with the httpd-vhost.conf changes.
Thanks for the help,
David M.
#
# Virtual Hosts
#
# If you want to maintain multiple domains/hostnames on your
# machine you can setup VirtualHost containers for them. Most configurations
# use only name-based virtual hosts so the server doesn’t need to worry about
# IP addresses. This is indicated by the asterisks in the directives below.
#
# Please see the documentation at
#
# for further details before you try to setup virtual hosts.
#
# You may use the command line option ‘-S’ to verify your virtual host
# configuration.
#
# Use name-based virtual hosting.
#
NameVirtualHost *:80
#
# VirtualHost example:
# Almost any Apache directive may go into a VirtualHost container.
# The first VirtualHost section is used for all requests that do not
# match a ServerName or ServerAlias in any block.
#
ServerAdmin webmaster@dummy-host.myserver.dev
DocumentRoot “C:/Program Files/Apache Software Foundation/Apache2.2/docs/dummy-host.myserver.dev”
ServerName dummy-host.myserver.dev
ServerAlias http://www.dummy-host.myserver.dev
ErrorLog “logs/dummy-host.myserver.dev-error.log”
CustomLog “logs/dummy-host.myserver.dev-access.log” common
ServerAdmin webmaster@dummy-host2.myserver.dev
DocumentRoot “C:/Program Files/Apache Software Foundation/Apache2.2/docs/dummy-host2.myserver.dev”
ServerName dummy-host2.myserver.dev
ErrorLog “logs/dummy-host2.myserver.dev-error.log”
CustomLog “logs/dummy-host2.myserver.dev-access.log” common
DocumentRoot “C:/server/www/myserver.dev/public_html”
ServerName myserver.dev
ServerAlias http://www.myserver.dev
AllowOverride All
Options Index FollowsymLinks
Order allow,deny
Allow from all
July 24, 2008 at 5:47 am
http://localhost/ isn’t even working for me at the moment…
July 24, 2008 at 5:43 am
So I uninstalled everything, and then installed over again in default locations and it worked. But when I try to navigate my browser to htttp://www.myserver.dev/pma/index.php (note: extra t in http appears to be an error), I just get a page load error.
Out of curiosity, how would I change the things that were set in the installation wizard: network domain, server name, and administrator email address?
I suppose my best option at this point might be to go through the process again?
July 24, 2008 at 3:20 am
Hi Mike,
When I did as you suggest, I get:
Error: 1045 (28000): blah blah…
…which is what you were expecting, I guess.
Although, when I run the ‘MySQL Command Line Client’ it accepts root as the password.
Am I right in assuming that I have set a password to ‘root’, but not the one I need to set?
What next?
Thank you,
David
July 24, 2008 at 1:18 am
Hi, Great tutorial. Very useful. I wonder if you could please help me with my problem.
I followed all the steps (previously erased older versions of apache, mysql and php), but now I can´t get mySQL to be recognized by php. It doesn´t appear on phpinfo() and when I try to execute any php file, it doesn´t recognize the mysql_connect command.
I´ve gone over every step several times. Checked that
extension=php_mysql.dll
extension=php_mysqli.dll
are uncommented in php.ini.
Even copied php.ini in windows directory and copied the dll files in windows directory.
I checked that mysql is running ok, having entered and created a new database and tables.
The thing is, php doesn´t “see” it. Any idea what´s wrong?
The only thing I did diferent from your tutorial was not to enable access from remote machine during the mysql instalation because I only need it to test my programs locally. (And I got the firewall error).
I´ve also uninstalled completly mySQL to reinstall it again.
Your help is deeply appreciated. Thanks
July 23, 2008 at 6:25 pm
Hey David,
are you sure you have put in your new password in mysql ?
Goto Start->Run Type cmd, hit Enter
Then type
mysql -u username -p
the prompt should ask you for a password, enter the password (root, I assume)
lemme know the result, I`ll sort out your problem
Regards
July 23, 2008 at 6:15 pm
Hey David M,
can you post the text inside the httpd-vhosts.conf file ?
the following must be the text that should be added all the way below. Please check the port no, directory and note take care of the slashes as well. It is a frontslash
Regards
BTW use the pre tag to put your code, i.e (< )pre lang="apache"(>) your code here (< )/pre(>).
Please remove all the round brackets
July 23, 2008 at 1:26 pm
Hi Michael, sorry about the delay in responding to your last advice.
You’re right, I did not put a password in while installing MySQL – although, realising my mistake, I did use the ‘MySQL Server Instance Config Wizard’ to set the root password to ‘root’.
I have copied and pasted the lines you gave me into config.inc.php (is this correct?) but I still get the same result.
What should I look to change next?
Your help, and your excellent tutorial, are very much appreciated.
Thanks and regards,
David
July 23, 2008 at 10:11 am
Hi Mike,
You’ve definitely put together a good tutorial for us newbies. I’ve spent 20+ years in embedded real-time system development and I’m just learning about servers and Internet programming.
I have run into a problem. When I put in the changes to httpd-vhosts.conf and to hosts the server will not start – I get a message that the operation failed. If I go back into httpd-vhosts.conf and comment out the lines that were added in then the server starts.
I’m running Vista Ultimate SP1. Ultimately I’m hoping to use a local server to try my website before loading it up to the host’s server. I’m working with Expression Studio 2.
Everything worked up to the point where I change the httpd-vhosts.conf file.
Any pointers would be great. I may end up creating a subfolder on my host’s server and password protect it to try things out before going live.
Take care,
David M.
July 23, 2008 at 8:26 am
This Tutorial was the BOMB!!! Followed to the T soup-to-nuts you can’t go wrong. I’m a noob to all of these products and this by far was the best Tutorial I found. Latest product and easy to follow. What else could you want. — Thanks a bunch!
July 22, 2008 at 6:20 pm
hey kurvmax,
i suggest you uninstall mysql entirely and try reinstalling mysql exactly the same way as the tutorial. Also, please install when logged as administrator.
Try it out and lemme know
Regards
July 22, 2008 at 6:17 pm
hey felipe,
please check this page
http://blog.visionmasterdesigns.com/2008/07/tutorial-installing-apache-php-5-mysql-5-phpmyadmin-windows-vista-xp/4/
did you edit the httpd-vhosts.conf ?
did you put your port no(8181) in all the settings instead of default 80 ?
and also check your httpd.conf file as well for the port no.
Lemme know
Regards
July 22, 2008 at 6:12 pm
hello Dean,
you must have not loaded the mysqli extension, please open php.ini inside your php folder,
search for
;extension=php_mysqli.dll
then remove the semi colon (;) if any.
restart your web server, it should work fine
Regards
July 22, 2008 at 11:45 am
By the way, I installed some of these programs to places other than Program Files … C:\mysql, and Apache is in C:\Stuff\Apache.
Not sure if that messed me up.
July 22, 2008 at 10:48 am
Hey, I appreciate you listening to me. I’m usually ignored. Linking to the real source is good for beginners because those websites often have docs.
The question I have as I go through this is: why the hell are all these little hacks, especially the ones with Apache, necessary? The Apache website (http://httpd.apache.org/docs/2.2/platform/windows.html) says this:
After installing Apache, you must edit the configuration files in the conf subdirectory as required. These files will be configured during the installation so that Apache is ready to be run from the directory it was installed into, with the documents server from the subdirectory htdocs. There are lots of other options which you should set before you really start using Apache. However, to get started quickly, the files should work as installed.”
Anyway, I ran into an error when I tried to configure MySQL: “cannot create Windows service for MySQL. Error:0″
I’m wondering if it might have to do with my path environmental variable. It has some strange stuff: C:\server\php;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\ATI Technologies\ATI.ACE\;C:\Documents and Settings\Ben\My Documents\Programs\IsoBuster;C:\mysql\bin
Anyway…so much for this…when I unchecked “Include Bin Directoy in Windows PATH”, nothing changed.
July 22, 2008 at 8:50 am
Hello I have a problem while trying to
to access to:
http://myserver.dev
I had have already installed mysql before installing Apache and PHP,
besides I have already using port 80 with IIS, so I configured Apache to use port 8181, it works fine alone.
The problem is when I trrying to connect to: http://myserver.dev
a popup window appear asking for user and password, how can i solve this? anyone has the same problem?
July 22, 2008 at 1:54 am
http://myserver.dev/pma
fetches the following results:
Cannot load mysqli extension. Please check your PHP configuration. – Documentation
I have gone through all of the above comments and have not been able to resolve this error yet… PLEASE HELP
July 21, 2008 at 6:04 pm
hey kurvmax
Thanks for posting in.
Yup you are right, but actually, I had written this tutorial for people, who are very new to this and wouldn`t be able to figure out which package to download, its a possibility that they might get confused.
But anyways, thanks for your suggestion, I have added the webpage linking to the most recent version as well.
And I`ll be updating the tutorial, with the latest versions as well, so keep checking
Regards
July 21, 2008 at 7:17 am
You should not link directly to downloads. Instead, link to the most professional source for downloading the software, ie for Apache http://httpd.apache.org/
Least that’s my (beginner) opinion
July 20, 2008 at 5:06 pm
Very detailed instruction! it works! Thanks alot!
July 19, 2008 at 8:51 pm
great tutorial . rated 5.
July 19, 2008 at 8:30 pm
EDIT : Some people who have downloaded and installed mysql-v 5.1.25 rc claim to have some compatibility issues, if possible please try to use mysql-5.0.51b-win32.zip instead.
I`ll do check up & update you guys with on how to work on it.
Currently the latest mysql 5.1 is mysql-5.1.26
while latest mysql 5 is mysql-5.0.51b
Regards
July 19, 2008 at 6:11 pm
hey david,
sorry for the delay, did you put a password while installing mysql ?
this problem tends to happen when you haven`t created any password for mysql.
anyways try replacing all your code in config.php.inc to the following and let me know the results.
< ?php
/* Servers configuration */
$i = 0;
/* Server localhost (config:root) [1] */
$i++;
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['pmadb'] = 'pma';
/* End of servers configuration */
?>
now point your browser to http://www.myserver.dev/pma/index.php
July 19, 2008 at 5:57 pm
hmm, i really doubt it could have been any other problem.
double check the path you have written in your extension_dir in php.ini
it should point the this dir, please not the slashes.
extension_dir = “C:/server/php/ext”
anyways, if you can let me know about the other problems you had encountered i`ll be glad to help.
you can add me at rowoot@gmail.com.
regards
July 19, 2008 at 5:33 pm
i uncommented them . i don’t know what fixed the problem. at the next install i will apply one fix at the time so i can figure out what was the problem.i encountered numerous problems when i will finish i will post links to the best tutorials that helped me.
July 19, 2008 at 5:21 pm
hey blue,
you had not enabled the extension from the php.ini file,
if anyone having this error,
please search for the following lines in your php.ini
;extension=php_mysql.dll
;extension=php_mysqli.dll
and replace them with
extension=php_mysql.dll
extension=php_mysqli.dll
Regards
July 19, 2008 at 4:23 pm
uhm i fixed that problem . for anyone that has the same problem i found the fix here
http://forums.mysql.com/read.php?52,64628,64628#msg-64628
i don’t know which one did the trick because i applied several before restarting and retrying.take and read each one hope that helps
July 19, 2008 at 1:30 pm
Hey Mike, thanks for your response.
You were 100% correct – Apache was running. I had accidentally saved index.php as a .txt file
That part is now working fine, but I am currently where Phuong got to, with the same error message.
MySQL root password is ‘root’, which is what is specified in config.inc.php (contents pasted in below).
I have Windows Firewall turned off and I have disabled Norton Security.
Is there anything else I could try?
Thank you, David
#Contents of config.inc.php
/* Servers configuration */
$i = 0;
/* Server localhost (config:root) [1] */
$i++;
$cfg['Servers'][$i]['bookmarktable'] = ‘pma_bookmark’;
$cfg['Servers'][$i]['relation'] = ‘pma_relation’;
$cfg['Servers'][$i]['table_info'] = ‘pma_table_info’;
$cfg['Servers'][$i]['table_coords'] = ‘pma_table_coords’;
$cfg['Servers'][$i]['pdf_pages'] = ‘pma_pdf_pages’;
$cfg['Servers'][$i]['column_info'] = ‘pma_column_info’;
$cfg['Servers'][$i]['designer_coords'] = ‘pma_designer_coords’;
$cfg['Servers'][$i]['history'] = ‘pma_history’;
$cfg['Servers'][$i]['host'] = ‘localhost’;
$cfg['Servers'][$i]['extension'] = ‘mysqli’;
$cfg['Servers'][$i]['port'] = ’3306′; //if any different port no you have specified
$cfg['Servers'][$i]['connect_type'] = ‘tcp’;
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['controluser'] = ‘root’;
$cfg['Servers'][$i]['controlpass'] = ‘root’;
$cfg['Servers'][$i]['auth_type'] = ‘config’;
$cfg['Servers'][$i]['user'] = ‘root’; //MySQL username
$cfg['Servers'][$i]['password'] = ‘root’; //MySQL Password
$cfg['Servers'][$i]['pmadb'] = ‘pma’;
/* End of servers configuration */
?>
July 19, 2008 at 1:22 pm
Cannot load mysql extension. Please check your PHP configuration.? any ideeas?
July 19, 2008 at 9:07 am
Hey David, Thanks for posting in.
you say the green arrow doesnot show up, but when you browse to http://www.myserver.dev , you are able to see the index page which means, apache is working fine, if it is not will see a “Page not Found” Page.
Just to ensure your webserver is working fine, please rename the index.php.txt file to index.php, reboot the computer and then try pointing your web browser to http://www.myserver.dev.
The contents of index.php must be
< ?php
phpinfo();
?>
Regards
Mike
July 19, 2008 at 3:57 am
Hi there, I wonder if you can help.
Something strange happened during the installation of MySQL – at the end of the installation, the configuration wizard ran, but came up in a box so small I could not see any of the options or change anything. I could only click next or cancel.
So I clicked next without making and changes, until I came to the password setting option, when next would not work so I clicked cancel.
I then tryed the installation again, and it appeared everything had installed fine, so I ran the ‘MySQL Server Instance Config Wizard’ and applied all the setting as per the tutorial, setting a root password – as none had been set during the initial installation.
Where I’m at right now is that when I restart Apache I do not appear to get the green arrow, and when I browse to http://www.myserver.dev all I see is:
Index of /
index.php.txt
I’m very new to this. Please could you let me know where I’ve gone wrong.
Thank you,
David
July 18, 2008 at 9:37 pm
Hello Phuong,
I assume, you must have not put any password during the installation of mysql.
Sorry I hadn`t specified it in this post, now its updated.
If you had put a different password while installing mysql then update the config.inc.php file in phpmyadmin folder with the new password.
BTW please check your port no for mysql, by default it is 3306 and please check if it is the same and try disabling your windows firewall or any antivirus you might have, it tends to block all connections in this port in general.
If possible let me know the settings you followed in installing mysql, and if possible post your “config.inc.php”, maybe I can help you much better.
Regards
Mike
July 18, 2008 at 6:00 pm
hi.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
Error
MySQL said: Documentation
#1045 – Access denied for user ‘root’@'localhost’ (using password: NO)
July 9, 2008 at 4:54 pm
hey,
thanks for the suggestion, I haven`t heard of it yet, but I`ll definatly give it a try.
But apache being a standard for almost 98% of linux web servers, if people can configure apache, then they won`t have any problem when hosting their site online.
Thanks
July 9, 2008 at 4:25 pm
hi,
i would suggest a better/light weight web server called Abyss Web Server.The X1 version is free i guess.
Also, it requires a preconfiged php package provided along with the web server.
It also supports ASP.NET.
July 9, 2008 at 2:44 pm
g8 tutorial.very helpful.