change password = how?
Posted by: TheDragon (---.dhcp.embarqhsd.net)
Date: October 30, 2006 07:42PM

yes - I tried the profile link
no place to change password?

Options: ReplyQuote
Re: change password = how?
Posted by: CyberSpatium (71.237.217.---)
Date: October 31, 2006 01:06AM

Changing Your Root User’s Password

Step 1: To change your root user’s password, we will be using phpMyAdmin to configure your users permissions table. So, make you have both Apache and MySQL up and running. Open your browser and type: [localhost] and you will be taken to the main phpMyAdmin home page.



Step 2: Now click on the ‘Privileges’ link (the one with the red arrow pointing to it in the image above) and you will be taken to the main phpMyAdmin Privileges page.



Step 3: To edit user’s privileges, click on the tiny ‘Edit Privileges’ icon next to the red arrow in the image above.



Step 4: Now to edit/change your password, scroll down until you see the ‘Change Password’ section. Put your password in the password box, and then re-type your password to double check that what you entered was typed correctly. Now click on the ‘Go’ button just below the ‘Re-type Password’ box. Congratulations, you are now done!

Note: If you have changed or updated the password for your root user, you will need to also update the phpMyAdmin config file to use your new/updated password. To do that, open up this file:
C:\wamp\phpmyadmin\config.inc.php

Find this line:
$cfg['Servers'][$i]['password'] = '';

Change it to:
$cfg['Servers'][$i]['password'] = 'Your_New_Password_Here';

Save the file and phpMyAdmin will now work without any problems.



Adding Users



Step 1: To add another user, click on the ‘Add a New User’ link on the main phpMyAdmin privileges page and you will be taken to the ‘Add User’ page.



Step 2: To add a new user, enter a user name, host (always use localhost), and passwords. Then use the check boxes to set this users MySQL privileges. Do not set any administration privileges for this user. Admin privileges should only be allowed for your root user. Once you are done, press the ‘Ok’ button. Now you need to set what database this user is allowed to use.



Step 3: To set what database this new user can use, go back to the main ‘Privileges’ page again. Now put a check mark next to the user name you used in the last step. Now you need to click on the ‘User Privileges’ image icon again. Now scroll down until you see the ‘Database-specific privileges’ section (see image above). In the first box scroll down and select the database you would like this user to be allowed to use. Then press on the ‘Ok’ button. Congratulations you are done adding a new user!



CyberSpatium
WAMP English Forum Administrator

Options: ReplyQuote


Sorry, only registered users may post in this forum.