Friday, February 6, 2009

PHP + MySQL + phpMyAdmin tips

1. If you see mcrypt extension is not installed (Cannot load mcrypt extension.) in phpMyAdmin login page . you need to enable it from PHP's php.ini. (which may be located in C:\PHP\ depends on how you isntalled your PHP package)

Make sure you remove all the remove the semi-colon (;) right in front of them to enable these extension.


you will also need to restart IIS or OS in order to load libmcrypt.dll (mcrypt's dll)
Of course, you will need to make sure you have libmcrypt.dll in your computer.

See more info here-

2. If you see Phpmyadmin White / Blank screen after you type in the account and password:
Solution: There must be a typo in the file. The easier way is to delete it and copy the default again.

Of course, you will need to reset all the config including password.


3. In phpMyAdmin, if you see "Create new database: No Privileges", this means your current account does not have enough privilege to create new DB.

You can create a new account for phpMyAdmin. For example: pma@localhost

Login to MySQL Console, enter the following commands:

CREATE USER 'pma'@'localhost' IDENTIFIED BY 'your_password';
Flush privileges;
Grant all on *.* to 'pma'@'localhost' identified by 'your_password';
Flush privileges;

Then re-login to phpMyAdmin.

Other good references:

No comments:

Post a Comment