|
Home > Archive > MySQL Server Forum > August 2005 > help - mysql + php + phpMyAdminb
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
help - mysql + php + phpMyAdminb
|
|
| The Good Doctor Dog Balls 2005-08-20, 11:23 am |
| 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?
| |
| Bill Karwin 2005-08-21, 8:23 pm |
| 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'@'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?
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 2005-08-22, 7:23 am |
| 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@ene
ws4.newsguy.com...
> The Good Doctor Dog Balls wrote:
>
> 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.
|
|
|
|
|