This is embarrassing but can someone please remind me ...

habbardone

Please help !

This is a bit embarrassing !

I am using MySQL on my Apache server on my pc

Its been a year or so since I added databases etc and
now I want to change th password.
I am using this code to create my table:

PHP Code:
<?php

/ a_build_adverts.php
Builds database

THIS IS FOR PC DATABASE
---------------------- */

$host = "localhost";
$user = "root";

$password = "pass";

$connection = mysql_connect($host,$user,$password)

or die ("Couldn't connect to server.");

My question is - where is the passord stored ?
I looked in the php.ini file but it wasn't there.

Thanks

habbardone

Hi - some progress

Well I have found a database called "mysql" and a table called "user"

I am looking at it with "http://localhost/phpMyAdmin"

It only has one user set up and it has a VERY loıng password
eg *A60643EEFF657DAF906E1D4CBF356961D7D3BAD2

Well I would not have used a passwoed like that - I think I used "7eddy"
so has this been encrypted ?

Should I change the password using phpMyAdmin or is there a more usual way to set up users and passwords ?

Thanks

nickadeemus2002

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

ragedigital

habbardone wrote:
It only has one user set up and it has a VERY loıng password
eg *A60643EEFF657DAF906E1D4CBF356961D7D3BAD2

Well I would not have used a passwoed like that - I think I used "7eddy"
so has this been encrypted ?

Phpmyadmin encrypts your password, probably using MD5.

The MD5 of '7eddy' is : 9c8ce77c335cc4b478bf3a34358b1f3c

bradgrafelman

ragedigital wrote:
Phpmyadmin encrypts your password

No it doesn't... phpMyAdmin doesn't authenticate login attempts with a MySQL server.

ragedigital wrote:
probably using MD5.

MySQL does not use MD5 for password hashing (otherwise they'd probably lose favor with me - MD5 isn't secure).