+ Post New Thread
Results 1 to 6 of 6
Web Development Thread, MyPHPAdmin Issues in Coding and Web Development; Hi All, just taken over a school where the last IT manager died, they had no other IT staff. I ...
  1. #1
    bencole's Avatar
    Join Date
    Nov 2013
    Posts
    113
    Thank Post
    73
    Thanked 4 Times in 4 Posts
    Rep Power
    2

    MyPHPAdmin Issues

    Hi All,

    just taken over a school where the last IT manager died, they had no other IT staff. I am trying to get into the Joomla backend so I need to wipe the password hash in SQL and replace it with my own.

    I know absolutely nothing about SQL. I can see from bookmarks on the admin machine that my PHP admin was once on the machine. I have tried to open myphpadmin but cant get it. redownloaded all the asociated files and dropped them into wwroot\phpmyadmin.

    I can access the SQL database with MySQL Workbench but I have no idea how to use it.

    Please can anyone help?

    Server is running 2008 R2 with IIS7

  2. #2
    teddybear's Avatar
    Join Date
    Jan 2009
    Location
    Scotland
    Posts
    179
    Thank Post
    48
    Thanked 39 Times in 30 Posts
    Rep Power
    18

  3. #3
    bencole's Avatar
    Join Date
    Nov 2013
    Posts
    113
    Thank Post
    73
    Thanked 4 Times in 4 Posts
    Rep Power
    2
    Thats what I am trying to do, you need to edit the password hash in SQL but cant get myPHPadmin to work. I dont know how to use SQL any other way.

  4. #4
    benjie's Avatar
    Join Date
    Dec 2010
    Location
    Stockton
    Posts
    103
    Thank Post
    8
    Thanked 21 Times in 21 Posts
    Rep Power
    11
    This is how you reset the mysql root password:
    MySQL :: MySQL 5.1 Reference Manual :: C.5.4.1 How to Reset the Root Password

    Once you have done that you could log in using the root password to reset the joomla password.

  5. #5
    bencole's Avatar
    Join Date
    Nov 2013
    Posts
    113
    Thank Post
    73
    Thanked 4 Times in 4 Posts
    Rep Power
    2
    Hi,

    Let me confirm. I am already in SQL that is not the problem. I need to wipe the joomla password. I can connect to a SQL database and I can edit it with mysql workbench but I dont know how to use it. My problem is opening myPHPadmin.

  6. #6

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,413
    Thank Post
    642
    Thanked 964 Times in 664 Posts
    Blog Entries
    2
    Rep Power
    327
    phpMyAdmin can be a bit cumbersome to set up and get working properly if you don't spend time trawling through the docs. And even then, sometimes it doesn't play nice! Instead, I'd recommend a light-weight alternative, Adminer. (Direct download for MySQL English-only version).

    It's a single file - just drop it into your web-accessible folder and access it through a web browser. You can then enter the details to log in - server will probably be localhost, and then the database, username & password you already have (by the sounds of it).

SHARE:
+ Post New Thread

Similar Threads

  1. Linux Format, January Issue
    By kingswood in forum *nix
    Replies: 11
    Last Post: 5th December 2005, 11:02 AM
  2. Squid issues new install
    By ChrisH in forum *nix
    Replies: 5
    Last Post: 10th November 2005, 03:09 PM
  3. Gentoo issues
    By _Bob_ in forum *nix
    Replies: 1
    Last Post: 31st October 2005, 02:29 PM
  4. Exchange 2003 and Server 2003 SP1 issue.
    By tosca925 in forum Windows
    Replies: 0
    Last Post: 21st August 2005, 10:32 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •