Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

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.

share|improve this question
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). – Marty Fried Aug 14 '12 at 22:31
Why not simply add the permissions for write for your user or any user? – LnxSlck Aug 14 '12 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 '13 at 8:25

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
share|improve this answer

This may help you but use chmod 777 with caution.

sudo chmod 777 /var/lib/phpmyadmin/tmp
share|improve this answer
Never set permissions to any directory to 777. – guntbert Nov 9 '13 at 12:10

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.