You are here: remote creation of MySQL db « PHP Programming Language « IT news, forums, messages
remote creation of MySQL db

Posted by Ike on 01/20/06 18:34

I am trying to establish a database on a MySQL database, wherere the MySQL
version is 5.x. Therefore, MySQL uses the new hashing algorithm with regards
to it's passwords.

The database is behind a firewall where I am given a hole through port 3306
to the IP where I am running php.

However, because of the password hashing algorithm in MySQL 5.x and the
incompatibility with the 4.x version of php I must run, I cannot
mysql_connect() -- I need to have the MySQL password altered by:

mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

My question is, is there some way I can perform this MySQL command,
remotely, via say php, given how stuck I am per the above! -Ike

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация