Nov 21, 2009

Installing Apache, Mysql, Phpmyadmin Locally - Solving the "php_mbstring.dll missing"

free web hosting
Open Discussion > MODERATED AREA > Trapper's Secret HideOut

Installing Apache, Mysql, Phpmyadmin Locally - Solving the "php_mbstring.dll missing"

ongnoai
Since Trap17's CP provide the individual site's owner with goodies like MySql and PhpMyAdmin, chances are some will want to make use of them.

Well, it's fine enough to get that on one's host (Gee! Thanks a lot, Trap17...) Knowing how the usual geek react, it might be expected that most people considering to make use of a database on their site will want to do most of the tedious job of developing and testing on their own local system before sending the wrapped-up result on their domain/subdomain.

This involves four basic steps (sorry for the compuwizs, this tutorial is merely for beginners, and beginners on Windows 2000/XP at that):
1. Install a local Apache server,
2. Install a MySql local server,
3. Install locally PhpMyAdmin,
4. Install Php.

Now, there is a way to do the *damn* 4-steps thing in one shot, and that's to use XAMPP, which you will find at:

http://www.apachefriends.org/en/xampp-windows.html

As far as I know, XAMPP does the job like a charm, but I didn't insist on going this way, so I can't tell for sure.

I'm among those pig-geaded guys willing to keep control over things (as I'm sure many Trap17 users also are), so I'd rather do the 4 steps myself just to make sure I understand what the *Hell* I'm doing. Those interested will find excellent pages about the whole installing process starting at :

http://www.devarticles.com/c/a/Apache/Inst...-under-Windows/

Those growing impatient can find something even shorter at:

http://www.sematopia.com (be patient, their server is sometimes a bit slow, it's near the end of the page you get).

Now, this tutorial is meant to address what you get after the above installation process is completed. If you proceeded according to the guidelines reported above, you should have a php.ini files located in your c:\Program Files\Apache Group\Apache2\directory. Wait! There comes the catch if you installed a Php 4.3.9 or 4.4.1 version (I dunno if this happens with Php V 5+).

Testing the whole installation implies you open a page within your favorite browser and then type http://localhost/phpMyAdmin. Careful with the typing, browsers are very much case-oriented. That's precisely when you get a silly message telling you that it can't locate a "php_mbstring.dll" which is (according to what I know) some stuff related with displaying oriental characters using the Utf-8 coding. And unfortunately Utf-8 is the most widely accepted coding among developers and DB developments these days.

If you don't want to spend hours on the Web trying to get a rather elusive info, here's what I suggest:

1. Open the php.ini with your favorite editor (notepad, Wordpad, whatever), c:\Program Files\Apache Group\Apache2\php.ini and find the line:
extension_dir = "./" (there's only one line of this kind), and replace it with :
extension_dir = "c:\php\extensions" exactly as written here,

1.1 optionally. You might also want to uncomment (erasing the semicolon at the beginning of the line) the loading of php_mbstring.dll. For that, you have to fetch the line ;extension=php_mbstring.dll (windows extensions, near the end of the php.ini script) and uncomment it in the form extension=php_mbstring.dll. I'm not absolutely sure it's really necessary though, since I saw no influence of that on my PhpMyAdmin local testing and using.

2. Stop the Apache server (Programs>Apache HTTP Server 2.0.52>Control Apache Server>Stop).

3. Start again the Apache server (Programs>Apache HTTP Server 2.0.52>Control Apache Server>Start),

4. Try again to get to http://localhost/phpMyAdmin. It should work without an error message, now.

Good luck cool.gif

 

 

 


Comment/Reply (w/o sign-up)

Inspiron
Wasted... you should make this post to the Tutorial section..
Very good one for people trying to make a server out from their computer..

Comment/Reply (w/o sign-up)

FeedBacker
Replying to ongnoai

I know this is an old post, but it dolveda problem for me!

Thank you!

-reply by Steve Adams

Comment/Reply (w/o sign-up)

FeedBacker
Hi, please help for this error!!!!!!!!
Installing Apache, Mysql, Phpmyadmin Locally

Could not connect to the database. Connector returned number: Unable to connect to the database:Could not connect to MySQL

This error occur when iam installing joomla

-reply by anil

Comment/Reply (w/o sign-up)

bluechip
Yeah I also would like to agree with- what was the name again- who said this post was supposed to be posted under Tutorials. It is quite helpful and it's so generous of u to sit down and write such a long post so that some of us dummies can understand a subject keep up the good work.

Comment/Reply (w/o sign-up)

dave2win
You guys can use WAMP or WAMPP.

Both are basically same but the only difference is that WAMP has no Perl where as WAMPP has got Perl Support.

WAMPP is a variant of XAMPP which is available at Apachefriends.

They have WAMPP listed in their Sourceforge Repository.

But for newbies I would personally recommend WAMP as it is much much simpler & runs almost instantly & very fluently on any Win 32 machine. I don't know about its Linux Counterpart but I hope Wine will do a pretty good job.


Comment/Reply (w/o sign-up)



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)

