system(): access denied

From: Date: Thu, 16 Jan 2003 14:28:11 +0000
Subject: system(): access denied
Groups: php.general 
Request: Send a blank email to php-general+get-131862@lists.php.net to get a copy of this message
Hello All, I have a script which uploads a mysqldump file into the server and use system("mysql -uroot -p < the_dump_file.sql") to restore the database. While, it does not go through and the apache error_log shows: Enter password: Enter password: ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) The passwords for mysql account "root" is "", but when I remove the -p from the command, everything is fine. The wired thing is, when I use system("mysqldump -uroot -p >the_dump_file.sql"), it is also fine. Anybody has experience of this? or any suggestions? Thanks a lot.

« previous php.general (#131862) next »