[Phpmyadmin-devel] Access denied for user: 'wwwrun@localhost' in /home/admin/www/mysql/lib.inc.php3 on line 6
Hello, Currently trying the latest "stable" tree, and since the "mysql_db_query deprecate" (lem9, http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpmyadmin/phpMyAdmin/lib.inc... ), I get this error... (php4.0.5, using adv_auth and std_auth). Warning: MySQL Connection Failed: Access denied for user: 'wwwrun@localhost' (Using password: NO) in /home/admin/www/mysql/lib.inc.php3 on line 6 Warning: MySQL: A link to the server could not be established in /home/admin/www/mysql/lib.inc.php3 on line 6 In the setup, the user is "mysql", not "wwwrun" (that is the webserver id). Isn't this a bug ? :) Also tried the new "user admin feature": just look great, but also also maybe not ready: GRANT Select, Insert, Update, Delete, Create, Drop, Reload, Shutdown, Process, File, References, Index, Alter ON cyphor.* TO 'olivier'@'%' with grant option MySQL a répondu: Can't find any matching row in the user table --> on my mysql server, ther user-table looks like that: CREATE TABLE user ( Host char(60) NOT NULL, User char(16) NOT NULL, Password char(16) NOT NULL, Select_priv enum('N','Y') DEFAULT 'N' NOT NULL, Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL, Update_priv enum('N','Y') DEFAULT 'N' NOT NULL, Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL, Create_priv enum('N','Y') DEFAULT 'N' NOT NULL, Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL, Reload_priv enum('N','Y') DEFAULT 'N' NOT NULL, Shutdown_priv enum('N','Y') DEFAULT 'N' NOT NULL, Process_priv enum('N','Y') DEFAULT 'N' NOT NULL, File_priv enum('N','Y') DEFAULT 'N' NOT NULL, Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL, References_priv enum('N','Y') DEFAULT 'N' NOT NULL, Index_priv enum('N','Y') DEFAULT 'N' NOT NULL, Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL, PRIMARY KEY (Host, User) ); so the fields name are not corresponding... Maybe a mysql-version compatiiblity problem ? (MySQL 3.23.30-gamma) Loic: thanks for your NS4-display fixes: now looks and works perfect, merci :) Regards & thanks for your work! It these bugs can be fixed this week-end, what about a new pre-release next week, and then a _real_ release ? Olivier -- _________________________________________________________________ Olivier Mueller - om@8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
Bonsoir Olivier (and list :) "Olivier M." a écrit :
Hello,
Currently trying the latest "stable" tree, and since the "mysql_db_query deprecate" (lem9, http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpmyadmin/phpMyAdmin/lib.inc... ), I get this error... (php4.0.5, using adv_auth and std_auth
Warning: MySQL Connection Failed: Access denied for user: 'wwwrun@localhost' (Using password: NO) in
/home/admin/www/mysql/lib.inc.php3 on line 6 Warning: MySQL: A link to the server could not be established in /home/admin/www/mysql/lib.inc.php3 on line 6
In the setup, the user is "mysql", not "wwwrun" (that is the webserver id). Isn't this a bug ? :)
Hmmm, if I get the latest stable cvs and run it here, with Apache 1.3.20, PHP 4.0.5 and MySQL 3.23.38, I have no problem. However, I had weird MySQL problems and solved them by compiling MySQL with gcc 2.95.3, not egcs. A lot of people on the mysql list have those problems: the show databases and show tables don't work, if compiled with the wrong compiler.
Also tried the new "user admin feature": just look great, but also also maybe not ready:
GRANT Select, Insert, Update, Delete, Create, Drop, Reload, Shutdown, Process, File, References, Index, Alter ON cyphor.* TO 'olivier'@'%' with grant option MySQL a répondu: Can't find any matching row in the user table
Do you really have this combination of user olivier and hostname % in your user table?
--> on my mysql server, ther user-table looks like that: CREATE TABLE user ( Host char(60) NOT NULL, User char(16) NOT NULL, Password char(16) NOT NULL, Select_priv enum('N','Y') DEFAULT 'N' NOT NULL, Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL, Update_priv enum('N','Y') DEFAULT 'N' NOT NULL, Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL, Create_priv enum('N','Y') DEFAULT 'N' NOT NULL, Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL, Reload_priv enum('N','Y') DEFAULT 'N' NOT NULL, Shutdown_priv enum('N','Y') DEFAULT 'N' NOT NULL, Process_priv enum('N','Y') DEFAULT 'N' NOT NULL, File_priv enum('N','Y') DEFAULT 'N' NOT NULL, Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL, References_priv enum('N','Y') DEFAULT 'N' NOT NULL, Index_priv enum('N','Y') DEFAULT 'N' NOT NULL, Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL, PRIMARY KEY (Host, User) );
so the fields name are not corresponding... Maybe a mysql-version compatiiblity problem ? (MySQL 3.23.30-gamma)
The grant syntax does not use the internal field names of the user table, so I don't see a problem here.
Loic: thanks for your NS4-display fixes: now looks and works perfect, merci :)
Regards & thanks for your work! It these bugs can be fixed this week-end, what about a new pre-release next week, and then a _real_ release ? Olivier --
On Sat, Jun 02, 2001 at 07:42:46PM -0400, Marc Delisle wrote:
Currently trying the latest "stable" tree, and since the "mysql_db_query deprecate" (lem9, http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpmyadmin/phpMyAdmin/lib.inc... ), I get this error... (php4.0.5, using adv_auth and std_auth
Warning: MySQL Connection Failed: Access denied for user: 'wwwrun@localhost' (Using password: NO) in
/home/admin/www/mysql/lib.inc.php3 on line 6 Warning: MySQL: A link to the server could not be established in /home/admin/www/mysql/lib.inc.php3 on line 6
In the setup, the user is "mysql", not "wwwrun" (that is the webserver id). Isn't this a bug ? :)
Hmmm, if I get the latest stable cvs and run it here, with Apache 1.3.20, PHP 4.0.5 and MySQL 3.23.38, I have no problem.
Just tried on another server (running "official" mysql+php+apache, installed via RPM), and I get exactely the same ugly warnings as on my server with "hand-made" php, mysql and apache. I have to comment these lines in lib.inc.php3 to make it disapear: //if (isset($db)) { // mysql_select_db($db); //}
However, I had weird MySQL problems and solved them by compiling MySQL with gcc 2.95.3, not egcs. A lot of people on the mysql list have those problems: the show databases and show tables don't work, if compiled with the wrong compiler.
the tables and db are showed, no problem about that here...
GRANT Select, Insert, Update, Delete, Create, Drop, Reload, Shutdown, Process, File, References, Index, Alter ON cyphor.* TO 'olivier'@'%' with grant option MySQL a répondu: Can't find any matching row in the user table
Do you really have this combination of user olivier and hostname % in your user table?
yes I do.
so the fields name are not corresponding... Maybe a mysql-version compatiiblity problem ? (MySQL 3.23.30-gamma)
The grant syntax does not use the internal field names of the user table, so I don't see a problem here.
ah ok, I never used GRANT yet (doing this by hand in the mysql-db directely). Well, this warning-problem is quite strange, especially if I'm the only one seeing them :) Olivier -- _________________________________________________________________ Olivier Mueller - om@8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
"Olivier M." a écrit :
On Sat, Jun 02, 2001 at 07:42:46PM -0400, Marc Delisle wrote:
Currently trying the latest "stable" tree, and since the "mysql_db_query deprecate" (lem9, http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phpmyadmin/phpMyAdmin/lib.inc... ), I get this error... (php4.0.5, using adv_auth and std_auth
Warning: MySQL Connection Failed: Access denied for user: 'wwwrun@localhost' (Using password: NO) in
/home/admin/www/mysql/lib.inc.php3 on line 6 Warning: MySQL: A link to the server could not be established in /home/admin/www/mysql/lib.inc.php3 on line 6
(...)
I have to comment these lines in lib.inc.php3 to make it disapear: //if (isset($db)) { // mysql_select_db($db); //}
You were right, even if I cannot reproduce the problem here, but others in the sourceforge forum experienced the bug. I just commented the lines in both cvs. Maybe a 2.2.0pre5 right now?
On Sun, Jun 03, 2001 at 10:17:17PM -0400, Marc Delisle wrote:
I have to comment these lines in lib.inc.php3 to make it disapear: //if (isset($db)) { // mysql_select_db($db); //}
You were right, even if I cannot reproduce the problem here, but others in the sourceforge forum experienced the bug.
strange...
I just commented the lines in both cvs. Maybe a 2.2.0pre5 right now?
rather a pre4-2. but sourceforge's webserver is currently down (for example http://sourceforge.net/project/showfiles.php?group_id=23067 ) so I can't re-release it right now. Olivier -- _________________________________________________________________ Olivier Mueller - om@8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
participants (2)
-
Marc Delisle -
Olivier M.