Solved

phpmyadmin login problem

Posted on 2010-11-19
3
745 Views
Last Modified: 2012-08-14
Dear Experts:

Installed phpmyadmin in rhel5 did manual config bycopying the config.sample.inc.php to config.inc.php edited and the same is attached for your reference

after this when open firefox explorer with localhost/phpmyadmin iam getting like the below
phpMyAdmin
Welcome to phpMyAdmin
Language
Log in
Username:
Password:
Cookies must be enabled past this point.
Cannot load mcrypt extension. Please check your PHP configuration.
---------------------------------------------------------------------------------------
Please help in
1.how  should i be able to login in the above
2. how to fix the mcrypt extension

Please help thanks in advance.
configincphp.txt
0
Comment
Question by:D_wathi
3 Comments
 

Accepted Solution

by:
Fintel earned 250 total points
ID: 34171782
You can disable the mcrypt warning in the config.inc.php file.

mcrypt is not required to use phpmyadmin.

You have to change the $cfg['McryptDisableWarning'] variable in your config file.
0
 

Author Comment

by:D_wathi
ID: 34171798
Hi , i did a change in the auth_type like below changed cookie to config and
$cfg['Servers'][$i]['auth_type'] = 'config';

after this restart the httpd now opened the firewox with http:// locahost\phpmyadmin
still iam able to see  Cannot load mcrypt extension. Please check your PHP configuration. on the web page but able to login as root and the password.

Sir, if i try with the ipaddress of the system iam not getting webpage getting the error posted below
error
MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

---------------------------------
please help me in the following:
1. how to make the phpmyadmin accessible with the ip address
2. Cookies must be enabled past this point.
3.Cannot load mcrypt extension. Please check your PHP configuration.
please help.






0
 
LVL 13

Assisted Solution

by:dsmile
dsmile earned 250 total points
ID: 34172237
1. It's not phpMyAdmin problem, it's mysql's

You need to grant permission for 'root' user to access MySQL DB from specific IP

Use this command in mysql console.

GRANT ALL ON *.* TO 'root'@'your host IP';

2. It's phpMyAdmin's error that the only fix is install another version (as far as I know).
If you use auth_type 'config' or 'http' then it won't be a problem anymore.

3. Read this

http://www.linuxforums.org/forum/red-hat-fedora-linux/44539-installing-mcrypt-what-do-work-php.html
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Currency in SQL? 2 32
Wordpress Security 29 49
reverse engineer .sql from php files 11 35
MSSQL - Lock Row from reading by other programs 9 39
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question