Category Archives: phpmyadmin

how to change phpmyadmin theme

Posted by —

3

I just don’t want the default theme that came in with PHPMyAdmin they are huge and my eyes hurt when I look at them. If you are like me that doesn’t want to take extra step to develop themes and just want to have it appear smaller then this procedure is for you.

Enjoy!

find the next auto_increment number in mysql

Posted by —

0

Finding the next auto_increment is easy on phpmyadmin. Just select your database from the left side dropdown box. Then select the table on the lower part of it. Then click structure.

But what if it’s in mysql? or in PHP?
In PHP:

<?
$tablename         = “tablename”;
$next_increment     = 0;
$qShowStatus         = “SHOW TABLE STATUS LIKE ‘$tablename’”;
$qShowStatusResult     = mysql_query($qShowStatus) or die ( “Query failed: ” . mysql_error() . “<br/>” . $qShowStatus );

$row = mysql_fetch_assoc($qShowStatusResult);
$next_increment = $row['Auto_increment'];

echo “next increment number: [$next_increment]“;
?>

source: http://blog.jamiedoris.com/geek/560/

In MySQL prompt:

SHOW TABLE STATUS LIKE ‘tablename’;

restrict access to phpMyAdmin by authentication

Posted by —

2

Wondering how authentication/log-in form will be implemented in xampp? This edit in config.inc.php will handle the job.

The path for the configuration script is <your-xampp-installation-path>\phpMyAdmin\config.inc.php.

This line configures the authentication used by phpMyAdmin in accessing it:

$cfg['Servers'][$i]['auth_type'] = 'authentication method here'; // Authentication method (config, http or cookie based)?

Note:

If you replace the use authentication method here with:

config
- it will use the password and username from the configuration file. Remember the last tutorial? (read it here)

http
- will use the http authentication of Apache(secure/recommended settings)

cookie
- will use the database for username in authentication and will require browsers to allow cookie. (secure/recommended setting)