{"id":3868,"date":"2026-07-22T21:31:53","date_gmt":"2026-07-22T21:31:53","guid":{"rendered":"https:\/\/disoh.com\/support\/how-do-i-add-an-extra-user-to-a-mysql-database-in-directadmin\/"},"modified":"2026-07-22T21:31:53","modified_gmt":"2026-07-22T21:31:53","password":"","slug":"comment-ajouter-un-utilisateur-supplementaire-a-une-base-de-donnees-mysql-dans-directadmin","status":"publish","type":"docs","link":"https:\/\/disoh.com\/fr\/support\/how-do-i-add-an-extra-user-to-a-mysql-database-in-directadmin\/","title":{"rendered":"Comment ajouter un utilisateur suppl\u00e9mentaire \u00e0 une base de donn\u00e9es MySQL dans DirectAdmin ?"},"content":{"rendered":"<p>Il arrive parfois que vous ayez besoin de plusieurs comptes utilisateurs pour une base de donn\u00e9es, par exemple pour accorder un acc\u00e8s limit\u00e9 \u00e0 une application ou pour permettre \u00e0 un d\u00e9veloppeur de se connecter sans utiliser vos identifiants principaux. DirectAdmin vous permet de cr\u00e9er des utilisateurs MySQL suppl\u00e9mentaires et de les associer \u00e0 une base de donn\u00e9es. Ce guide vous explique comment proc\u00e9der.<\/p>\n<h2>Pourquoi cr\u00e9er un nouvel utilisateur de base de donn\u00e9es ?<\/h2>\n<ul>\n<li>Attribuez \u00e0 chaque application ses propres identifiants d\u00e9di\u00e9s.<\/li>\n<li>Accordez l'acc\u00e8s \u00e0 un d\u00e9veloppeur sans partager votre compte utilisateur principal.<\/li>\n<li>Limitez les autorisations afin que chaque utilisateur ne dispose que de celles dont il a besoin.<\/li>\n<\/ul>\n<h2>Cr\u00e9ation et attribution d'un utilisateur<\/h2>\n<ol>\n<li>Connectez-vous \u00e0 DirectAdmin.<\/li>\n<li>Aller \u00e0 <strong>Responsable de compte &gt; Gestion de MySQL<\/strong>.<\/li>\n<li>Ouvrez la base de donn\u00e9es \u00e0 laquelle vous souhaitez accorder un acc\u00e8s.<\/li>\n<li>Cr\u00e9ez un nouvel utilisateur avec un mot de passe fort, ou s\u00e9lectionnez-en un existant.<\/li>\n<li>Affectez l'utilisateur \u00e0 la base de donn\u00e9es et d\u00e9finissez les droits dont il doit disposer.<\/li>\n<li>Enregistrer.<\/li>\n<\/ol>\n<h2>Choix des privil\u00e8ges<\/h2>\n<p>N'accordez que les droits n\u00e9cessaires. Un utilisateur standard d'une application a besoin de droits d'acc\u00e8s aux donn\u00e9es tels que SELECT, INSERT, UPDATE et DELETE, tandis que les droits d'administration doivent \u00eatre limit\u00e9s. Limiter les autorisations au strict minimum constitue une bonne pratique en mati\u00e8re de s\u00e9curit\u00e9.<\/p>\n<h2>Utilisation des nouveaux identifiants<\/h2>\n<p>Notez le nom de la base de donn\u00e9es, le nouveau nom d'utilisateur, le mot de passe et l'h\u00f4te (g\u00e9n\u00e9ralement \u00ab localhost \u00bb). Saisissez ces informations dans la configuration de votre application afin qu'elle se connecte avec le nouvel utilisateur.<\/p>\n<h2>D\u00e9pannage<\/h2>\n<ul>\n<li><strong>Acc\u00e8s refus\u00e9 :<\/strong> V\u00e9rifiez que l'utilisateur est bien affect\u00e9 \u00e0 la base de donn\u00e9es et qu'il dispose des droits appropri\u00e9s.<\/li>\n<li><strong>L'application ne parvient pas \u00e0 se connecter :<\/strong> V\u00e9rifiez \u00e0 nouveau le nom, l'identifiant, le mot de passe et l'h\u00f4te.<\/li>\n<\/ul>\n<h2>Besoin d'aide ?<\/h2>\n<p>Si un utilisateur de la base de donn\u00e9es ne parvient pas \u00e0 se connecter, notre \u00e9quipe d'assistance peut l'aider via le chat en direct.<\/p>","protected":false},"excerpt":{"rendered":"<p>Sometimes you need more than one user account for a database, for example to give an application limited access or to let a developer connect without your main credentials. DirectAdmin lets you create additional MySQL users and assign them to a database. This guide explains how. Why add another database user Give an application its [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[12],"doc_tag":[],"class_list":["post-3868","docs","type-docs","status-publish","hentry","doc_category-webhosting"],"year_month":"2026-07","word_count":236,"total_views":"27","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Jorn","author_nicename":"jorn","author_url":"https:\/\/disoh.com\/fr\/author\/jorn\/"},"doc_category_info":[{"term_name":"Webhosting","term_url":"https:\/\/disoh.com\/fr\/docs-category\/webhosting\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How do I add an extra user to a MySQL database in DirectAdmin? &#8211; Disoh<\/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:\/\/disoh.com\/fr\/soutien\/comment-ajouter-un-utilisateur-supplementaire-a-une-base-de-donnees-mysql-dans-directadmin\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How do I add an extra user to a MySQL database in DirectAdmin? &#8211; Disoh\" \/>\n<meta property=\"og:description\" content=\"Sometimes you need more than one user account for a database, for example to give an application limited access or to let a developer connect without your main credentials. DirectAdmin lets you create additional MySQL users and assign them to a database. This guide explains how. Why add another database user Give an application its [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/disoh.com\/fr\/soutien\/comment-ajouter-un-utilisateur-supplementaire-a-une-base-de-donnees-mysql-dans-directadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Disoh\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/disohhosting\" \/>\n<meta property=\"og:image\" content=\"https:\/\/disoh.com\/wp-content\/uploads\/2025\/07\/disoh_about.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1536\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/disoh.com\\\/support\\\/how-do-i-add-an-extra-user-to-a-mysql-database-in-directadmin\\\/\",\"url\":\"https:\\\/\\\/disoh.com\\\/support\\\/how-do-i-add-an-extra-user-to-a-mysql-database-in-directadmin\\\/\",\"name\":\"How do I add an extra user to a MySQL database in DirectAdmin? &#8211; Disoh\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/disoh.com\\\/#website\"},\"datePublished\":\"2026-07-22T21:31:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/disoh.com\\\/support\\\/how-do-i-add-an-extra-user-to-a-mysql-database-in-directadmin\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/disoh.com\\\/support\\\/how-do-i-add-an-extra-user-to-a-mysql-database-in-directadmin\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/disoh.com\\\/support\\\/how-do-i-add-an-extra-user-to-a-mysql-database-in-directadmin\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/disoh.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How do I add an extra user to a MySQL database in DirectAdmin?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/disoh.com\\\/#website\",\"url\":\"https:\\\/\\\/disoh.com\\\/\",\"name\":\"Disoh\",\"description\":\"Digital Solutions Hosting\",\"publisher\":{\"@id\":\"https:\\\/\\\/disoh.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/disoh.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/disoh.com\\\/#organization\",\"name\":\"Disoh LLC\",\"url\":\"https:\\\/\\\/disoh.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/disoh.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/disoh.com\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/favicon_1.svg\",\"contentUrl\":\"https:\\\/\\\/disoh.com\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/favicon_1.svg\",\"width\":615,\"height\":615,\"caption\":\"Disoh LLC\"},\"image\":{\"@id\":\"https:\\\/\\\/disoh.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/disohhosting\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Comment ajouter un utilisateur suppl\u00e9mentaire \u00e0 une base de donn\u00e9es MySQL dans DirectAdmin ? \u2013 Disoh","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:\/\/disoh.com\/fr\/soutien\/comment-ajouter-un-utilisateur-supplementaire-a-une-base-de-donnees-mysql-dans-directadmin\/","og_locale":"fr_FR","og_type":"article","og_title":"How do I add an extra user to a MySQL database in DirectAdmin? &#8211; Disoh","og_description":"Sometimes you need more than one user account for a database, for example to give an application limited access or to let a developer connect without your main credentials. DirectAdmin lets you create additional MySQL users and assign them to a database. This guide explains how. Why add another database user Give an application its [&hellip;]","og_url":"https:\/\/disoh.com\/fr\/soutien\/comment-ajouter-un-utilisateur-supplementaire-a-une-base-de-donnees-mysql-dans-directadmin\/","og_site_name":"Disoh","article_publisher":"https:\/\/www.facebook.com\/disohhosting","og_image":[{"width":1536,"height":1024,"url":"https:\/\/disoh.com\/wp-content\/uploads\/2025\/07\/disoh_about.webp","type":"image\/webp"}],"twitter_card":"summary_large_image","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/disoh.com\/support\/how-do-i-add-an-extra-user-to-a-mysql-database-in-directadmin\/","url":"https:\/\/disoh.com\/support\/how-do-i-add-an-extra-user-to-a-mysql-database-in-directadmin\/","name":"Comment ajouter un utilisateur suppl\u00e9mentaire \u00e0 une base de donn\u00e9es MySQL dans DirectAdmin ? \u2013 Disoh","isPartOf":{"@id":"https:\/\/disoh.com\/#website"},"datePublished":"2026-07-22T21:31:53+00:00","breadcrumb":{"@id":"https:\/\/disoh.com\/support\/how-do-i-add-an-extra-user-to-a-mysql-database-in-directadmin\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/disoh.com\/support\/how-do-i-add-an-extra-user-to-a-mysql-database-in-directadmin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/disoh.com\/support\/how-do-i-add-an-extra-user-to-a-mysql-database-in-directadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/disoh.com\/"},{"@type":"ListItem","position":2,"name":"How do I add an extra user to a MySQL database in DirectAdmin?"}]},{"@type":"WebSite","@id":"https:\/\/disoh.com\/#website","url":"https:\/\/disoh.com\/","name":"Disoh","description":"Solutions num\u00e9riques H\u00e9bergement","publisher":{"@id":"https:\/\/disoh.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/disoh.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/disoh.com\/#organization","name":"Disoh LLC","url":"https:\/\/disoh.com\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/disoh.com\/#\/schema\/logo\/image\/","url":"https:\/\/disoh.com\/wp-content\/uploads\/2025\/06\/favicon_1.svg","contentUrl":"https:\/\/disoh.com\/wp-content\/uploads\/2025\/06\/favicon_1.svg","width":615,"height":615,"caption":"Disoh LLC"},"image":{"@id":"https:\/\/disoh.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/disohhosting"]}]}},"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/disoh.com\/fr\/wp-json\/wp\/v2\/docs\/3868","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/disoh.com\/fr\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/disoh.com\/fr\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/disoh.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/disoh.com\/fr\/wp-json\/wp\/v2\/comments?post=3868"}],"version-history":[{"count":0,"href":"https:\/\/disoh.com\/fr\/wp-json\/wp\/v2\/docs\/3868\/revisions"}],"wp:attachment":[{"href":"https:\/\/disoh.com\/fr\/wp-json\/wp\/v2\/media?parent=3868"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/disoh.com\/fr\/wp-json\/wp\/v2\/doc_category?post=3868"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/disoh.com\/fr\/wp-json\/wp\/v2\/doc_tag?post=3868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}