mit dem reinen mysql befehl kann ich folgendermaßen noch connecten:
- Code: Select all
mysql --defaults-file=/opt/lampp/etc/my.cnf --user=root --password=pass
jedoch gibt
- Code: Select all
mysql_fix_privilege_tables --defaults-file=/opt/lampp/etc/my.cnf --user=root --password=pass
folgendes aus:
- Code: Select all
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!
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 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Creating the new table and column privilege tables
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Changing name of columns_priv.Type -> columns_priv.Column_priv
You can ignore any errors from this
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Fixing the func table
You can ignore any Duplicate column errors
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Ich vermute mal ganz einfach, dass man da keine parameter angeben kann und man default nehmen muss.
Was mach ich jetzt ?