by MaryK
21 replies
I have spent two days, around 15 hrs. each day trying to get Mysql to work. When I try to configure I get the following error message -

Connection failedHY000)(Mysql)(ODBC 5.1 Driver) host 192.168.0.2 is not allowed to connect to the Mysql server.


Have tried using local host as the user name, have closed off Windows Firewall - still have Zone Alarm working but have checked allow on that.

Ifound a help page but it's so technical, root directories and such, that it may as well be written in double dutch.

Have tried everything I know, which I admit isn't much on the tech side and am now going bonkers!

Could someone out there please help! Using very simple English, I am definitely 'technically challenged". This is holding up my entire launch
#mysql
  • Profile picture of the author Neil Morgan
    Hello Mary

    MySQL has a table of hosts (IP addresses) that are allowed to access the database. It's a security measure. So you need to edit that table and either add your IP address or allow all IP addresses to access the MySQL server.

    If PHPMyAdmin i installed (if this is WAMP then it is) you can access this table using it. You will need to do this from a PC that is allowed access to the MySQL server.

    Without seeing your system, I can't be more specific but this will hopefully give you a way forward.

    Cheers,

    Neil
    Signature

    Easy email marketing automation without moving your lists.

    {{ DiscussionBoard.errors[324598].message }}
  • Profile picture of the author MaryK
    Thank you Neil, am about to try what you have said. Will keep you posted on my sucess, all fingers crossed
    Signature
    Mary K Gill Latest book: The Twelve Natural Laws of the Universe - achieve all your desires for less than the price of coffee and cake. P.S. It only fattens your mind, not your thighs.
    Mindset Power Site
    {{ DiscussionBoard.errors[324611].message }}
  • Profile picture of the author MaryK
    Have found the PHPMyAdmin folder - but I cannot fathom any of the scripts(: Neil, how do I change the scripts and which script do I use. Sorry, I really am so confused. Oh yes, it is a WAMP I did manage to get that far as well. The system used on this computer is Windows XP - does that help? I also installed Apache when I did the MySql installation. Oh brother I feel sick in the stomach over all this.
    Signature
    Mary K Gill Latest book: The Twelve Natural Laws of the Universe - achieve all your desires for less than the price of coffee and cake. P.S. It only fattens your mind, not your thighs.
    Mindset Power Site
    {{ DiscussionBoard.errors[324693].message }}
  • Profile picture of the author Quang Van
    Hey MaryK,

    You could try emailing tech support at your webhost... a lot of them are very helpful...

    Yeah like Neil said, you need to allow the proper IP addresses, and link up your mysql usernames with the databases it wants to access...

    Hope you work it out.
    {{ DiscussionBoard.errors[325687].message }}
  • Profile picture of the author smddev
    Mary, phpmyadmin has a file called "Config.inc.php" which you will need to configure before you can start using the application.

    For a default mysql install, the settings will typically be:
    Server: localhost
    User: root
    password: <Blank> as in no password.

    Once configured, point your browser to the phpmyadmin folder and see if it works.

    If not, do let me know the error and I shall be able to help you with this ...
    {{ DiscussionBoard.errors[327097].message }}
  • Profile picture of the author MaryK
    /* Authentication type and info */
    $cfg['Servers'][$i]['auth_type'] = 'localhost';
    $cfg['Servers'][$i]['user'] = 'milliona_wrdp1';
    $cfg['Servers'][$i]['password'] = 'jacques2009';
    $cfg['Servers'][$i]['extension'] = 'mysql';

    This is what I have configured, not sure if I have it right yet - still getting error message. Connection failed:[HY000]{MySql]{ODBC5.1 driver] access denied for user milliona@localho"@local host' (using password:YES) the milliona@localho - is not a typo on my part, it actually came up like that in the error message.
    Signature
    Mary K Gill Latest book: The Twelve Natural Laws of the Universe - achieve all your desires for less than the price of coffee and cake. P.S. It only fattens your mind, not your thighs.
    Mindset Power Site
    {{ DiscussionBoard.errors[327176].message }}
  • Profile picture of the author smddev
    There should also be a settings "Host", which should be set to 'localhost' e.g.: $cfg['Servers'][$i]['host'] = 'localhost';

    auth_type sets the authentication type for phpmyadmin and it can have these values: Cookies, Http and config. If you set it to http, it will ask the username password via browser authentication.
    {{ DiscussionBoard.errors[327217].message }}
  • Profile picture of the author MaryK
    oh brother, what I copy/pasted above came from the config.inc file - no "host" at all.

    This is the code from the sample config.inc file - should I have used this file?

    * First server
    */
    $i++;
    /* Authentication type */
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    /* Server parameters */
    $cfg['Servers'][$i]['host'] = 'localhost';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['compress'] = false;
    /* Select mysqli if your server has it */
    $cfg['Servers'][$i]['extension'] = 'mysql';
    /* User for advanced features */
    Signature
    Mary K Gill Latest book: The Twelve Natural Laws of the Universe - achieve all your desires for less than the price of coffee and cake. P.S. It only fattens your mind, not your thighs.
    Mindset Power Site
    {{ DiscussionBoard.errors[327245].message }}
  • Profile picture of the author smddev
    You got it now

    Yes, you need to copy this sample file and then configure it accordingly.
    {{ DiscussionBoard.errors[327271].message }}
  • Profile picture of the author MaryK
    Still no luck, here is what I have now:-

    /* Authentication type and info */
    $cfg['Servers'][$i]['auth_type'] = 'config';
    $cfg['Servers'][$i]['host'] = 'localhost';
    $cfg['Servers'][$i]['user'] = 'millona_wrdp1';
    $cfg['Servers'][$i]['password'] = 'jacques2009';
    $cfg['Servers'][$i]['extension'] = 'mysql';
    Signature
    Mary K Gill Latest book: The Twelve Natural Laws of the Universe - achieve all your desires for less than the price of coffee and cake. P.S. It only fattens your mind, not your thighs.
    Mindset Power Site
    {{ DiscussionBoard.errors[327307].message }}
  • Profile picture of the author smddev
    Ok, by any chance can I access that machine?
    {{ DiscussionBoard.errors[327386].message }}
  • Profile picture of the author smddev
    Also, try using username "root" with no password ...
    {{ DiscussionBoard.errors[327391].message }}
  • Profile picture of the author MaryK
    No that doesn't work either - just asked partner, as it is his computer and he gave consent for you to access this computer.
    Signature
    Mary K Gill Latest book: The Twelve Natural Laws of the Universe - achieve all your desires for less than the price of coffee and cake. P.S. It only fattens your mind, not your thighs.
    Mindset Power Site
    {{ DiscussionBoard.errors[327410].message }}
  • Profile picture of the author smddev
    Ok, are you online on any of the IM systems like gtalk or skype? please send me a PM with details of the same ...
    {{ DiscussionBoard.errors[327420].message }}
  • Profile picture of the author MaryK
    No, skype was on my computer, which crashed and lost all data. Will install skype now - hold on
    Signature
    Mary K Gill Latest book: The Twelve Natural Laws of the Universe - achieve all your desires for less than the price of coffee and cake. P.S. It only fattens your mind, not your thighs.
    Mindset Power Site
    {{ DiscussionBoard.errors[327428].message }}
  • Profile picture of the author smddev
    Let me get back to you on this tomorrow. Will explore xamplite.
    {{ DiscussionBoard.errors[327678].message }}
  • Profile picture of the author n7 Studios
    Mary,

    Not sure if this will help you, but have you considered installing a package that does all the hard work for you i.e. installing Apache, PHP, MySQL etc. all in one?

    I personally use WAMP (sorry, can't post links yet!), but there are others available. Out of the box, these should install like a breeze, and you should be able to access your MySQL databases via phpMyAdmin, which is also installed with it. However, as a word of caution, there are some security issues with these "all in one" packages, so it's best to either set some passwords once you're comfortable with using it, or ensure you're just using it for local development.

    You'd ideally need to remove your existing Apache / MySQL etc. installations first, to start from a clean slate, so to speak.

    HTH.
    {{ DiscussionBoard.errors[328443].message }}
  • Profile picture of the author gcornelisse
    I think you need to check whether the user you have setup in MySQL is correct in the database. Make sure the user's "Host" is "localhost" or "%" if you're only accepting local connections.

    Depending upon how you added the user to the system, you may need flush the privileges. Just because you added the user doesn't always mean that user is immediately available. MySQL caches the user permission information and doesn't refresh it unless you've restarted MySQL or the whole computer since last add/editing the the user.

    I highly recommend downloading and using the MySQL GUI Tools Bundle. It has an administration tool that makes it a lot easier to manager users. You'll just need to get that root access to start changing user information. If you don't remember the password, you may want to uninstall and install again. There is a step in the installation process that asks you to create a root password.
    {{ DiscussionBoard.errors[329333].message }}
  • Profile picture of the author smddev
    Do let me know once you are all set with the ezine setup

    Hope that will help ...
    {{ DiscussionBoard.errors[333397].message }}
  • Profile picture of the author MaryK
    Hi everyone - a HUGE thank you to everyone You really are such wonderful and helpful people. Special thanks to Smddev, who despite having a cold, spent ages on Skype trying to help, also to Tommo who has been pm'ing with help also. The problem it appears cannot be resolved. I downloaded all the packets etc. but as Dheerja said, MySQL is not, without an awful lot of technical knowledge, re-configuring etc. compatible with Windows. So, have taken his advice and am going with an ezine hosting provider. I have learnt so much, not the least that when you are in strife Warriors share their knowledge and give help so freely. I also, believe it or not, have managed to learn quite a bit, LOL one thing is for sure, something tells me I am not cut out for programming. Again, thank you so much and I'll keep you posted on how the ezine hosting goes, plus changing everything on my new blog, which will appear in my signature (removing the old and ghastly one) as soon as the opt-in is finally finished and up and running.

    I'm off now to catch up on many hours of lost sleep. Thanks again to everyone
    Signature
    Mary K Gill Latest book: The Twelve Natural Laws of the Universe - achieve all your desires for less than the price of coffee and cake. P.S. It only fattens your mind, not your thighs.
    Mindset Power Site
    {{ DiscussionBoard.errors[333476].message }}
    • Profile picture of the author saybrah
      where is the database name that you are trying to connect to?

      i see user'] = 'millona_wrdp1' but i don't see a database name. it would look the same millona_?

      for some reason your username looks like the database.
      {{ DiscussionBoard.errors[334067].message }}

Trending Topics