Re: mysql-server-4.1
Weil wir gerade dabei sind:
On Sam, 27 Mai 2006, Andreas Pakulat wrote:
> > Passwort ändern aus Sicherheitsgründen ist auch nicht notwendig/empfohlen?
>
> Nein, ausserdem ist das Passwort bereits ein zufaellig gewaehltes. Schau
> doch mal in /etc/mysql/debian.cnf.
Mit mysql-server-5X
Ich habe natürlich ein root password erstellt, steht auch im
README.Debian drinnen:
-----
* PASSWORDS:
============
It is strongly recommended to set a password for the mysql root user (which
is NOT the same as the "normal" root user) with the command:
/usr/bin/mysqladmin -u root password 'enter-your-good-new-password-here'
If you already had a password set add " -p " before "-u" to the line above.
-----------
Jetzt regt sich halt das init script auf:
$ /etc/init.d/mysql start
Starting MySQL database server: mysqld.
FIXME: This is still too noisy but will be changed, soon!
This script updates all the mysql privilege tables to be usable by
MySQL 4.0 and above.
This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, stored procedures, or
more secure passwords in 4.1
Got a failure from command:
cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql
Please check the above output and try again.
Running the script with the --verbose option may give you some information
of what went wrong.
If you get an 'Access denied' error, you should run this script again and
give the MySQL root user password as an argument with the --password= option
Checking for crashed MySQL tables in the background.
Das liegt daran dass das init script /etc/mysql/debian-start ausführt
und da steht drinnen:
/usr/bin/mysql_upgrade --defaults-file=/etc/mysql/debian.cnf
was ohne password nicht geht.
Gut gemacht ;-)
Herzliche Grüße
Norbert
-------------------------------------------------------------------------------
Dr. Norbert Preining <preining AT logic DOT at> Università di Siena
gpg DSA: 0x09C5B094 fp: 14DF 2E6C 0307 BE6D AD76 A9C0 D2BF 4AA3 09C5 B094
-------------------------------------------------------------------------------
NASEBY (n.)
The stout metal instrument used for clipping labels on to exhibits at
flower shows.
--- Douglas Adams, The Meaning of Liff
Reply to: