I'm hoping someone can shed some light on a problem I'm having connecting to my MySQL database... I've entered the host, username, password etc and clicked connect and a popup says:
SQL Error: Host 'dsl-217-155-204-94.zen.co.uk' is not allowed to connect to this MySQL server' My ISP is Zen and my IP address is 217-155-204-94... but what has that got to do with connecting to a SQL server? I'm very new to MySQL databases and servers... so if someone could explain what could be going wrong I'd be very appreciative.
christian.
SQL Browser - connect error
Moderator: kfury77
Forum rules
Please try to follow these guidelines. This will help to receive faster and more accurate response.
Please try to follow these guidelines. This will help to receive faster and more accurate response.
- Check the Support section of the corresponding product first. Chances are you will find your answer there;
- Do not create new topics for already reported problems. Add your comments to the existing topics instead;
- Create separate topic for each problem request. Do NOT post a number of non-related problem reports in a single topic;
- Give your topic a meaningful title. Titles such as "A question," "Bug report" and "Help!" provide others no clue what your message is about;
- Include the version number of the software you are using;
- This is not an official customer support helpdesk. If you need a prompt and official response, please contact our support team directly instead. It may take a while until you receive a reply in the forum;
'dsl-217-155-204-94.zen.co.uk' is your puclic name while you're connected to the internet. The message states you're not allowed to connect to a mysql-server located in the internet.
Usually you're not allowed to connect to the mysql-server of your provider from any host other than your webspace.
To develop, you can setup a local copy of mysql at home, and then change the user/passwd setting before you upload the app to your webspace.
To manage the mysql and copy data and structures between your local copy and your webspace, you can use phpmyadmin.
HTH,
Frank
Usually you're not allowed to connect to the mysql-server of your provider from any host other than your webspace.
To develop, you can setup a local copy of mysql at home, and then change the user/passwd setting before you upload the app to your webspace.
To manage the mysql and copy data and structures between your local copy and your webspace, you can use phpmyadmin.
HTH,
Frank