access denied

[CaribeJoe]

When I try to access the db via your manager I get the following error.

Quote:

[mycaribbean] ERROR 1130: Host 'dialup-171.75.86.192.Dial1.Weehawken.Level3.net' is not allowed to connect to this MySQL server

I am running an Invision Power Board (same as this forum) on a Rackshack dedicated server. In other words, I host my own site. I don't know much about MySQL.

I can fully access the db through the IPB Admin CP but I want to use your prog so I can learn more.

From reading other messages on this topic here and information elsewhere I gather I must go into the db administraion system and make some sort of modification. But I'm worrried about breaking my board. Can you provide step by step instructions, using the IPB Admin CP to add that permission?

TIA

[Shadow]

Quote:

If you get the following error when you try to connect from a different host than the one on which the MySQL server is running, then there is no row in the user table that matches that host:

Host … is not allowed to connect to this MySQL server

You can fix this by using the command-line tool mysql (on the server host!) to add a row to the user, db, or host table for the user/hostname combination from which you are trying to connect and then execute mysqladmin flush-privileges. If you are not running MySQL Version 3.22 and you don't know the IP number or hostname of the machine from which you are connecting, you should put an entry with '%' as the Host column value in the user table and restart mysqld with the –log option on the server machine. After trying to connect from the client machine, the information in the MySQL log will indicate how you really did connect. (Then replace the '%' in the user table entry with the actual hostname that shows up in the log. Otherwise, you'll have a system that is insecure.)

If you do not have a stable IP address (and you seem to have a dial-up access) then you should create a user with 'username'@'%', otherwise you won't be able to connect next time!

[Author]

Posts