phpMyAdmin

[Ray]

I have recently set up a Wordpress blog on my home server, I have managed to install Wordpress, PHP and Mysql database and get everything working correctly, but I am trying to use phpMyAdmin to manage the database I have got this installed but when I try to login to phpMyAdmin I am getting the error shown in the attached image.

Does any one have any experience of using this application and know how to solve this error everything in the php ini file seems to be configured correctly with the appropriate extension present and enabled?




[attachment deleted by admin]

[Rik]

Lance may, Ray, I leave all that kind of tinkering to him.

[Ray]

Lance may, Ray, I leave all that kind of tinkering to him.

Thanks, Rik, I don't blame you it's not easy setting these sort of things up, took me several hours over 2days to get Wordpress, php and mysql set up and talking to each other and then being able to access the blog pages. 

[Rik]

You should have just used IDNet's, Ray.

[Ray]

You should have just used IDNet's, Ray.

I know, Rik, I like a challenge. 

[Rik]

I would have thought the dogs provided enough of one.

[Lance]

I haven't used phpMyAdmin here for a little while (no need to!) but I recall we also get that error. However, it doesn't seem to affect me logging in so I'm afraid I can't be of any help!

[somanyholes]

i presume you have installed mcrypt?

[Rik]

If no-one here has the answer, Ray, it might be worth a call to support...

[Ray]

If no-one here has the answer, Ray, it might be worth a call to support...

Thanks, Rik, I think I'll adopt Lances approach and manage without it as the the blog works fine, it's just that it gives you a graphical interface to the mysql database instead of using the command line one. I was just curious if any one knew how to get it to work because it seems searching the web others have hit the same problem.

[Ray]

i presume you have installed mcrypt?

Yes, Sebby it's installed in the php directory where it should be. 

[Rik]

Thanks, Rik, I think I'll adopt Lances approach and manage without it as the the blog works fine, it's just that it gives you a graphical interface to the mysql database instead of using the command line one. I was just curious if any one knew how to get it to work because it seems searching the web others have hit the same problem.

It's just possible that James or Brian could give you a hand, Ray, Martin almost certainly would know the answer if he's around.

[zappaDPJ]

I'm not an expert but that error message suggests mcrypt is not enabled in php.ini or that there are files missing, probably the former. You probably need to enable it and restart the server.

Rather than risk handing you a loaded gun as I'm so out of touch with it, I'll wait and see if someone with more knowledge than me comes along.

[Simon]

If no-one here has the answer, Ray, it might be worth a call to support...

I think Sam, on PC Pals, has used PhpMyAdmin, Ray, so it might be worth posting on there, or PM'ing him (tell him I said so), if you prefer. 

[Ray]

I think Sam, on PC Pals, has used PhpMyAdmin, Ray, so it might be worth posting on there, or PM'ing him (tell him I said so), if you prefer. 

Thanks, Simon, I''l give that a go. 

[Simon]

Good luck, Ray!  Sam usually pops in daily, so hopefully he'll pick it up soon. 

[psp83]

Create a page called phpinfo.php, in this page, type the following

Code Select Expand

<?php echo phpinfo(); ?>

Upload/move the page to your server and load this page in your browser and look for the following to see if mcrypt is activated.

See attached pics.

That error shouldn't stop you from logging in.

If you can't login, check you have setup the correct details in the phpmyadmin config.inc.php

Example config.inc.php

Code Select Expand


$cfg['blowfish_secret'] = 'PUT RANDOM THRASE HERE'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

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

/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'YOUR DB, NORMALLY localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['only_db'] = 'YOUR DB NAME HERE IF YOU ONLY WANT TO ACCESS ONE DB';

/* rajk - for blobstreaming */
$cfg['Servers'][$i]['bs_garbage_threshold'] = 50;
$cfg['Servers'][$i]['bs_repository_threshold'] = '32M';
$cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;
$cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';

/* User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* 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';
/* Contrib / Swekey authentication */
// $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';

/*
* End of servers configuration
*/

/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';


When at the phpmyadmin login screen, username is your database username and password is the password you set for your database.

[attachment deleted by admin]

[Ray]

Thanks, Paul, looks like mcrypt isn't activated, though I am unable to log in but it loks like I need to sort out the config.inc.php file there isn't one at the moment only a sample file. I'll have another play with it over the weekend.

[psp83]

Thanks, Paul, looks like mcrypt isn't activated, though I am unable to log in but it loks like I need to sort out the config.inc.php file there isn't one at the moment only a sample file. I'll have another play with it over the weekend.

No prob. phpmyadmin is easy to setup once you've done it. Building a linux server from start is, well. alot harder!  , Been there, done that, bought the T-shirt etc etc. 

[Simon]

Also a reply to this on Pals, neither of which I understand a word of! 

[psp83]

Also a reply to this on Pals, neither of which I understand a word of! 

Wish i was the same. This job can be a right $%#&er sometimes.

[Ray]

Also a reply to this on Pals, neither of which I understand a word of! 

Thanks , Simon, I've seen that as well, won't get a chance to have a play until Sunday though I'm out all day Saturday. 

[Simon]

Let us know how you get on Ray, and have a good day tomorrow. 

[jane]

I had a horrible time with this when setting it up to run phpgedview (as a test on my own PC). I can't really remember exactly how I cracked it but it revolved around editing the config.inc.php file, specifically the setting of the user name and password.

Here's all I have in my config.inc.php file

<?php

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'mysql';
$cfg['Servers'][$i]['hide_db'] = '(mysql|information_schema)';

/* End of servers configuration */

$cfg['DefaultLang'] = 'en-utf-8';
$cfg['blowfish_secret'] = '';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>

I think that's the area where you should be looking perhaps?

[Ray]

Thank you, Jane, that's solved my problem by putting the user name and DB password in the config file, I can now access the database from phpmyadmin.    and

[Sebby]

Great result.

[psp83]

Thank you, Jane, that's solved my problem by putting the user name and DB password in the config file, I can now access the database from phpmyadmin.    and

Putting your user and password into the config.inc.php is not very secure if your server is online, anyone going to the phpmyadmin folder on your domain can get access. If this is the case for you then i would password protect the directory.

[jane]

That's great. I did say I was using it on a local test PC but should have stressed the security issues. Having said that, being able just to get into the thing is a start. I gave up on it umpteen times before it clicked and that was only after reading between the lines on the so-called help forums. I'm going to have to write this down so I don't forget it now 

Cheers 

[Rik]

The forum does its magic again. Thanks, Jane.

[Ray]

Putting your user and password into the config.inc.php is not very secure if your server is online, anyone going to the phpmyadmin folder on your domain can get access. If this is the case for you then i would password protect the directory.

Thanks, Paul, that thought did occur to me, so I've disable anonymous user on the directory security tab and set it to require Windows authentication in the IIs server properties for the folder. 

[psp83]

Making PHP My Admin work the way you want it to work requires a computer science degree.

I hate setting it up and i'm a web developer! 

[Ray]

Making PHP My Admin work the way you want it to work requires a computer science degree.

I hate setting it up and i'm a web developer! 

I've got to agree with you there, Paul, I've been playing with the config file again and there's no way I can get it to login unless I set the auth_type to 'config'. I've got the directory tightened down now so that when you try to access it you get a Windows user name and password box come up and there's only one user allowed to access it.