5

I've changed the user+group where apache is running to my user name so I don't have to change the web files I'm editing. But now I get NoDataReceived error trying to import using phpmyadmin.

http://wiki.phpmyadmin.net/pma/FAQ_1.16

What can I do to avoid this problem?

When I change back in /etc/apache2/envvar to www-data for user and group it works to import the same file to the same db. I login to phpmyadmin as root.

3
  • One of us is completely confused. I've never run into any problems with the standard setup; what is the problem you're trying to solve in the first place. The link you provided doesn't seem to have anything to do with ownership at all. Is your database very large? If so, you just need to either split it, or compress it using the built-in compression abilities of phpmyadmin (I do this all the time, and have never had a problem). Aug 14, 2012 at 22:31
  • Why not simply add the permissions for write for your user or any user?
    – LnxSlck
    Aug 14, 2012 at 23:34
  • I can't comment on @Giovanni Toraldo answer so I am writing here, I made the change for owner. No I need to take it back. Who is original owner:group for /var/lib/phpmyadmin/tmp ? Thank you
    – YahyaE
    Apr 18, 2013 at 8:25

1 Answer 1

5

You need to edit /etc/apache2/conf.d/phpmyadmin.conf:

php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp

to a writable folder for your user.

Or change ownership of that folder:

chown user:user /var/lib/phpmyadmin/tmp

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .