{"id":2548,"date":"2025-12-12T16:31:40","date_gmt":"2025-12-12T15:31:40","guid":{"rendered":"https:\/\/yellotab.se\/x056\/?p=2548"},"modified":"2025-12-12T16:33:36","modified_gmt":"2025-12-12T15:33:36","slug":"extern-access-mysql","status":"publish","type":"post","link":"https:\/\/yellotab.se\/x056\/2025\/12\/12\/extern-access-mysql\/","title":{"rendered":"Extern access MySQL"},"content":{"rendered":"\n

\u2705 3. S\u00e5 h\u00e4r g\u00f6r du f\u00f6r att Sequel Pro ska fungera<\/strong><\/h1>\n\n\n\n

Steg A \u2014 Till\u00e5t fj\u00e4rranslutning<\/strong><\/h3>\n\n\n\n
    \n
  1. \u00d6ppna:<\/li>\n<\/ol>\n\n\n\n
    sudo nano \/etc\/mysql\/mariadb.conf.d\/50-server.cnf\n<\/code><\/pre>\n\n\n\n
      \n
    1. \u00c4ndra:<\/li>\n<\/ol>\n\n\n\n
      bind-address = 127.0.0.1\n<\/code><\/pre>\n\n\n\n
      till:<\/p>\n\n\n\n
      bind-address = 0.0.0.0\n<\/code><\/pre>\n\n\n\n
        \n
      1. Starta om:<\/li>\n<\/ol>\n\n\n\n
        sudo systemctl restart mysql\n<\/code><\/pre>\n\n\n\n
        \n\n\n\n
        Steg B \u2014 Ge anv\u00e4ndaren r\u00e4tt att logga in externt<\/strong><\/h3>\n\n\n\n
        Logga in p\u00e5 MySQL (som root):<\/p>\n\n\n\n
        sudo mysql\n<\/code><\/pre>\n\n\n\n
        K\u00f6r:<\/p>\n\n\n\n
        CREATE USER 'wordpress'@'%' IDENTIFIED BY 'dittl\u00f6senh\u00e4r';\nGRANT ALL PRIVILEGES ON wordpress.* TO 'wordpress'@'%';\nFLUSH PRIVILEGES;\n<\/code><\/pre>\n\n\n\n
        Eller om du vill \u00e5teranv\u00e4nda samma l\u00f6senord som i wp-config:<\/p>\n\n\n\n
        SELECT user, host FROM mysql.user WHERE user='wordpress';\n<\/code><\/pre>\n\n\n\n
        Se vad l\u00f6senordet \u00e4r i:<\/p>\n\n\n\n
        \/var\/www\/wordpress\/wp-config.php\n<\/code><\/pre>\n\n\n\n
        \n\n\n\n
        Steg C \u2014 Anslut fr\u00e5n Sequel Pro<\/strong><\/h3>\n\n\n\n
        I Sequel Pro ange:<\/p>\n\n\n\n
        F\u00e4lt<\/th>V\u00e4rde<\/th><\/tr><\/thead>
        Host<\/td>serverns IP-adress<\/strong>, t.ex. 192.168.1.50<\/code><\/td><\/tr>
        User<\/td>wordpress<\/code><\/td><\/tr>
        Password<\/td>(fr\u00e5n wp-config)<\/td><\/tr>
        Port<\/td>3306<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
        \n\n\n\n
        \ud83d\udd10 S\u00e4kerhetsnotis<\/h1>\n\n\n\n
        Om servern ligger \u00f6ppet mot internet:
        \u27a1\ufe0f \u00d6ppna INTE port 3306 publikt.
        D\u00e5 b\u00f6r du anv\u00e4nda SSH-tunnel<\/strong> ist\u00e4llet f\u00f6r att exponera MySQL.<\/p>\n","protected":false},"excerpt":{"rendered":"
        \u2705 3. S\u00e5 h\u00e4r g\u00f6r du f\u00f6r att Sequel Pro ska fungera Steg A \u2014 Till\u00e5t fj\u00e4rranslutning till: Steg B \u2014 Ge anv\u00e4ndaren r\u00e4tt att logga in externt Logga in p\u00e5 MySQL (som root): K\u00f6r: Eller om du vill \u00e5teranv\u00e4nda samma l\u00f6senord som i wp-config: Se vad l\u00f6senordet \u00e4r i: Steg C \u2014 Anslut fr\u00e5n Sequel […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[172],"tags":[171],"class_list":["post-2548","post","type-post","status-publish","format-standard","hentry","category-databaser","tag-mysql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/posts\/2548","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/comments?post=2548"}],"version-history":[{"count":2,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/posts\/2548\/revisions"}],"predecessor-version":[{"id":2550,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/posts\/2548\/revisions\/2550"}],"wp:attachment":[{"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/media?parent=2548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/categories?post=2548"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/tags?post=2548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}