Sneaky Sneaky

Member
  • Content Count

    9
  • Joined

  • Last visited

Community Reputation

1 Neutral

About Sneaky Sneaky

  • Rank
    Neutral

Profile Information

  • Gender
    Male
  1. Sneaky Sneaky

    open Mysql denies to connect to homepage

    yea fixed it :) it was a webhosting issue i told them to whitelist ip but they didnt and told me that they did xD
  2. Sneaky Sneaky

    open Mysql denies to connect to homepage

    still unsolved Cannot 'stop' ipfw. Set firewall_enable to YES in /etc/rc.conf or use 'onestop' instead of 'stop'. root@vps11031:~ # service ipfw onestop sysctl: unknown oid 'net.inet.ip.fw.enable' sysctl: unknown oid 'net.inet6.ip6.fw.enable' i did it with onestop but still ... Please close... my hosting company of web is a big retarded and didnt allow that ip as i had told them
  3. Sneaky Sneaky

    open Mysql denies to connect to homepage

    maybe they are blocking ip ? but i send them ticket and said to me that the ip is clear and i assumed this will be ok
  4. Sneaky Sneaky

    open Mysql denies to connect to homepage

    yes mate i have that one... i test it says connection failed problem is that mysql is not allowed remote access
  5. Sneaky Sneaky

    open Mysql denies to connect to homepage

    dafuq? well i tried it on a website that i had an online server running from there didnt work so misconfiguration wont be because i also tried in 2-3 websites more. Website Host not blocking i think 3306 because in same host i had my online server running Same as vps hosting wont be blocking 3306 cause i can manage to enter to navicat I gave through putty & navicat permissions to root but still shit as you told ipfw is blocking probably port. If i disable firewall will be problem huge... i havent tried through cause idk how to disable firewall in freebsd11 Also idk how to permit remote mysql on freebsd11 thats why i posted here probably someone know the fix for this shit --- i have in different host on website and server but when i asked my website hosting to whitelist this ip from theyr firewall they told me that is ok this ip now idk what the fk is problem
  6. Sneaky Sneaky

    open Mysql denies to connect to homepage

    up
  7. Sneaky Sneaky

    open Mysql denies to connect to homepage

    up
  8. Sneaky Sneaky

    open Mysql denies to connect to homepage

    well , in freebsd11.0 the my.cnf is at /usr/local/etc/mysql i have read all of that still havent managed to get access. my.cnf is like this: # $FreeBSD$ [client] port = 3306 socket = /tmp/mysql.sock [mysql] prompt = \u@\h [\d]>\_ no_auto_rehash [mysqld] skip-grant-tables user = mysql port = 3306 socket = /tmp/mysql.sock basedir = /usr/local datadir = /var/db/mysql tmpdir = /var/db/mysql_tmpdir slave-load-tmpdir = /var/db/mysql_tmpdir secure-file-priv = /var/db/mysql_secure log-bin = mysql-bin log-output = TABLE master-info-repository = TABLE relay-log-info-repository = TABLE relay-log-recovery = 1 slow-query-log = 1 server-id = 1 sync_binlog = 1 sync_relay_log = 1 binlog_cache_size = 16M expire_logs_days = 30 log-slave-updates = 1 enforce-gtid-consistency = 1 gtid-mode = ON safe-user-create = 1 lower_case_table_names = 1 explicit-defaults-for-timestamp = 1 myisam-recover-options = BACKUP,FORCE open_files_limit = 32768 table_open_cache = 16384 table_definition_cache = 8192 net_retry_count = 16384 key_buffer_size = 256M max_allowed_packet = 64M query_cache_type = 0 query_cache_size = 0 long_query_time = 0.5 innodb_buffer_pool_size = 1G innodb_data_home_dir = /var/db/mysql innodb_log_group_home_dir = /var/db/mysql innodb_data_file_path = ibdata1:128M:autoextend innodb_flush_method = O_DIRECT innodb_log_file_size = 256M innodb_log_buffer_size = 16M innodb_write_io_threads = 8 innodb_read_io_threads = 8 innodb_autoinc_lock_mode = 2 skip-symbolic-links [mysqldump] max_allowed_packet = 256M quote_names quick
  9. Hello,i have one issue i installed mysql correctly port 3306 is open same as mysql service but homepage doesnt connect to mysql i saw some topics in freebsd forum about allowing remote connections through my.cnf but still probably will be a firewall issue?? i am using freebsd11.0