Bjr, je me bats depuis ce matin avec mysql sous e-smith (sme 5.0) phpmyadmin etant absent de base , j'ai installé le rpm. No problem, acces par web (serveur dédié caché au fond d'un placard) wwwmonserver/phpmyadmin Une fenetre s'ouvre (sous IE win 98) root et pw root...rien admin et pw la: access denied
Avec ssh je prends la main sous root: mysql: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) L'install est toute neuve je n'ai pas crée de base. [EMAIL PROTECTED] /root]# mysqld --skip-grant-tables bash: mysqld: command not found [EMAIL PROTECTED] /root]# mysql --skip-grant-tables mysql: unrecognized option `--skip-grant-tables' mysql Ver 11.13 Distrib 3.23.36, for redhat-linux-gnu (i386) Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license [EMAIL PROTECTED] /root]# mysql -u root test ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) [EMAIL PROTECTED] /root]# mysql -h webjanrayserveur -u root -p Enter password: ERROR 1130: Host 'webjanrayserveur.webjanray.dyndns.org' is not allowed to connect to this MySQL server [EMAIL PROTECTED] /root]# [EMAIL PROTECTED] /root]# vi .my.cnf #--------------------------------------------------------------------------- ----------------------------------- # DO NOT MODIFY THIS FILE! It is updated automatically by the # e-smith server and gateway software. Instead, modify the source # template in the /etc/e-smith/templates directory. For more # information, see http://www.e-smith.org. # # copyright (C) 1999-2001 e-smith, inc. #------------------------------------------------------------ [client] password=L/C77Y61QNnAR5xSAWnsePnp1ww3uCGdtgHZ1N2EADhosPTqIJl1P0rbXjMoZ9X9Kxm zEm3b0r6O #------------------------------------------------------------ # TEMPLATE END #------------------------------------------------------------ ~ [EMAIL PROTECTED] phpmyadmin]# vi config.inc.php /* $Id: config.inc.php,v 1.62 2001/12/23 23:05:23 lem9 Exp $ */ /** * phpMyAdmin Configuration File * * All directives are explained in Documentation.html */ /** * Bookmark Table Structure * * CREATE TABLE bookmark ( * id int(11) DEFAULT '0' NOT NULL auto_increment, * dbase varchar(255) NOT NULL, * user varchar(255) NOT NULL, * label varchar(255) NOT NULL, * query text NOT NULL, * PRIMARY KEY (id) * ); * */ /** * Your phpMyAdmin url * * Complete the variable below with the full url ie * http://www.your_web.net/path_to_your_phpMyAdmin_directory/ */ $cfgPmaAbsoluteUri = ''; /** * Server(s) configuration */ // The $cfgServers array starts with $cfgServers[1]. Do not use $cfgServers[0]. // You can disable a server config entry by setting host to ''. $cfgServers[1]['host'] = 'webjanrayserbeur'; // MySQL hostname $cfgServers[1]['port'] = ''; // MySQL port - leave blank for default port $cfgServers[1]['socket'] = ''; // Path to the socket - leave blank for default socket $cfgServers[1]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket') $cfgServers[1]['stduser'] = ''; // MySQL standard user settings (this user must have read-only $cfgServers[1]['stdpass'] = ''; // access to the "mysql/user" and "mysql/db" tables) $cfgServers[1]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)? $cfgServers[1]['user'] = 'root'; // MySQL user $cfgServers[1]['password'] = 'L/C77Y61QNnAR5xSAWnsePnp1ww3uCGdtgHZ1N2EADhosPTqIJl1P°rbXjM0Z9XçKxmzEm3bor6 O'; // MySQL password (only needed with basic auth) $cfgServers[1]['only_db'] = ''; // If set to a db-name, only this db is displayed at left frame // It may also be an array of db-names $cfgServers[1]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname $cfgServers[1]['bookmarkdb'] = ''; // Bookmark db - leave blank for no bookmark support $cfgServers[1]['bookmarktable'] = ''; // Bookmark table - leave blank for no bookmark support $cfgServers[2]['host'] = ''; "config.inc.php" 514L, 18466C Question: je passe a coté de quoi? Merci Linux-Azur : http://www.linux-azur.org Désinscriptions: http://www.linux-azur.org/liste.php3 **** Pas de message au format HTML, SVP ****
