{"id":4,"date":"2011-11-10T15:32:59","date_gmt":"2011-11-10T22:32:59","guid":{"rendered":"http:\/\/www.wei-tek.com\/myblog\/?p=4"},"modified":"2011-12-29T06:57:14","modified_gmt":"2011-12-29T13:57:14","slug":"mysql-new-install","status":"publish","type":"post","link":"https:\/\/blog.wei-tek.com\/?p=4","title":{"rendered":"MySQL new install"},"content":{"rendered":"<p>Installed MySQL in a OES2 server this week, install went fine. YaST install was fast and seamless. Used the Linux client to setup the users and the databases, creating the databases and users was straight forward once the syntax was correct, thanks to google made finding the syntax fairly painless.<br \/>\nOnce created this is where problem started, getting the users access to the databases for a workstation. Mostly this issue<!--more--> was created by the permissions and syntax. Finally installed phpMyAdmin on the system, This took a little work on the OES2 server, download the phpMyAdmin, started install the dependencies where quick to resolve, with YaST, except pwgen. Finally found the rpm for pwgen for SLES10 x86_64 and installed it.<br \/>\nFinished phpMyAdmin install and logged in, deleted the users and the databases I had created, recreated them and added the proper permissions, then things started working the way the should.<\/p>\n<p>Useful sites:<br \/>\n<a title=\"MySQL Tutorial\" href=\"http:\/\/www.mysqltutorial.org\/\" target=\"_blank\">MySQL Tutorial<\/a><br \/>\n<a title=\"W3 School MySQL Tutorial\" href=\"http:\/\/www.w3schools.com\/sql\/default.asp\" target=\"_blank\">W3 School MySQL Tutorial<\/a><br \/>\n<a title=\"Database Journel MySQL Permissions\" href=\"http:\/\/www.databasejournal.com\/features\/mysql\/article.php\/3311731\/An-introduction-to-MySQL-permissions.htm\" target=\"_blank\">Database Journel MySQL Permissions<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Installed MySQL in a OES2 server this week, install went fine. YaST install was fast and seamless. Used the Linux client to setup the users and the databases, creating the databases and users was straight forward once the syntax was correct, thanks to google made finding the syntax fairly painless. Once created this is where [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[48,13,3],"tags":[5,57,4],"class_list":["post-4","post","type-post","status-publish","format-standard","hentry","category-novell-history","category-oes-nows","category-sql-databases","tag-install","tag-mysql","tag-phpmyadmin"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Synology MySQL new install<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.wei-tek.com\/?p=4\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Synology MySQL new install\" \/>\n<meta property=\"og:description\" content=\"Installed MySQL in a OES2 server this week, install went fine. YaST install was fast and seamless. Used the Linux client to setup the users and the databases, creating the databases and users was straight forward once the syntax was correct, thanks to google made finding the syntax fairly painless. Once created this is where [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.wei-tek.com\/?p=4\" \/>\n<meta property=\"og:site_name\" content=\"WEI-Tek Consulting Blog\" \/>\n<meta property=\"article:published_time\" content=\"2011-11-10T22:32:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2011-12-29T13:57:14+00:00\" \/>\n<meta name=\"author\" content=\"rainewalker\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"rainewalker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=4#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=4\"},\"author\":{\"name\":\"rainewalker\",\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/#\\\/schema\\\/person\\\/57843d667045c1d2e92f6709b31826cc\"},\"headline\":\"MySQL new install\",\"datePublished\":\"2011-11-10T22:32:59+00:00\",\"dateModified\":\"2011-12-29T13:57:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=4\"},\"wordCount\":164,\"commentCount\":7,\"keywords\":[\"install\",\"MySQL\",\"phpMyAdmin\"],\"articleSection\":[\"Novell\",\"OES - NOWS\",\"SQL Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/blog.wei-tek.com\\\/?p=4#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=4\",\"url\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=4\",\"name\":\"Synology MySQL new install\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/#website\"},\"datePublished\":\"2011-11-10T22:32:59+00:00\",\"dateModified\":\"2011-12-29T13:57:14+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/#\\\/schema\\\/person\\\/57843d667045c1d2e92f6709b31826cc\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=4#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blog.wei-tek.com\\\/?p=4\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=4#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/blog.wei-tek.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL new install\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/#website\",\"url\":\"https:\\\/\\\/blog.wei-tek.com\\\/\",\"name\":\"WEI-Tek Consulting Blog\",\"description\":\"Tip, Tricks and Letting off steam\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blog.wei-tek.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/#\\\/schema\\\/person\\\/57843d667045c1d2e92f6709b31826cc\",\"name\":\"rainewalker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4d680e5f042d634a22d17592d61565cd82ae4b89c745ba619c1d8e796fb79b89?s=96&d=identicon&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4d680e5f042d634a22d17592d61565cd82ae4b89c745ba619c1d8e796fb79b89?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4d680e5f042d634a22d17592d61565cd82ae4b89c745ba619c1d8e796fb79b89?s=96&d=identicon&r=g\",\"caption\":\"rainewalker\"},\"sameAs\":[\"http:\\\/\\\/www.my-businessmail.com\"],\"url\":\"https:\\\/\\\/blog.wei-tek.com\\\/?author=2\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Synology MySQL new install","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.wei-tek.com\/?p=4","og_locale":"en_US","og_type":"article","og_title":"Synology MySQL new install","og_description":"Installed MySQL in a OES2 server this week, install went fine. YaST install was fast and seamless. Used the Linux client to setup the users and the databases, creating the databases and users was straight forward once the syntax was correct, thanks to google made finding the syntax fairly painless. Once created this is where [&hellip;]","og_url":"https:\/\/blog.wei-tek.com\/?p=4","og_site_name":"WEI-Tek Consulting Blog","article_published_time":"2011-11-10T22:32:59+00:00","article_modified_time":"2011-12-29T13:57:14+00:00","author":"rainewalker","twitter_misc":{"Written by":"rainewalker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.wei-tek.com\/?p=4#article","isPartOf":{"@id":"https:\/\/blog.wei-tek.com\/?p=4"},"author":{"name":"rainewalker","@id":"https:\/\/blog.wei-tek.com\/#\/schema\/person\/57843d667045c1d2e92f6709b31826cc"},"headline":"MySQL new install","datePublished":"2011-11-10T22:32:59+00:00","dateModified":"2011-12-29T13:57:14+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.wei-tek.com\/?p=4"},"wordCount":164,"commentCount":7,"keywords":["install","MySQL","phpMyAdmin"],"articleSection":["Novell","OES - NOWS","SQL Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.wei-tek.com\/?p=4#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.wei-tek.com\/?p=4","url":"https:\/\/blog.wei-tek.com\/?p=4","name":"Synology MySQL new install","isPartOf":{"@id":"https:\/\/blog.wei-tek.com\/#website"},"datePublished":"2011-11-10T22:32:59+00:00","dateModified":"2011-12-29T13:57:14+00:00","author":{"@id":"https:\/\/blog.wei-tek.com\/#\/schema\/person\/57843d667045c1d2e92f6709b31826cc"},"breadcrumb":{"@id":"https:\/\/blog.wei-tek.com\/?p=4#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.wei-tek.com\/?p=4"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.wei-tek.com\/?p=4#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog.wei-tek.com\/"},{"@type":"ListItem","position":2,"name":"MySQL new install"}]},{"@type":"WebSite","@id":"https:\/\/blog.wei-tek.com\/#website","url":"https:\/\/blog.wei-tek.com\/","name":"WEI-Tek Consulting Blog","description":"Tip, Tricks and Letting off steam","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.wei-tek.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blog.wei-tek.com\/#\/schema\/person\/57843d667045c1d2e92f6709b31826cc","name":"rainewalker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4d680e5f042d634a22d17592d61565cd82ae4b89c745ba619c1d8e796fb79b89?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4d680e5f042d634a22d17592d61565cd82ae4b89c745ba619c1d8e796fb79b89?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4d680e5f042d634a22d17592d61565cd82ae4b89c745ba619c1d8e796fb79b89?s=96&d=identicon&r=g","caption":"rainewalker"},"sameAs":["http:\/\/www.my-businessmail.com"],"url":"https:\/\/blog.wei-tek.com\/?author=2"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2SXof-4","_links":{"self":[{"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=\/wp\/v2\/posts\/4","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4"}],"version-history":[{"count":0,"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=\/wp\/v2\/posts\/4\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}