ich habe folgende Probleme seit dem Update auf LAMPP und damit auf die MySQL Version 4.x (vorher 3.23.7). Will ich mit Webmin einen Benutzer hinzufügen oder ein Tabellenzugriffsrecht setzen kommt folgender Fehler:
- Code: Select all
Fehler beim Speichern der Datenbankrechte : SQL update db set user = 'phprojekt', host = 'localhost', db = 'phprojekt', Select_priv='Y' , Insert_priv='Y' , Update_priv='Y' , Delete_priv='Y' , Create_priv='Y' , Drop_priv='Y' , Grant_priv='Y' , References_priv='Y' , Index_priv='Y' , Alter_priv='Y' , ='N' , ='N' where user = 'uniob' and host = 'localhost' and db = 'phprojekt' schlug fehl:
Das passiert mit Webmin (egal ob Standard oder dem LAMPP Addon)...
Ein Kollege sagte mir, ich solle doch mal mysql_fix_privilege_tables testen, aber das bringt mir trotz korrektem root Passwort folgenden Fehler:
- Code: Select all
alpha1:/opt/lampp/bin# ./mysql_fix_privilege_tables -pxxxxx
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func tables to MySQL 3.22.14 and above.
This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23
If you get 'Access denied' errors, you should run this script again
and give the MySQL root user password as an argument!
Converting all privilege tables to MyISAM format
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name'. You can safely ignore these!
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
Adding columns needed by GRANT .. REQUIRE (openssl)
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
Creating the new table and column privilege tables
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
Changing name of columns_priv.Type -> columns_priv.Column_priv
You can ignore any Unknown column errors from this
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
Fixing the func table
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
Adding new fields used by MySQL 4.0.2 to the privilege tables
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
Sorry für die langen "Screenshots", aber kann mir bitte jemand "schnell" helfen? Ich weiß da zzt echt nicht weiter...
Gruß Tim
