Joomla 1.5 Super Administrator Help

I have access to the User Manager but I can't see a super administrator. I can only see me and the other candidates that have registered on the site.

I understand that. But what about MySQL access ? I propose you t change the super user password with the database directly not Joomla hitself
Do you have the l/p on your host server ?

Where do I find MySql access? I'm sorry, i'm only getting used to this site. What does L/p stand for?

Where is hosted you site ? On you own server or at hosting company ?
L/P : login / Password

Joomla work with a database, MySQL. All users accounts are in the MySQL database.
You can found login and password to the MySQL in the configuration.php (root folder of Joomla installation)
don't post it here

Once you have this code, depend where the site is hosted you will be able to change de super administrator password.

You will need to create a superadministrator and you will need to access the database to do this.

Back Up First  mysql database and website

I woudl advise you create another administrator user before you do this so you have more than one access route to your site

I am assuming you have access to this as you say you have looked at the database. So change yourself to Super administrator by -

Go to table: jos_users
1 - find your user name in the database
2 - in the column (field) usertype put Super Administrator
3 - in the column (field)  gid put 25

Save that table

Go to table: jos_core_acl_aro
-      make a note of the id number that correlates with your name

Go to table: jos_core_acl_groups_aro_map
-      find the row with the aro_id which matches the id number that you found above make the group id 25 for that user/id
Save that table

That should do it.

Our site is hosted with fasthosts.co.uk
How do I access MySQL?

Connect to fasthosts.co.uk cpanel / control panel
you need the login password too access.

You need to use a tools like phpmyadmin to access the mysql database

Oh I thought you had searched the database..?
You will have to ask your host how to access the database - if you have a cpanel access there is generally an option called phpmyadmin - but you will have to ask yoru hosts.

Assuming thene there is a superadministrator user already and you just need teh password, followthese instructions when you get in:
http://docs.joomla.org/Security_and_Performance_FAQs#How_do_I_reset_an_administrator_password.3F

Here the page to login in CPanel : https://login.fasthosts.co.uk/

If you don't have the account, I hope you have access to the mailbox of the employee.
So you can ask for a new password.

ok, i'm confused... I have logged onto fasthosts.co.uk and accessed the control panel. In the database area I see 'database name' - target, I see a server name and IP address.
It makes ref to mysql but i cant see anywhere to access the database...
I really dont think there's a super administrator setup on this site....
Please help...

Can you browse the panel and found phpmyadmin ?

You can try too : http://yourdomain/phpmyadmin

It it don't work you can try to connect from external, try from a command line :

telnet IPaddress 3306

Where IP address is the IP you saw in the panel

If the screen is cleared when you run "telnet IPaddress 3306" you have an external access to the database.

ok... I cant get access to the database through fasthosts.co.uk - I can log in but cant find the database entries anywhere on their site. On 'user management on joomla I can't find a super administrator.  
www.targetpersonnel.co.uk/phpmyadmin does not work...  What is tenet IPaddress 3306 mean - what is a command line... I'm sorry!

Don't worrie we are here to learn : command prompt : dos command

Go to Start Menu -> All program -> Accessories -> command prompt

or under XP, Start Menu > run, type cmd

I see on your site you can ask for a new password.
So you need to put admin as username and ask for a new password !
I hope again you have access to the mailbox of this employee

thank you... ok, i have the command option open - its a black screen that I put in telnet IPaddress 3306. I have also tried the IP address shown on fasthosts but all is coming back 'not recognised as an internal / external command

you have vista I presume...
Telnet is not installed by default.
Type : pkgmgr /iu:TelnetClient
 in command prompt to install it and do try the telnet command when successfully instaled of course.

to get a new password you need to enter an email address, not name.... good thinking tho ;)

Have you saw my last message ? You can ask for the admin password from your site by clicking on  "Forgot password" link

you know it's email address ?

I input pkgmgr /iu:TelnetClient and it downloaded something... what should i do now?

let him finish install the soft

i really have no idea whats happening lol. i've input the info in the command promt and nothings happening now... lol

OK. Try the telnet command now ;-)
Assuming its the address of your domain, you don't have external access...
Are you able to upload file on the site ?

the telnet command come back with the same message - is not recognised as an internal / external command. I can upload images to my site through joomla yes...

OK, good things. I will give you a script to overwrite the admin password.
Please wait.

thank you!

OK. I thin you don't have the mysql account so you need to connect first to the site not to upload image but to download the configure.php file from the main Joomla folder.

Open this file with any text editor and search this line :

var $host =
var $user =
var $db =
var $password

You have now your mysql database account.
replace localhost in the following code by the value found for $host
replace root in the following code by the value found for $user
replace database in the following code by the value found for $db
replace password in the following code by the value found for $password

Finally, most important, replace superuser by the account YOU use to connect as super user on Joomla
After modified the following script with your value, save it with a name of ou choice (don't post the name here in Experts Exchange) for security purpose
Upload the file at the root folder (where the configuration fil is) and call the page with your web browser.

http://yourdomain/scriptnameofyourchoice.php

<?php
    $connect = mysql_connect('localhots','root','password') or die("Connexion error to server !");
    mysql_select_db("database", $connect) or die("Erreur de connexion à la base");
    
    $result = mysql_query("SELECT password FROM jos_users WHERE username = 'superuser'");
    $row = mysql_fetch_array($result);
    $password = $row[password]; 
    $result = mysql_query("UPDATE jos_users SET password = '" . $password . "' WHERE username = 'admin'");
 
    mysql_close();
?>

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11: