CodeIgniter Forums
phpmyadmin problem - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Installation & Setup (https://forum.codeigniter.com/forumdisplay.php?fid=9)
+--- Thread: phpmyadmin problem (/showthread.php?tid=88102)

Pages: 1 2


phpmyadmin problem - medeino1964 - 07-22-2023

good morning to all,
It's the first time I use codeigniter4 and I am comfortable with it.
Otherwise I have a problem in a local installation (XAMPP) on my PC:  everything goes well
1. XAMPP installation is OK
2. codeigniter4 installation by composer is OK
3. I build a little DB with phpmyadmin
4. In .env file I put  the istructions to get db: 
#--------------------------------------------------------------------
# DATABASE
#--------------------------------------------------------------------

database.default.hostname = localhost
database.default.database = biglietti
database.default.username = root
database.default.password = ''
database.default.DBDriver = MySQLi
# database.default.DBPrefix =
database.default.port = 3306

as you can see I haven't put a password (it's a local installation so...) 
When I did the first operation with DB (i.e. write a record), the operation goes well, but, when I open phpmyadmin panel, I have this at the bottom of the page:
The phpMyAdmin storage configuration is not complete, so some additional features have been disabled. Find out why.
Alternatively, go to the 'Operations' tab of any database to configure it from there.
In particular, when I push privilege tab of all DB, I have this error:
Code:
                SELECT `User`, `Host`, `Select_priv`,
            `Insert_priv`,
            `Update_priv`,
            `Delete_priv`,
            `Create_priv`,
            `Drop_priv`,
            `Grant_priv`,
            `Index_priv`,
            `Alter_priv`,
            `References_priv`,
            `Create_tmp_table_priv`,
            `Lock_tables_priv`,
            `Create_view_priv`,
            `Show_view_priv`,
            `Create_routine_priv`,
            `Alter_routine_priv`,
            `Execute_priv`,
            `Event_priv`,
            `Trigger_priv`, '*' AS `Db`, 'g' AS `Type`
                FROM `mysql`.`user`
                WHERE NOT (BINARY `Select_priv` = 'N' AND
            BINARY `Insert_priv` = 'N' AND
            BINARY `Update_priv` = 'N' AND
            BINARY `Delete_priv` = 'N' AND
            BINARY `Create_priv` = 'N' AND
            BINARY `Drop_priv` = 'N' AND
            BINARY `Grant_priv` = 'N' AND
            BINARY `References_priv` = 'N' A[...]
Code:
Messaggio di MySQL:
Code:
#1030 - Rilevato l'errore 176 "Read page with wrong checksum" dal gestore delle tabelle Aria
Which kind of error did I do? The problem is that, after some times, I can't access anymore to phpmyadmin from Xampp panel , so I have to reinstall everything

Thanks in advance for your help
Amedeo



RE: phpmyadmin problem - InsiteFX - 07-22-2023

You need to go to this folder and install all of the sql files: C:\xampp\phpMyAdmin\sql


RE: phpmyadmin problem - medeino1964 - 07-23-2023

Excuse me, could you give me more details about the operation i have to do? Thsnks a lot


RE: phpmyadmin problem - medeino1964 - 07-23-2023

First of all thanks for your reply.
I have the last xampp version installed, w
 Where do you think that i can find the right files version needed?
Is it ok to go to phpMyAdmin site, download the last version and unzip the file needed?
Thanks a lot


RE: phpmyadmin problem - medeino1964 - 07-24-2023

Hi InsiteFx
I've downloaded phpmyadmin from its site, I've substituted all files of sql folder (stopping phpmyadmin and apache before), and I restarted all the services, but nothing changed.

Do you think that I made a mistake during this operation or it could be another reason?

Thanks a lot


RE: phpmyadmin problem - medeino1964 - 07-26-2023

May anyone help me, please?  Thanks


RE: phpmyadmin problem - InsiteFX - 07-26-2023

Then you may need ti edit the PhpMyAdmin config.inc.php file some things are remarked out in it.
Here is mine:
Code:
<?php
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */

/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'Your_Password_here';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';

/*
* End of servers configuration
*/



RE: phpmyadmin problem - medeino1964 - 07-27-2023

Hi InsiteFx,  
Thanks for your reply.
I have the same code in the same file (confih.inc.php) , see below: as you can see I don't update the default credentials during installation and i've applied same credentials in codeigniter eng : 
I really don't know what to do (when xampp denies me to access to phpmyadmin, i simply reinstall the files you said me in your first reply)
#--------------------------------------------------------------------
# DATABASE
#--------------------------------------------------------------------

database.default.hostname = localhost
database.default.database = biglietti
database.default.username = root
database.default.password = ''
database.default.DBDriver = MySQLi


PHP Code:
<?php
/*
 * This is needed for cookie based authentication to encrypt password in
 * cookie
 */
$cfg['blowfish_secret'] = 'xampp'/* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */

/*
 * Servers configuration
 */
$i 0;

/*
 * First server
 */
$i++;

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';

/*
 * End of servers configuration
 */

?>

  



RE: phpmyadmin problem - wdeda - 07-27-2023

Like you, I have a site installed locally that gives a lot of freedom of options, especially in relation to XAMPP. My choice was for a very light installation, that is, I only installed what I really intended to use. In addition to the mandatory Apache, MySql, I chose to use a personal version of phpmyadmin, i.e. a configuration independent of all interactions with XAMPP, without the need to use its Control Panel. To do so, I unchecked the phpMyadmin option during installation and at the end I created a folder called phpadmin, without the 'my', in xampp/htdocs/yoursite/public, looking like this: xampp/htdocs/yoursite/public/phpadmin.

I downloaded the installation files to this folder and later made the necessary changes to the config.inc.php file.
In the browser bookmarks I created a link to /localhost/phpadmin and everything works without any problems.
It is important to point out that this procedure does not directly change/interfere with CodeIgniter and XAMPP operations.
If you need it, for example, for future installations, just copy it to a pendrive.
Allow me one last suggestion: even though it is a local site, it is interesting to use a password, security should be a habit and not an option.
Good luck!


RE: phpmyadmin problem - JustJohnQ - 07-27-2023

You can also try Adminer:
https://www.adminer.org