Forgot my admin password :(

Discussion in 'Installation/Configuration' started by cobro, Jul 23, 2009.

  1. cobro

    cobro New Member

    I have been looking into lost admin password here and all say that i have to connect to phpmyadmin and change the password from there but here is the funny thing i cannot connect to phpmyadmin from my browser this is what i get

    Forbidden

    You don't have permission to access /phpmyadmin on this server.

    Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

    but i have root accsess to the server i am the owner of the box can i do somthing within putty ?

    any help would be appreciated.
     
  2. Gleno0h

    Gleno0h New Member

    try this;

    Code:
    /etc/init.d/mysql stop
    mysqld_safe --skip-grant-tables &
    mysql -u root
    you should now see
    Code:
    mysql>
    then;
    Code:
    use mysql;
    update user set password=PASSWORD(”Yourpasswordherethatyouwant”) where user=’root’;
    flush privileges;
    quit
    /etc/init.d/mysql stop
    /etc/init.d/mysql start
    mysql -u root -p
    
    enter the pass you just made .. let me know if it worked, got it from google
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    Please try www.yourserver.com:8080/phpmyadmin

    and make sure that you installed phpmyadmin before.
     
  4. cobro

    cobro New Member

    no that did not work for me

    [root@box1 ~]# /etc/init.d/mysql stop
    -bash: /etc/init.d/mysql: No such file or directory
    [root@box1 ~]# /etc/init.d/mysql stop
    -bash: /etc/init.d/mysql: No such file or directory
    [root@box1 ~]# mysqld_safe --skip-grant-tables &
    [1] 3698
    [root@box1 ~]# mysql -u rootA mysqld process already exists

    but if you could help me to get my phpmyadmin and webmail working that would be grate :)
     
  5. cobro

    cobro New Member

    i went out the backdoor with this :) if you have absolutely nothing on your server i mean no domains and anything not hosting anything than this is the best way you can fix this

    and if you have root privilege on the server your box then just ssh this

    Code:
    mysql -uUSERNAME -hHOST -pPASSWORD
    Replace USERNAME, HOST and PASSWORD with your actual username, host (database server) and password.

    and then

    Code:
    DROP DATABASE database_name;
    database_name would be dbispconfig

    to delete the database from the mysql server

    and then just run installer again and you are done :)

    Code:
    cd /tmp
    wget http://downloads.sourceforge.net/ispconfig/ISPConfig-3.0.1.3.tar.gz?use_mirror=
    tar xvfz ISPConfig-3.0.1.3.tar.gz
    cd ispconfig3_install/install/
    
    php -q install.php
    
     

Share This Page