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 ...
12th November 2013, 02:59 PM #1
- Rep Power
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
12th November 2013, 03:53 PM #2
12th November 2013, 05:07 PM #3
- Rep Power
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.
12th November 2013, 05:27 PM #4
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.
12th November 2013, 05:43 PM #5
- Rep Power
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.
12th November 2013, 07:31 PM #6
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).
By kingswood in forum *nix
Last Post: 5th December 2005, 12:02 PM
Last Post: 10th November 2005, 04:09 PM
Last Post: 31st October 2005, 03:29 PM
By tosca925 in forum Windows
Last Post: 21st August 2005, 11:32 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)