About the author

Photo of sanduhrs
sanduhrs

MySQL root Passwort setzen

Nach der Installation von MySQL ist in der Regel das root-Passwort nicht gesetzt.
Das sollte unbedingt nachgeholt werden.

In der Konsole gibt man folgende Kommandos ein:

mysql --user=root
update mysql.user set Password=PASSWORD('your_new_root_password') where User='root';
flush privileges;
quit;

Please check syntax because

Please check syntax because there is a mistake on it.
.... Password='Your new Password' .... without bracket's

No, all is well. The part

No, all is well. The part Password=PASSWORD('Your new Password') means, that MySQL will encrypt the password before storage.

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img>
  • Lines and paragraphs break automatically.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.

More information about formatting options

Website powered by lovely Drupal · Microformats · XML Feed · Valid XHTML, CSS · No www.