-
Юбилейный DevConfX пройдет 21-22 июня в Москве. Как всегда — Вы решаете, кто попадет в программу секции Backend — голосуйте за интересные доклады
MySQL не даёт авторизоваться
- Автор темы KPD
- Дата начала
Novar
Guest
Вот лень.....
иди ка ты......на mysql.com
и долго и упорно ройся в документации, про эту проблему уже не раз заикались.
иди ка ты......на mysql.com
и долго и упорно ройся в документации, про эту проблему уже не раз заикались.
Novar
Guest
Настроение у меня хорошое 
зарплату дали:
Только не говори что тебе еще и перевести надо!!
Thanks for the response, mglatts.
I was using a previous version of mySQL, which didn't allow me to make any root admin database changes (priviliges, create databases etc). I upgraded and ran into problems configuring the MySQL instance and security settings (resolved after deleting the previous service fromt the command line). Then I had the #1045 error message connecting to MySQL from PHP/Apache or JSP/Tomcat. However, I found this on another message board, and it worked right away for me (I changed the default phpMyAdmin user to root also, for more privileges and a nice GUI)
1. Login as root to mysql at the command prompt (in windows XP sp2 select from menu start->programs->mysql->mysql command line)
2. create new account for example ‘zoooz:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost;
3. set password in old format:
mysql> SET PASSWORD FOR root@localhost = OLD_PASSWORD('mypass');
if you are running postnuke on local machine use ‘localhost’ as host name
And that’s all.
The reason you get the error message is that MySQL 4.1 uses an authentication protocal based on a new password hashing algorithm that is not apparently supportet by php (or apache?). Command old_password assigns password with old algorithm
зарплату дали:Только не говори что тебе еще и перевести надо!!
Thanks for the response, mglatts.
I was using a previous version of mySQL, which didn't allow me to make any root admin database changes (priviliges, create databases etc). I upgraded and ran into problems configuring the MySQL instance and security settings (resolved after deleting the previous service fromt the command line). Then I had the #1045 error message connecting to MySQL from PHP/Apache or JSP/Tomcat. However, I found this on another message board, and it worked right away for me (I changed the default phpMyAdmin user to root also, for more privileges and a nice GUI)
1. Login as root to mysql at the command prompt (in windows XP sp2 select from menu start->programs->mysql->mysql command line)
2. create new account for example ‘zoooz:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost;
3. set password in old format:
mysql> SET PASSWORD FOR root@localhost = OLD_PASSWORD('mypass');
if you are running postnuke on local machine use ‘localhost’ as host name
And that’s all.
The reason you get the error message is that MySQL 4.1 uses an authentication protocal based on a new password hashing algorithm that is not apparently supportet by php (or apache?). Command old_password assigns password with old algorithm
tony2001
TeaM PHPClub
Novar
Guest
Он уже отмазался:
-)
Novar
Guest
А разве кто спорит?
если что и надо искать то первым делом на оф. сайте.
если что и надо искать то первым делом на оф. сайте.