phpMyAdmin With Mysql And With Apache

freak4pc

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

pvechi

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

go into phpMyAdmin as the root user.
click on Users on the home page.
add user for your database table.
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.🙂

freak4pc

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...

pvechi

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.

freak4pc

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???

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.

dzekic

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 🆒