?
Solved

little bit problem with PHPMyAdmin...

Posted on 2006-05-10
25
Medium Priority
?
349 Views
Last Modified: 2012-08-14
Hey Experts,
                 I have installed PHP 4.3.6 and also installed MySQL and PHP is successfully configured with MySQL. Then i installed PHPMyAdmin it's also running well.
   but when i go to PHPMyAdmin(C:/phpmyadmin/index.php) the page browses successfully but gives a red error message at the bottom of the page. The error message is:

"The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration file!
The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results."

                  I guess that it will not effect big on my PHP working. but i wana know that what's the problem and where is the problem and what's it's solution?
0
Comment
Question by:RizwanAbasi
  • 14
  • 11
25 Comments
 
LVL 12

Expert Comment

by:str_kani
ID: 16650342
The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration file!

you fix this by setting the vlaues in the configuration file (config.inc)
0
 
LVL 1

Author Comment

by:RizwanAbasi
ID: 16650485
i've given the user =root
                    password=pass
 but i  was wrong PHP is not working with my SQL when i run a page , gave the following errors,
Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in E:\websites\php\_add.php on line 3

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in E:\websites\php\_add.php on line 4

Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\websites\php\_add.php on line 12

Warning: mysql_query(): A link to the server could not be established in E:\websites\php\_add.php on line 12

Warning: Cannot modify header information - headers already sent by (output started at E:\websites\php\_add.php:3) in E:\websites\php\_add.php on line 13
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 12

Expert Comment

by:str_kani
ID: 16650557
Ok, before running your files... try this

<?php
$link = mysql_connect('localhost', 'root', 'pass');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
0
 
LVL 1

Author Comment

by:RizwanAbasi
ID: 16651175
i 've previously checked this and it is ok.
        Connected successfully.
0
 
LVL 1

Author Comment

by:RizwanAbasi
ID: 16651230
last time i installed PHP manually and this time i used PHP installer to install PHP.
 after installing through installer i can't find the file config.inc-dist in PHP folder.
0
 
LVL 12

Expert Comment

by:str_kani
ID: 16651264
It's not recomented to install PHP using the installer, It's better to remove the current installation and install php manually...
0
 
LVL 1

Author Comment

by:RizwanAbasi
ID: 16651367
let me remove the current installation and install it manually.
0
 
LVL 1

Author Comment

by:RizwanAbasi
ID: 16651549
what should be it's value?
$cfg['PmaAbsoluteUri'] = '';

in config.inc.php

in line#39
0
 
LVL 12

Expert Comment

by:str_kani
ID: 16657352
the url by which you are going to access php myadmin,

example http://localhost/phpmyadmin/index.php
if you are running this from your local machine...

$cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/index.php';
0
 
LVL 1

Author Comment

by:RizwanAbasi
ID: 16660078
I have reinstalled PHP by installer but can't solve my problem.I've entered this value you told me but fruitless.
0
 
LVL 1

Author Comment

by:RizwanAbasi
ID: 16666057
Can some one help me?
0
 
LVL 12

Expert Comment

by:str_kani
ID: 16666088
are you getting the same old error message? or something new?
0
 
LVL 1

Author Comment

by:RizwanAbasi
ID: 16666132
The following error appeared.

"The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results."
0
 
LVL 12

Expert Comment

by:str_kani
ID: 16666166
you copy the php_mbstring.dll to your windows dir (c:\windows\system)
and uncomment the following from your php.ini (in c:\windows\php.ini)

;extension=php_mbstring.dll

After that, restart your webserver IIS/Apache then you should no longer see the problem.
0
 
LVL 1

Author Comment

by:RizwanAbasi
ID: 16666167
last time i had encountered the same problem and posted also a question.

http://www.experts-exchange.com/Web/Web_Languages/PHP/PHP_Databases/Q_21753520.html

and i am increasing the points bcz i have not much points.
0
 
LVL 12

Expert Comment

by:str_kani
ID: 16666223
no problem with the points...
let me know what happens when you follow my last comment...

you copy the php_mbstring.dll to your windows dir (c:\windows\system)
and uncomment the following from your php.ini (in c:\windows\php.ini)

;extension=php_mbstring.dll

After that, restart your webserver IIS/Apache then you should no longer see the problem.
0
 
LVL 1

Author Comment

by:RizwanAbasi
ID: 16666283
HTTP 400 - Bad Request

this message appeared.
0
 
LVL 1

Author Comment

by:RizwanAbasi
ID: 16666298
i think i should reinstall php and phpmyadmin may be it can solve my problem.
0
 
LVL 12

Expert Comment

by:str_kani
ID: 16666302
are you working on your local machine or internet? can i have a look if it's on the internet...?
using IIS or apache...?

before going to the next step, take a look at this...

http://codewalkers.com/forum/index.php?action=displaythread&forum=phphelp&id=562&realm=default

same problem as yours, but on a linux machine.

0
 
LVL 1

Author Comment

by:RizwanAbasi
ID: 16666325
I am working on a local machine using IIS and WIndows XP Professional.
0
 
LVL 1

Author Comment

by:RizwanAbasi
ID: 16666382
Ah still unsuccesfull after visiting the link even this method worked with most of the users. I don't know why it's unsuccessful to me.
                             Let me uninstall n reinstall PHP.
              let's see what happens.
0
 
LVL 12

Expert Comment

by:str_kani
ID: 16666424
are you installing php manually or with installer? donot try with installler.
0
 
LVL 12

Accepted Solution

by:
str_kani earned 800 total points
ID: 16666569
php_mbstring is not enabled by default

For Windows users php_mbstring can be added as follows:-

if you have dowloaded  the "short" version of PHP, (php-4.3.10-installer.exe), download the full version . (php-4.3.10-Win32.zip)

unzip it, find php_mbstring.dll in f:\php-4.3.10-Win32\extensions, and copy it across to your php\extensions directory

use Notepad to open your PHP.INI

change the extension_dir line to read extension_dir = "e:\php\extensions\"  (or whatever your directory is called)

remove the semi-colon on line
 ; extension=php_mbstring.dll

save PHP.INI,  restart webserver.... this should do that.
0
 
LVL 1

Author Comment

by:RizwanAbasi
ID: 16674876
Dear  str_kani ,
                    Before posting the question, I did all the above processing while and after installing PHP but these two errors were still there. I came to know that i can work having these errors. However i have to work on PHP MYSQL because i don't have time. MySQL works approx fine.
                 However, I am really thankful to you that you helped me alot. I appreciate your efforts.
              Thank you very much.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
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 count occurrences of each item in an array.
Suggested Courses

612 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