To change the interface password from mySQL, proceed as follows:
1. Navigate to the site manager directory
cd /home/servers/sitemanager
2. Check mySQL password for user root
cat sh/lib/mysql
3. Log in to mySQL shell
sh/mysql -u root -p
You will be prompted to enter a password for mySQL root user, type in the password from step 2.
4. Select database and table
mysql> use sitemanager_global; mysql> select * from users;
5. Change the interface password
mysql> update users set password = md5('$YOURNEW PASSWORD') where id = 1;
Replace $YOURNEWPASSWORD with your new password and try to log in with it.
|