Results 1 to 10 of 22

Threaded View

  1. #8
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,167
    Plugin Contributions
    7

    Default Re: Want to edit my zc db with sqldeveloper but cannot connect with localhost

    Quote Originally Posted by RodG View Post
    As stated above, you need to set the user permissions to log on from anywhere (or, in your case, for better security, the IP address of your *Windoze* box (192.168.0.104), because that is where are connecting *from*.
    Amend this. Set to log in from anywhere. It just occured to me that if you set to use *just* the aforementioned IP address you'll actually be denying access from 'localhost', and that will cause an issue with phpmyadmin connecting to the SQL server (since both are running on the same 'localhost') and by default, this is what both phpmyadmin are expecting to use.

    There are way around this, but I'm not 100% sure of the correct syntax to use in the host field (it's probably text input and "127.0.0.1; 192.168.0.104"), buty I could be wrong.

    Cheers
    Rod
    Last edited by RodG; 13 May 2012 at 08:09 AM.

 

 

Similar Threads

  1. v150 Cannot edit files About Us with Define Editor
    By irishshopper in forum General Questions
    Replies: 9
    Last Post: 8 Sep 2014, 04:43 PM
  2. I want to test product Downloads with the COD module..but I can't...
    By dgent in forum Built-in Shipping and Payment Modules
    Replies: 3
    Last Post: 30 Aug 2011, 03:20 PM
  3. I installed with the example products, but I now want an empty shop
    By Lieven79 in forum Installing on a Windows Server
    Replies: 1
    Last Post: 5 Aug 2010, 10:51 PM
  4. I want to offer some products with free shipping but only for customers in USA
    By rmlawdad1 in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 24 Jan 2010, 05:24 AM
  5. Sudden Unable to Connect to Localhost
    By johnd in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 3 Jun 2007, 02:24 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR