getting Error 1130

[grl]

Hi I'm getting an error “Error No. 1130 Host 'MYNAME' is not allowed to connect to this MySQL server”

Maybe it's because I'm behind firewall and that's why getting this error message. As an option to this is using

SSH tunnelling but I think it is not free.

By default in SQLyog it's 3306 and this is the same port Mysql is running under. Do I need to assign it differently?

And how do I know which port is free to assign it for SQLyog.

If there's anyone who can help me I kindly appriciate your help

grl

[CalEvans]

Sounds like your user@MYNAME does not have permission to access the server. If you are getting an error with a number, I'm guessing that you are actually connecting to MySQL.

Make sure user@MYNAME has permission to do what you want to do. If that doesn't work, add user@'%' but that's more dangerous.

HTH,

=C=

[peterlaursen]

Please write a little more about the server. Where is it running ? If it's at an ISP or webhotel, it's likely that you are not allowed to connect directly to MySQl. In that case you must use tunnelling to use sqlyog.

[grl]

Hi,

Thanks CalEvans and peterlaursen!

I'm not quite sure about 'user@MYNAME' I just provided the host name “MYNAME” that appears in the WinMySQLAdmin window under Local Host Name. If it is correct I mean the way CalEvans said then how do I give permission to do what I want it to do? And why is it dangerous when adding user@'%'?

peterlaursen I think the server recides in my PC. I'm using IIS server. I downloaded PHP, MySQL and now SQLyog and it's running in this PC. I hope I answered your question correctly about where the server is running.

grl

[peterlaursen]

If the Mysql server is running at your own PC, Hostname is “localhost”. Sqlyog connects directly to mysql and does not depend on or use PHP. It's not relevant for the matter which webserver you use – or if you use one at all! I meant only the MySQL server!

Besides I think you should forget about WinMySQLAdmin. It's outdated! (although it's still distributed with mysql)

Get “MySQL Administrator” from http://www.mysql http://www.mysql.com. Unless your mysql-version is very old.

Did you DL and install a “bundle” of Mysql-php-phpadmin ? I know you can find such bundles on the internet, but that's very old versions. And with mysql running locally I don't see why you need phpadmin at all. With frontends like sqlyog you connect directly and don't depend on a scripting engine.

There is no need to configure another port than the standard 3306. You practically only do that when you are running more than one MySQL servers behind one and the same router. You have a my.ini file somewhere (older versions in windows directory, newer versions in mysql drictory). Here you can read the port that is used. But I'm 99.999 % sure that t is 3306! You should take the time to understand some of the most important settings in the my.ini file

Attached picture show logonscreen with user “root”. Logged on as “root” you can create other users and assign priviliges for other users using either sqlyog or “MySQL Administrator”. Note: The usernames in MySQL are not the same in windows (Mysql does not use windows' user accounts – the user management in mysql in more unix/linux -like that windows-like!)

Hope that clarified a few points!

[Author]

Posts