Utilisateur : truc@localhost
Je n'ai pas compris à quoi fait référence ce "localhost".mysqli_real_connect(): (HY000/1045): Accès refusé pour l'utilisateur: 'root'@'@localhost' (mot de passe: OUI)
D'où sort ce "root@localhost" ?mysqli_real_connect(): (HY000/1045): Accès refusé pour l'utilisateur: 'root'@'@localhost' (mot de passe: OUI)
$cfg['Servers'][$i]['AllowNoPassword'] = true;Dois-je comprendre que le "pas de mot de passe" concerne le compte dans MySql et non le fait de ne pas le renseigner lors de la connexion ?
2019-06-07T19:14:26.456787Z 0 [ERROR] [MY-010131] [Server] TCP/IP, --shared-memory, or --named-pipe should be configured on NT OS 2019-06-07T19:14:26.485513Z 0 [ERROR] [MY-010119] [Server] Aborting
Citation
Otomatic
Même si cela date un peu revoir ma contribution sur Gestion des utilisateurs MySQL
Citation
Otomatic
L'hôte MySQL est obligatoirement 'localhost', c'est-à-dire le serveur d'hébergement :
Citation
Otomatic
Point 6 : Il n'y a rien à modifier dans my.ini ou config.inc.php, il suffit que l'utilisateur soit déclaré dans MySQL. Je me “connecte” à PhpMyAdmin avec des utilisateurs autres que root, mais ils sont déclarés dans mysql.
$cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'toor';ainsi que de cela dans "my.ini" :
[client] host = localhost user = root password = toormais on n'est pas obligé de le faire dans les fichiers 'config.inc.php" et "my.ini".
Citation
Otomatic
Point 12 : PhpMyAdmin ne peut pas gérer automatiquement un changement de compte, il faut bien rentrer le mot de passe du nouveau compte, même vide.
Citation
Otomatic
Point 17 : skip-grant-tables fonctionne avec my.ini et permet l'accès à la console.
43.239.122.120 - - [15/Jun/2019:02:57:12 +0200] "CONNECT www.jd.com:443 HTTP/1.0" 301 228 "-" "-" "-" "-" "-" 59 432
CONNECT www.jd.com:443je ne le comprends pas dans sa signification.
111.231.3.147 - - [09/Jun/2019:19:27:47 +0200] "GET / HTTP/1.1" 301 228 "-" "Mozilla/4.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)" "-" "-" 237 432 111.231.3.147 - - [09/Jun/2019:19:27:47 +0200] "GET /robots.txt HTTP/1.1" 301 238 "-" "Mozilla/4.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)" "-" "-" 247 452 111.231.3.147 - - [09/Jun/2019:19:27:49 +0200] "POST /App4646106d.php HTTP/1.1" 301 243 "-" "Mozilla/4.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)" "-" "-" 296 462 111.231.3.147 - - [09/Jun/2019:19:27:50 +0200] "GET /webdav/ HTTP/1.1" 301 235 "-" "Mozilla/5.0" "-" "-" 116 446 111.231.3.147 - - [09/Jun/2019:19:27:53 +0200] "GET /java.php HTTP/1.1" 301 236 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 253 485 111.231.3.147 - - [09/Jun/2019:19:27:53 +0200] "GET /_query.php HTTP/1.1" 301 238 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 231 489 111.231.3.147 - - [09/Jun/2019:19:27:54 +0200] "GET /test.php HTTP/1.1" 301 236 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 229 485 111.231.3.147 - - [09/Jun/2019:19:27:54 +0200] "GET /db_cts.php HTTP/1.1" 301 238 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 231 489 111.231.3.147 - - [09/Jun/2019:19:27:54 +0200] "GET /db_pma.php HTTP/1.1" 301 238 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 231 489 111.231.3.147 - - [09/Jun/2019:19:27:54 +0200] "GET /logon.php HTTP/1.1" 301 237 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 230 487 111.231.3.147 - - [09/Jun/2019:19:27:55 +0200] "GET /help-e.php HTTP/1.1" 301 238 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 231 489 111.231.3.147 - - [09/Jun/2019:19:27:55 +0200] "GET /license.php HTTP/1.1" 301 239 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 232 491 111.231.3.147 - - [09/Jun/2019:19:27:55 +0200] "GET /log.php HTTP/1.1" 301 235 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 228 483 111.231.3.147 - - [09/Jun/2019:19:27:55 +0200] "GET /hell.php HTTP/1.1" 301 236 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 229 485 111.231.3.147 - - [09/Jun/2019:19:27:56 +0200] "GET /pmd_online.php HTTP/1.1" 301 242 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 235 497 111.231.3.147 - - [09/Jun/2019:19:27:57 +0200] "GET /x.php HTTP/1.1" 301 233 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 226 479 111.231.3.147 - - [09/Jun/2019:19:27:57 +0200] "GET /shell.php HTTP/1.1" 301 237 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 230 487 111.231.3.147 - - [09/Jun/2019:19:27:57 +0200] "GET /htdocs.php HTTP/1.1" 301 238 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 231 489 111.231.3.147 - - [09/Jun/2019:19:27:58 +0200] "GET /b.php HTTP/1.1" 301 233 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 226 479 111.231.3.147 - - [09/Jun/2019:19:27:58 +0200] "GET /sane.php HTTP/1.1" 301 236 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 229 485 111.231.3.147 - - [09/Jun/2019:19:27:58 +0200] "GET /desktop.ini.php HTTP/1.1" 301 243 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 236 499 111.231.3.147 - - [09/Jun/2019:19:27:58 +0200] "GET /z.php HTTP/1.1" 301 233 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 226 479 111.231.3.147 - - [09/Jun/2019:19:27:59 +0200] "GET /lala.php HTTP/1.1" 301 236 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 229 485 111.231.3.147 - - [09/Jun/2019:19:27:59 +0200] "GET /lala-dpr.php HTTP/1.1" 301 240 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 233 493 111.231.3.147 - - [09/Jun/2019:19:27:59 +0200] "GET /wpc.php HTTP/1.1" 301 235 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 228 483 111.231.3.147 - - [09/Jun/2019:19:27:59 +0200] "GET /wpo.php HTTP/1.1" 301 235 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 228 483 111.231.3.147 - - [09/Jun/2019:19:28:01 +0200] "GET /t6nv.php HTTP/1.1" 301 236 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 229 485 111.231.3.147 - - [09/Jun/2019:19:28:01 +0200] "GET /muhstik.php HTTP/1.1" 301 239 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 232 491 111.231.3.147 - - [09/Jun/2019:19:28:01 +0200] "GET /text.php HTTP/1.1" 301 236 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 229 485 111.231.3.147 - - [09/Jun/2019:19:28:02 +0200] "GET /wp-config.php HTTP/1.1" 301 241 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0" "-" "-" 234 495