help - mysql + php + phpMyAdminb

[The Good Doctor Dog Balls]

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'@'localho st' (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?

[Trevor]

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

[Bill Karwin]

The Good Doctor Dog Balls wrote:

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'@'localho st' (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?

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.

[The Good Doctor Dog Balls]

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" <bi**@karwin.co m> wrote in message
news:de******** *@enews4.newsgu y.com...

The Good Doctor Dog Balls wrote:

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'@'localho st' (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?

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.