Similar Topics

Keywords : installing, apache, mysql, phpmyadmin, locally, solving, php, mbstring, dll, missing

  1. Mccodes With Mysql! [resolved]
    I need help with this topic (6)
  2. Mysql Server Down
    (10)
    mysql (5.0.51a-community) failed What is happening? And btw, sometimes I get a message: could not
    connect with mysql server. I use joomla 1.5 . but now, the server is down as shown on Server
    status... please help....
  3. Mysql Database Not Working
    (3)
    well i'm getting an error message(a databass connection warning) for all of the parts of my site
    that connects to a mysql database i check my database users pertmissions and i try to do the repair
    database thing and it's still not woeking. am i the only person having this or is it an overall
    trap17 issue and how do i fix it.....
  4. It Went Well For A While
    MySQL problem back in all its glory. (5)
    Some time ago I had a stubborn problem when trying to access one of the interactive pages on my
    website and getting the following error: QUOTE Warning: fopen() : open_basedir restriction in
    effect. File(include/errors.xml) is not within the allowed path(s):
    (/home/mrdee:/usr/lib/php:/usr/local/lib/php:/tmp) in
    /home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Warning:
    fopen(include/errors.xml) : failed to open stream: Operation not permitted in
    /home/mrdee/public_html/admin/include/commonfunctions.php on line 682 Cannot open XML data file:
    incl....
  5. Movable Type 4
    Installing (0)
    Hi guys. I have a problem here installing Movable Type 4. Has anyone installed it on Trap 17 servers
    before? I would need a detailed installation description, as I had many problems installing it here,
    possibly due to the server behaviours at Trap 17. Thanks.....
  6. Cms & Phpmyadmin
    need some help (3)
    Alright first I wanted to edit mysql databases that was created from using the site program features
    phpchat and and cms Nucleus, whenever I tried to login to my phpadmin I'd get an error saying
    session.save no space available error something like that. I was able to use phpmyadmin earlier but
    now it's unusable, I tried deleting some tmp things but no luck, and I removed the php stuff I
    added in to increase web space but no luck. I'm kind of a newbie when it comes to Linux but I am
    learning some at the moment. My other question is I have this custom CMS I wa....
  7. Is The Database System Gone Again? [resolved]
    Errors on PHPMyAdmin again (12)
    I wonder if there is a problem with the PHPMyAdmin system again? When trying to get into it, I once
    again get the following: QUOTE Warning: session_write_close() : SQLite: session write query
    failed: database is full in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42
    Warning: session_write_close() : Failed to write session data (sqlite). Please verify that the
    current setting of session.save_path is correct
    (/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in
    /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42 Warning: Ca....
  8. Phpmyadmin Problem [resolved]
    (2)
    PHPMyAdmin Problem CODE Warning: session_write_close() : SQLite: session write query failed:
    database is full in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42 Warning:
    session_write_close() : Failed to write session data (sqlite). Please verify that the current
    setting of session.save_path is correct
    (/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in
    /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42 Warning: Cannot modify header
    information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty....
  9. How Do I Find My Mysql Password? [resolved]
    Cannot access my MySQL (5)
    After all the recent problems, my account has been restored. I have setup my parked domain agin, and
    that works fine. However, I can no longer access my MySQL databases (I can from PHPMyAdmin, but
    that's all). I had to create a new user for my databases, and created the user with exactly the
    same username and password I had before, but some of my web pages do not let me access the pages I
    have associated with my databases. Where could i find out what my DB password is? (Although I am as
    good as sure I am using the right one). I have tried my old password, the new c....
  10. Remote Access Mysql
    (8)
    Is it possible to directly access my local database from my website? For example, if somebody
    submits info on my website, the info they submitted would be transferred to my local database
    directly. Is that possible? And if so, how do I set that up? The reason I don't want to upload
    my database to my subdomain is because it would be difficult to keep the website database and my
    local database in sync . . . or is there a way to do that? Thanks for any replies.....
  11. Phpmyadmin
    Create new database: No Privileges (7)
    i can not make a sql for diff srcipt, but the sricpt i have is php, DJ-cpanel.. all tho i can not
    install it the error is like this Creating Database Tables No database selected there a mysql
    database is made, but i can not use it for othere stuff... plz note that this is Free script and not
    for paid.. is there a way that the myqsul can not use sql other scripts? or it maybe not working...
    but i am not sure if the script not working or it can be the server may be down on mysql...? ....
  12. Phpmyadmin Error [resolved]
    (7)
    I get this error message each time I attempt to work phpMyAdmin. QUOTE Cannot start session
    without errors, please check errors given in your PHP and/or webserver log file and configure your
    PHP installation properly. Help would be very grateful.....
  13. Phpmyadmin Error
    Not able to enter PhpMyAdmin (4)
    Currently I try to access my PhpMyAdmin and I get the following error displayed among the screen:
    My PhpMyAdmin worked prior the migration but suddenly stopped working after. I wanted to know if
    anyone else is getting this error also or anyway can help me fix this o.o.....
  14. Installing Custom Fonts...
    (5)
    Is there any way to install custom fonts? Like I've got a few fonts here that I would like to
    install for my website. Is there any way to install them? So how can I install them? Would it even
    be possible to install them?....
  15. Successfully Installing Joomla [resolved]
    Has anyone done it? (2)
    Hello everyone, I was wondering if anyone around here has successfully installed Joomla on their
    Trap17 web space. If so, what was your solution to the session save path dilema? I attempted to make
    a custom php.ini with no luck and also attempted to edit the htaccess.txt file. All of these
    solutions yielded no result, my session save path is still not set, and I can't properly install
    Joomla 1.0.13. Should I try using 1.5 RC4? I doubt that would matter, any advice or help is greatly
    appreciated /laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt=....
  16. Question About The Upgrade And The Mysql Usage ?
    question about the upgrade and the mysql usage? (3)
    thanks for the upgrade but i do have question about it QUOTE Domain name zam.trap17.com
    Hosting package Beta Subdomains 3 / 99 Parked Domains 0 / 9 Addon Domains 3 / 9 Mysql databases
    1 / 99 PostgreSQL Databases 0 / 99 Disk usage 14.25 / 500.00 MB MySQL Disk usage 0.82 MB
    Disk space available 485.75 MB Bandwidth (this month) 6.59 / 10240 MB Email accounts: 1 / 99
    Email forwarders: 1 / unlimited Autoresponders: 0 / unlimited Email filters 0 / unlimited
    Mailing lists: 0 / 99 FTP accounts 3 / 99 1-Bandwidth (this month) 6.59 / 10240 MB ....
  17. Changes In Phpmyadmin
    Access to my database from program not working anymore. (0)
    I was wondering if something has changed in the MySQL or PHPMyAdmin section of Trap 17. (Hope I am
    explaining this correctly). I run a newsletter system on my website and the details of the people
    who subscribed are in a MySQL database. To get those data from the database and to send the
    newsletter to all subscribers I use a program called "Qios Pelican". Up to now it always worked
    perfectly, but now it cannot seem to retrieve data anymore, yet I have not changed anything to my
    setup. I use the MySQL OLEDB Provider driver to connect, and in case it helps, here are the ....
  18. Installing Theme On Smf Forum
    Need help doing it! (4)
    I was wondering, and I am horrible with Cpanels mind you, how to install a new theme. I have an smf
    discussion board and I decided to download a theme from the theme place for smf. So it downloads,
    and appears in winrar. When I extract it, it comes with a big pile of files, with 2 folders:
    Language, and Images. First question is: Do I install these somewhere in the 'File manager'
    in cpanel? Ok if yes: Where? Third: Do the main files, language , and image go in different
    places? Fourth: There is about 4584305834098 image files, is there a quicker way to get ....
  19. Installing Ffmpeg
    (7)
    Hi. Iīm having a real big problem installing ffmpeg on my site... Can any of you guys explain to
    me (as if I was 10 years old) please... I would like to test it on one of my sites here @ trap 17
    but I canīt install it... Thanks in advance....
  20. Installing Joomla And Shell Question
    i get error when i trayed to install joomla i get some (0)
    i get error when i trayed to install joomla about the default premising check this out i have set
    the file premising to 777 and to 755 and the same problem what to do where to fix this
    http://zam.trap17.com/earn-money/installation/index.php and in my hosting plans i did see shell
    access but i cant it at my cpanel why ??? ---UPDATE--- will i have been able to install joomla
    thanks but i still asking about the shell account double post merged ....
  21. Having Problems With Installing Ipb 2.3.x
    I need help please. (2)
    I was trying to install IPB 2.3.3 for my forums database and this is the error message I got as I
    was starting the installation. mySQL query error: CREATE TABLE ibf_admin_logs ( id bigint(20) NOT
    NULL auto_increment, act varchar(255) default NULL, code varchar(255) default NULL, member_id
    int(10) default NULL, ctime int(10) default NULL, note text NULL, ip_address varchar(255)
    default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; SQL error: Table 'ibf_admin_logs' already
    exists SQL error code: 1050 Date: Wednesday 22nd of August 2007 02:25:45 AM I hav....
  22. Does Trap Use An Apache Server [resolved]
    (3)
    Well I just installed a mod, and it said you must have an Apache Server or something. SO does trap
    use an Apache Server and if not is there anyway we can since it says its free....
  23. Is It Possible To Access The Mysql Remotely?
    (10)
    I like to experiment with a lot of things and I was thinking of making a sort of instant messenger
    in Python, but I want to let people have actual accounts so I need to be able to access the mySQL
    remotely. If that's not possible, are we allowed to run Python scripts on the server?....
  24. How To Crate Mysql Database?
    urgent help (7)
    Hi everyone!
    I'm trying to make in my site a page system that allows me to create users
    account (with a foto for every user)...
    I'm doing that in PHP, I learned all I have to
    know about PHP and MY SQL. I know how to make new array and querries in the data base, only 1 think
    is messing: ....
  25. Help Moving Mysql Files To A New Host
    IPB files (2)
    Well, my partners on my forum has decided to move our site to a newer host. A paid one to be exact.
    And we did that already. Now all we need to do is move our forum over to the new host. We want to
    do this without losing all of our posts and other data. I know it has something to do with the MySQL
    files but I don't really understand it. Some help would be appreciated. We are running Invision
    Power Board 1.3.1 final Also, we're thinking about upgrading our board to a newer version of
    IPB because we heard that its better in more ways than one. But then again, it....
  26. Table Duplication
    How to do it with phpMyadmin (5)
    So how can I dublicate table to the same database using phpMyadmin? I realy do not want do the
    almost the same table specially then table has many colums. Or maybe it's inposible
    /huh.gif' border='0' style='vertical-align:middle' alt='huh.gif' /> (actualy I don't think so)....
  27. Setting Up A Remote Mysql Connection
    Need help! (3)
    Okay... I'm hosted here on Trap17. I would like to connect to a remote MySQL database located on
    another server... can someone walk me through what I need to do to set this up, or if it can even be
    done? Thank you in advance!....
  28. Mysql Database Setup : Setting Up Mysql Database
    Guide to use MySQL database in your site (7)
    A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
    problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
    server. You can access it using the link in Cpanel. Cpanel can be accessed by
    "www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
    3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
    : IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE....
  29. Track Our Posts...
    i am missing replies :( (8)
    Is there a way to find out only my posts that have had a recent reply? I missed answering to many
    because i couldn't keep track of them all! We can see all our posts by clicking on our name and
    then 'view all our posts', but I have 8 pages of posts! I have to go thro' all to look
    for replies... is there an easy way? Thank you Googlue!....
  30. MYSQL Settings
    (5)
    I am going to edit my mysql settings. Before i had freesql.org but that's slow. So now i
    created one here. What is the host? What must i put in the server.....

    1. Looking for installing, apache, mysql, phpmyadmin, locally, solving, php, mbstring, dll, missing

Searching Video's for installing, apache, mysql, phpmyadmin, locally, solving, php, mbstring, dll, missing
See Also,
advertisement


Installing Apache, Mysql, Phpmyadmin Locally - Solving the "php_mbstring.dll missing"

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com