Unsupported Screen Size: The viewport size is too small for the theme to render properly.

access denied

forums forums SQLyog Using SQLyog access denied

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • #14618
      Shadow
      Member
      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!

Viewing 0 reply threads
  • You must be logged in to reply to this topic.