Ok , I Installed Apache And Mysql 4.0.2 ... And Installed PhpMyAdmin 2.3.0
Now , Every Time I Get Into phpMyAdmin It Logs In As
root@localhost
so , how do i change the mysql db password to something else...

thanks to all,
Fre@k4pc

    You need to do a couple of things in a certain order.

    1. go into phpMyAdmin as the root user.
    2. click on Users on the home page.
    3. add user for your database table.
    4. go back to home page and Reload the database to update the priviledges. You must do this!

    You can then go into config.inc.php (located where you installed phpMyAdmin) and configure phpMyAdmin to authenticate with your new user, by adjusting:

    $cfgServers[$i]['user']
    $cfgServers[$i]['password']

    to your new user and password.

    Also, configure:
    $cfgServers[$i]['auth_type']

    to the options given. HTTP is neat.

    I usually do this so that no one enters the database with root access via phpMyAdmin, and I usually users with limited priviledges over the databases.

    I hope this helps.🙂

      thx man !!!
      BTW i tried to change
      $cfgServers[$i]['auth_type']
      from
      config to HTTP
      but when i did and i got into phpMyAdmin it Showed Me The Following Message:

      Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, [email]freak4pc@msn.com[/email] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.



--------------------------------------------------------------------------------

Apache/1.3.27 Server at localhost Port 80

      if u do know how to fix this ill thank u very much if you'll help
      thanks!! again...

        PHP needs to run as an apache module in order to use the HTTP method, rather than the CGI version.

        Check your PHP manual and apache configuration.

          what do u mean , can u give me any direction to fix this problem ...
          and another question...
          is this problem also causing the fact that the files .htaccess and .htpasswd dont do the job???

            Run phpinfo to check your server configuration. Go to the apache configuration and see if mod_php4 appears in the "Loaded Modules" box.

            If it is not then you need to compile your Apache with PHP.

              Originally posted by pvechi
              Run phpinfo to check your server configuration. Go to the apache configuration and see if mod_php4 appears in the "Loaded Modules" box.

              If it is not then you need to compile your Apache with PHP.

              Or change httpd.conf in "C:\Program Files\Apache Group\Apache\conf" under windows... You can find more info in install.txt in your PHP dir 🆒

                Write a Reply...