mysqlmysql-error-1130

Error 1130 in mysql


when i am trying to log on mysql using my ip address i am getting error 1130 qht can i do for this


Solution

  • Your client IP is not allowed to connect to this server, you must add it to allowed client account For exemple, assuming you add an user account having all rights in one database :

    grant all on db.* to 'username'@'192.168.0.1';
    

    Where db is database name, username the username , and your clients IP is 192.168.0.1

    See docs for details of user account creation