[howto] RC7 => 1.0.x Upgrade Problem with Access Denied

[icat]

If people run in to the problem like me during upgrade from rc7 to 1.0.x "Access Denied". Consider the belowing steps:

1: Don't give here root for the ftp user when your asked for
Please enter ispCP ftp SQL user. [vftp]:

Upgrade process will delete this user (see ispcp-update):
DELETE FROM tables_priv WHERE Host = '$hostname' AND Db = '$main::db_name' AND User = '$vftp_sql_user'
AND
DELETE FROM user WHERE Host = '$hostname' AND User = '$vftp_sql_user'

2: If you don't have vftp user and password, you can look for in
proftpd.conf in /etc/proftpd
If the user there is also root, you can look for vftp user in MySQL DB and change the Password in both MySQL and proftpd.conf

3: Restart ispCP upgrade-process



If you already run into this problem, then you propably dont have root acces to the database.

To reanimate the root user, you have to create the root user in MySQL with all the privaladges again.