trouble in the MySQL part; no account for 'root'@'%'

Hi Jean-Jacque, thank you for the instructions. i try to install phpip on a 
completely new server with ubuntu 10.04 LTS, i have some trouble....

(i am not a computer guy, but i know the minimum to manage a pc with Linux 
environment...)

first i would like to give some precision: - at the end of "2.2 Virtual host in 
Apache for Zend" part it can be necessary to clear the history of firefox (if 
you use it)

in the "2.3. MySQL" part

for me "gunzip phpip_skel-YYYYMMDD.sql.gz" must be exect as root : "sudo gunzip 
phpip_skel-YYYYMMDD.sql.gz"

that is all that i was able to do. At the next command line i have trouble... 
indeed at "mysql -u root -p < phpip_skel-20120201.sql" i have an error after 
the good root password entry:

"ERROR 1449 (HY000) at line 2033: The user specified as definer ('root'@'%') 
does not exist"

I of course check if mysql have a root user, it have it.

i have another question: as PHPIP will be improve by the community, can you do 
a tutorial to update phpip with new features without to erase the data.

thank you for your job and your help

Arthur

Original issue reported on code.google.com by arthur.l...@gmail.com on 4 Mar 2012 at 5:02

jjdejong / phpip-legacy

trouble in the MySQL part; no account for 'root'@'%' #5