1
Базы данных / Новый пользователь в MySQL 4.1
« : 02 Июня 2005, 19:29:21 »
Вот поискал на форумах и нашел ответ, может пригодится кому-либо:
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
Естественно после создания нового юзера нужно запускать запрос от имени админа с установкой старого пароля. Проверил, работает.
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
Естественно после создания нового юзера нужно запускать запрос от имени админа с установкой старого пароля. Проверил, работает.