{"id":5794,"date":"2026-08-16T10:46:08","date_gmt":"2026-08-16T08:46:08","guid":{"rendered":"https:\/\/www.blue-bears.com\/blog\/?p=5794"},"modified":"2026-08-16T12:35:08","modified_gmt":"2026-08-16T10:35:08","slug":"creation-base-mysql-et-connexion-php","status":"publish","type":"post","link":"http:\/\/www.blue-bears.com\/blog\/?p=5794","title":{"rendered":"Cr\u00e9ation base MYSQL et connexion PHP"},"content":{"rendered":"<ul>\n<li>Connexion \u00e0 la console administratrice PHPMyadmin du serveur : Ip ou \u00ab\u00a0serveur\u00a0\u00bb port 10000<\/li>\n<li>Login Root<\/li>\n<li>Users LINUX :\n<ul>\n<li>Cr\u00e9ation user Linux avec le m\u00eame nom \/ mdp que celui de MYSQL<\/li>\n<\/ul>\n<\/li>\n<li>Serveurs =&gt; MariaDb (depuis que MYSQL \u00e0 \u00e9t\u00e9 rachet\u00e9 par ORACLE)\n<ul>\n<li>Creation dtabase insee_db<\/li>\n<li>Cr\u00e9ation d&rsquo;une table<\/li>\n<li>\n<pre><em><span style=\"color: #003366;\">CREATE TABLE IF NOT EXISTS historique_effectifs_siren (<\/span><\/em>\r\n<em><span style=\"color: #003366;\">id INT AUTO_INCREMENT PRIMARY KEY,<\/span><\/em>\r\n<em><span style=\"color: #003366;\">siren VARCHAR(9) NOT NULL,<\/span><\/em>\r\n<em><span style=\"color: #003366;\">date_debut DATE NULL,<\/span><\/em>\r\n<em><span style=\"color: #003366;\">date_fin DATE NULL,<\/span><\/em>\r\n<em><span style=\"color: #003366;\">code_tranche VARCHAR(5),<\/span><\/em>\r\n<em><span style=\"color: #003366;\">libelle_tranche VARCHAR(100),<\/span><\/em>\r\n<em><span style=\"color: #003366;\">annee_effectif VARCHAR(4),<\/span><\/em>\r\n<em><span style=\"color: #003366;\">created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,<\/span><\/em>\r\n<em><span style=\"color: #003366;\">UNIQUE KEY unique_siren_periode (siren, date_debut)<\/span><\/em>\r\n<em><span style=\"color: #003366;\">) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;<\/span><\/em><\/pre>\n<\/li>\n<li><\/li>\n<\/ul>\n<\/li>\n<li>User managers :\n<ul>\n<li>Cr\u00e9ation user MYSQL\u00a0 : insee_user \/ mdp VdF1star<\/li>\n<li>database permission =&gt; insee_db, user insee_user,<\/li>\n<li>Privil\u00e9ges : <span style=\"color: #800080;\">Select, insert, update and delete table data; create, drop, alter and create temp tables; create and show view; create and alter routine<\/span><\/li>\n<\/ul>\n<\/li>\n<li>File Manager :\n<ul>\n<li>Path : var\/www\/bluebears\/insee_db\/ owner : www-data\/www-data; permission: 2755 (defaut)<\/li>\n<li>Test avec info.php : https:\/\/www.blue-bears.com\/insee_db\/info.php =&gt; OK<\/li>\n<li>Test connexion MYSQL\n<ul>\n<li style=\"text-align: left;\"><a href=\"https:\/\/www.blue-bears.com\/insee_db\/MYSQL_Connect.php\">https:\/\/www.blue-bears.com\/insee_db\/MYSQL_Connect.php<\/a><\/li>\n<li style=\"text-align: left;\">OK apr\u00e8s blocage : la cr\u00e9ation d&rsquo;un user sur un base vide de table semble impossible =&gt; cr\u00e9er d&rsquo;abord une table et ensuite le user.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li>Script PHP :\n<ul>\n<li><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Connexion \u00e0 la console administratrice PHPMyadmin du serveur : Ip ou \u00ab\u00a0serveur\u00a0\u00bb port 10000 Login Root Users LINUX : Cr\u00e9ation user Linux [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5794","post","type-post","status-publish","format-standard","hentry","category-non-classe"],"_links":{"self":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/5794","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5794"}],"version-history":[{"count":7,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/5794\/revisions"}],"predecessor-version":[{"id":5796,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/5794\/revisions\/5796"}],"wp:attachment":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5794"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}