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.in…
), 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
--