THIS TROUBLE SHOOTING PAGE IS ISSUED ON DEMAND BY WAMP SERVER USERS.I have installed the WAMP server in order to make my home PC a Web Server so that I can host websites or create an online store using the full capacity of my Hard Disk of 500 GB without any obligation to any hosting company. However, I have downloaded the best open source server software WAMP from the author's site and installed three-in-one modules included in WAMP namely Apache, MySQL and PHP, which are required to make my PC a Public Web Server . But after installing the software I found errors and went on googling spending hours and days, but without success. Then I tried with little information collected from the web wih my logics, at last I could able to solve all my issues, which I hope will help someone who is in trouble with WAMP Errors.The error is like the one given below:"Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole."You may fix this error with few steps as given below:1. Go to phpmyadmin;2. Click on the database you want to change the password to from the left side of the screen3. Click on "privileges" menu on the top4. Click on the "edit privileges" icon on the right of the root user for localhost in 'Action' column.5. Go to the "change password" block6. Tick the "password" radio button7. Enter password and re-type that password. Don't make any changes in the 'Generate Password' button.8. Click "go" in the next line of this box10. Now open a MySql Console from the WAMPSERVER menu11. You may see a prompt asking for a password – just hit the return since you don't have one yet (next time you go to the console you'll need to enter the new pw that you'r entering here). Type the following on the mySQL promptUPDATE mysql.user SET Password=PASSWORD("xxxxxx")WHERE User="root";(where xxxxxx is the password you entered in the previous step).12. Now type: FLUSH PRIVILEGES;
13. Go to your WAMP or MAMP folder, find the APPS folder, and than click on your PHPMYADMIN folder ( e.g C:\wamp\apps\phpmyadmin3.3.9) and find the config.inc.php
14. Open config.inc.php with wordpad and find the following text:
$cfg['Servers'][$i]['password'] = '';
now add the password that you used in step number 3 like this :
$cfg['Servers'][$i]['password'] = 'yourPasswordHere';
15. now save this modification, and close config.inc.php
Congratulations!!! You have done everything and set to run your Apache Server!SOLUTION FOR SOME OTHER ERRORS NOTIFIED BY USERSERROR CODE - "Additional features for working linked tables have been deactivated"
Enabling Linked Tables in phpMyAdmin
- WAMP Server 2.
- Apache 2.2.17·
- PHP 5.3.5
- MySQL 5.5.8
Step 1: Edit and run create_tables.sql
The file can be found at: C:\wamp\apps\phpmyadmin3.3.9\scripts\create_tables.sql
There are two sections at the top which are usually commented out – one to create a phpmyadmin database, and one to create a phpmyadmin user. I usually just create the database myself and I prefer to use the following command in the next step to create the user. So, after creating the database, I usually just run the file as it originally came.
Step 2: Create a control user (controluser):
In order to do this, go to phpMyAdmin by clicking the left mouse button at WAMP SERVER icon on the right corner of status bar of your computer, and click the menu "sql" , which will open "Run SQL query/queries on server "localhost" text box. Copy and paste as it is the commands given below, which will create the necessary database and tables automatically.
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'pmapass';
GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'phpmyadmin'@'localhost';
Step 3: Edit config.inc.php:
The file can be found at C:\wamp\apps\phpmyadmin3.3.9
Add these lines to your config.inc.php file and then you are set to run the Server!
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$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]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['controluser'] = 'phpmyadmin';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';
After I did all the above modifications, my server started working perfectly without any errors. Hope this will be useful to anyone who is looking for solutions to the above errors.
Have a wonderful day!!!
Download latest version WAMP Server Here: