← Back to team overview

sslug-teknik team mailing list archive

Re: problemer med min mysql server

 

ALM wrote:
> Found old stye password for user root. Restart using --old-protocol

Prøv at
1) back'e MySQL's /var/lib/mysql katalog op
2) køre mysql_fix_privilege_tables

Om mysql_fix_privilege_tables:

------------------------------------------------------------------------
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func table to MySQL 3.22.14 and above.

This is needed if you want to use the new GRANT functions or
want to use the more secure passwords.

If you get Access denied errors, you should run this script again
and give the MySQL root user password as a argument!

If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name' or
'Table 'func' already exists'. You can safely ignore these!
------------------------------------------------------------------------

-- 
Greetings from Troels Arvin, Copenhagen, Denmark
http://www.mdb.ku.dk/tarvin/


References