If you accidentally delete your administrative account from the administrative control panel in Invision Power Board, you will need to register on your forum and access the forums database in order to make your newly-registered account an administrator. Follow the steps below to do this:
- Register for an account on your forum.
- If your forum is hosted on cPanel hosting, log in to cPanel and find the phpMyAdmin function.
- In phpMyAdmin, from the left, find the database which is associated with your forum. If you don’t know what this is, you will need to go to the File Manager in cPanel (or log in to your website through FTP, if you know how to do this) and find where your forum is installed and open the conf_global.php file. The $INFO[‘sql_user’] is the database you need to look at in phpMyAdmin. Your database name in the file may be listed as “username_forum” or something similar. Your database in phpMyAdmin will be listed as “_forum” in this case. Likewise, if it is listed as “username_ipb” it will be listed as “_ipb” in phpMyAdmin. Open the database from phpMyAdmin by clicking on it.
- Find the ipb_members table from the left of the next screen. From the right-side make sure you are on the Browse tab and you’ll see your account listed. Click the Edit link and find the “member_group_id” column. The value will currently be 1 – change this to 4 (administrator).
Ben's main IT experience is on software, programming, website development and marketing topics including search engine optimisation. At eUKhost, he regularly works alongside the marketing department on product marketing strategies, and in the development and quality control of the communications which are sent to customers and through the press distribution network. Aside from his regular collaboration with the marketing department on product marketing objectives, Ben occasionally works with the design department in conjunction with the management team on the development of new product pages and the stringent quality control requirements.
Latest posts by Ben Stones (see all)
- PHP 7 is now available! Find out what’s new. - December 4, 2015
- How to send POST/GET requests/data via PHP - May 15, 2015
- Google Mobile Search to be more favourable to mobile-friendly websites - March 5, 2015