mysql pw will nicht

[mosa]

hallo, die ersten Gehversuche mit mysql und schon sitze ich mehrere Stunden fest....
Ich möchte das root@mysql passwort ändern, nur-- ich schaffe es nicht?

sool:~# mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
sool:~# mysqld
051220 16:59:25 Can't start server: Bind on TCP/IP port: Address already in use
051220 16:59:25 Do you already have another mysqld server running on port: 3306 ?
051220 16:59:25 Aborting

051220 16:59:25 mysqld: Shutdown Complete

sool:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld...already running.
sool:~# mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
sool:~# mysqld
051220 17:00:23 Can't start server: Bind on TCP/IP port: Address already in use
051220 17:00:23 Do you already have another mysqld server running on port: 3306 ?
051220 17:00:23 Aborting

051220 17:00:23 mysqld: Shutdown Complete


PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h spica password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

sool:~# /usr/bin/mysqladmin -u root password 'luna257'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

sool:~#

[Sarem_Avuton]

Hallo mosa

Nun es sieht so aus als hättest Du schon ein Passwort vergeben.

Code: Alles auswählen

mysql -u root -p

Dann frgat er dich nach dem Passwort.

Grüsse Jörg

[mosa]

hi Sarem_Avuton,

a, nur ich weiss es nicht mehr, darum möchte ich es löschen, bzw. neu erstellen, aber wie?

[Alberti]

Guten Morgen,

das steht im Handbuch :

http://dev.mysql.com/doc/refman/4.0/de/ ... sions.html