title explains it. newbie mistake, i know. but i forgot the password after creating. when trying to log in to the mysql db_ispconfig i get the error access denied for user root@localhost. any help would be awesome.
found it elsewhere...this is what you do as root: root@server:/# mysql db_ispconfig -p Enter password: (this will be your sql password) then type the following line in. this tells that file to set the password to 'password' in the md5 column for the username 'admin'. UPDATE sys_user SET passwort = md5('password') WHERE username = 'admin'; that will reset your password to: password you can simply replace 'password' at the md5('password') spot to whatever you want if you wish.
