WordPress.org

Ready to get started?Download WordPress

Forums

my php doesn't find mysql (26 posts)

  1. davidvaldez
    Member
    Posted 9 years ago #

    Trying to install WordPress 1.5.1.1 on a Fedora Core 3 system. I get the following message when I run install.php:

    Your PHP installation appears to be missing the MySQL which is required for WordPress.

    However ... i can log on both as root and as the user I've defined for wordpress onto mysl from the command line. The database, username and password in config.php is correct (and all work from command line).
    I have mysql server 4.0.34, php 4.3.11, and php-mysql 4.3.11 all showing as installed rpms.

    Is there a configuration file for php that I should be checking for path? Any other ideas?

  2. moshu
    Member
    Posted 9 years ago #

    Put that error message in the search box (top right)

  3. leQ
    Member
    Posted 9 years ago #

    i've read about a hundred posts trying to find other windows users with the problem of this:

    Your PHP installation appears to be missing the MySQL which is required for WordPress.

    getting shoved down our throats. i have done some of the things that seem to have helped others, but didn't work on my system. i'm getting frustrated with it actually. if MT is fine with php & mysql, why would wordpress be bitchy about some 'missing database'. is this a perms issue? or an IIS issue? cuz, can't be a database issue because IT HASN'T BEEN CREATED YET.

    sorry, but i'm pulling my hair out over this.

  4. Mark (podz)
    Support Maven
    Posted 9 years ago #

    leQ - what is your OS / WAMP setup ?

  5. leQ
    Member
    Posted 9 years ago #

    using IIS on XP pro.

    and thanks!

  6. leQ
    Member
    Posted 9 years ago #

    what is WAMP? windows authentication?

  7. Mark (podz)
    Support Maven
    Posted 9 years ago #

    I'm on XP Home - no IIS.

    WAMP: Windows Apache Mysql Php

    I have zero experience with IIS. I don't know why you want to use IIS as opposed to anything else (unless it's just because it is there ?) but I have experience - and totally recommend Xampp).
    You can download it from here:
    http://www.apachefriends.org/en/xampp.html
    and it is incredibly easy to use - one click install.

    You will need to stop IIS though as they compete for ports.

    Sound useful ?

  8. leQ
    Member
    Posted 9 years ago #

    i just installed it, and will let ya know how it goes. i hate to feel that wordpress beat me, hence i feel compelled to get it working for some inane reason. i just really like the look of wordpress as opposed to the other engines out there.

  9. leQ
    Member
    Posted 9 years ago #

    i can't tell you how much i appreciate your pointing me to xampp.

    thank you thank you thank you.
    you are the man (or woman)

  10. mcleaver
    Member
    Posted 9 years ago #

    I have just done the famous 5 minute install to my ISP's system. But of course WordPress announces it cannot find MySQL. It says: "Error establishing a database connection." I'm not surprised, I know nothing about MySql and there's apparently nothing in the docs. I am a non-nerd uploading it to my ISP... how and what am I supposed to know about MySQL?
    Rgds
    Martin

  11. You'll have to ask your ISP about how to access MySQL on their servers.

  12. mcleaver
    Member
    Posted 9 years ago #

    My ISP Says:

    >>>>>
    accessing mySQL database from PHP
    To contact a MySQL server, you need the following four items:

    The host name;
    The database name;
    The user name;
    The password.

    The function to make contact is mysql-connect:
    <<<<<

    That's it (ISP is Vevida.nl)

    Does that help?

    Rgds

    Martin

  13. moshu
    Member
    Posted 9 years ago #

    Those are exactly the four items you need to put into your config file. If your host offers a database in your account there should be somewhere information about those 4 things :)
    If you have them correctly in the wp-config.php file, you don't really need to know anything about MySQL...

  14. mcleaver
    Member
    Posted 9 years ago #

    But is the database name e.g. the same as my account/domain?

  15. mcleaver
    Member
    Posted 9 years ago #

    (That was a quesiton for other users of Vevida...)

  16. mcleaver, you'll have better luck asking server-specific questions to your hosting provider's support dept.

  17. mcleaver
    Member
    Posted 9 years ago #

    I was hoping that some other Vevida user was also a WordPress user '-)

  18. mcleaver
    Member
    Posted 9 years ago #

    The blurd reads: "WordPress is a state-of-the-art semantic personal publishing platform with a focus on aesthetics, web standards, and usability." It doesn't say you have to be PHP and MySQL savvy :(

  19. mcleaver
    Member
    Posted 9 years ago #

    And another happy user also comments on their site: "I just converted my webpage to WordPress. The installation was supposed to take 5 minutes but it took me about 5 days. After a lot of arguing with my web host and trying the same thing over and over again…. it worked! I think.."

  20. mcleaver
    Member
    Posted 9 years ago #

    The lesson? Think of those who does not share the knowledge you have aqurired and are therefore outside the world of WordPress...

  21. You don't have to be MySQL savvy, and you don't have to be PHP savvy at all. The actual moral of the story is that you should know how to setup a MySQL database, and your hosting provider should provide you with the information on how to do that. The truth of the mater is, most hosting providers provide a simple one-click form for creating a MySQL database. Once you create the database through their one-click form, you then plug that information into wp-config.php. As you can see, there is no MySQL knowledge required. What is required is the knowledge that you have the ability to create MySQL databases, and that you know how to create them thanks to your hosting provider's FAQ or Knowledge Base. For the record, I installed WordPress in 3 minutes with no PHP or MySQL knowledge.

    Also for the record, The detailed WordPress installation instructions are very detailed. Beyond that, it's up to your hosting provider to provide you with information on uploading your files, creating MySQL databases, etc.

    In fact, the detailed installation instructions even provide you with step-by-step guides for creating MySQL databases via the three most popular programs/methods.

  22. mcleaver
    Member
    Posted 9 years ago #

    Aha... the one click will cost me 12 euro a month ;-)

  23. mcleaver
    Member
    Posted 9 years ago #

    Okay, I have got one step further. I actually managed to start the installation. Bad I was wondering about whether any folders needed extra rights, such as writing. Looks like it, as I got some kind of brief error message. So I changed the writes on that specific directory and tried again. But of course you can't try again, now I read I have to empty the database, wherever that may be.

  24. mcleaver
    Member
    Posted 9 years ago #

    I am assuming that somewhere something has to be written to the database, so that some directory somewhere must have its rights changed. ??
    Having gone as far as "Already Installed You appear to have already installed WordPress. To reinstall please clear your old database tables first." What next?

  25. mcleaver
    Member
    Posted 9 years ago #

    In other words, how do I clear my old database tables?

  26. mcleaver
    Member
    Posted 9 years ago #

    Seems to be okay, despite the rights issue... do any of my folders need to be writable?
    And does anyone know of an extension to make it possible for people to incorporate a photo in their upload?

Topic Closed

This topic has been closed to new replies.

About this Topic