help - mysql + php + phpMyAdminb

I'm trying to set them up using this guide:
http://www.webmasterstop.com/48-4.html

the first time I did this, it worked fine, and after a month, it stopped
working (Dreamweaver; no tables found all of a sudden), so I uninstalled
mysql + phpmyadmin and tried again.

when I load up localhost/phpAdmin on my comp it says: #1045 - Access denied
for user 'root'@'localhost' (using password: NO)

I did edit the config file with root and password where appropriate, and
when I installed mysql I gave the password (which was "password").

why isn't it working?

re: help - mysql + php + phpMyAdminb

Would this perhaps be owt to do with my very good friend the pma 'config.inc.php' page? Lord, but I've had a struggle with that.

Might be worth checking the $cfg['Servers'] section, which I've pasted below:

.................................................. .................................................. .....
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'your_usr_name'; // MySQL user
$cfg['Servers'][$i]['password'] = 'your_pwd'; // MySQL password (only needed
.................................................. .................................................. .....

Fun, though, isn't it?

Trevor

re: help - mysql + php + phpMyAdminb

The Good Doctor Dog Balls wrote:[color=blue]
> I'm trying to set them up using this guide:
> http://www.webmasterstop.com/48-4.html
>
> the first time I did this, it worked fine, and after a month, it stopped
> working (Dreamweaver; no tables found all of a sudden), so I uninstalled
> mysql + phpmyadmin and tried again.
>
> when I load up localhost/phpAdmin on my comp it says: #1045 - Access denied
> for user 'root'@'localhost' (using password: NO)
>
> I did edit the config file with root and password where appropriate, and
> when I installed mysql I gave the password (which was "password").
>
> why isn't it working?[/color]

My first guess is that you had MySQL 4.0 before, and you reinstalled
with MySQL 4.1. PHP does not support the password encryption method
used by default in MySQl 4.1. You must start your MySQL serve with the
--old-passwords flag.

See http://dev.mysql.com/doc/mysql/en/php-problems.html
and the note about PHP in http://dev.mysql.com/doc/mysql/en/old-client.html

Regards,
Bill K.

re: help - mysql + php + phpMyAdminb

THANK you so much that's what happened!

By the way, any one use Dreamweaver here? It keeps saying "Could not find
selected tag node" as try and insert an insert record behaviour.


"Bill Karwin" <bill@karwin.com> wrote in message
news:deapjp02sp4@enews4.newsguy.com...[color=blue]
> The Good Doctor Dog Balls wrote:[color=green]
>> I'm trying to set them up using this guide:
>> http://www.webmasterstop.com/48-4.html
>>
>> the first time I did this, it worked fine, and after a month, it stopped
>> working (Dreamweaver; no tables found all of a sudden), so I uninstalled
>> mysql + phpmyadmin and tried again.
>>
>> when I load up localhost/phpAdmin on my comp it says: #1045 - Access
>> denied for user 'root'@'localhost' (using password: NO)
>>
>> I did edit the config file with root and password where appropriate, and
>> when I installed mysql I gave the password (which was "password").
>>
>> why isn't it working?[/color]
>
> My first guess is that you had MySQL 4.0 before, and you reinstalled with
> MySQL 4.1. PHP does not support the password encryption method used by
> default in MySQl 4.1. You must start your MySQL serve with
> the --old-passwords flag.
>
> See http://dev.mysql.com/doc/mysql/en/php-problems.html
> and the note about PHP in
> http://dev.mysql.com/doc/mysql/en/old-client.html
>
> Regards,
> Bill K.[/color]