tu as raison, j'ai vu ce script ds les how to et les docs, mais je ne l'ai pas trouvé ds l'arborescence de sme. ----- Original Message ----- From: "Aubin Galinotti" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, March 18, 2002 9:39 PM Subject: Re: [tech]mysql access denied
il y as un script a lancer pour creer la base initiale sous redhat le script est lancer tout seul au premier demarrage mais je suppose que ce n'est pas forcement vrai partout ... NoxIn On Mon, 2002-03-18 at 21:39, Ludovic Janray wrote: > 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 **** Linux-Azur : http://www.linux-azur.org Désinscriptions: http://www.linux-azur.org/liste.php3 **** Pas de message au format HTML, SVP **** Linux-Azur : http://www.linux-azur.org Désinscriptions: http://www.linux-azur.org/liste.php3 **** Pas de message au format HTML, SVP ****
