MariaDB: Difference between revisions

>Samthecrazyman
m Removed redundant code tags
>Samthecrazyman
m Readded pre tags due to number lists failing
Line 15: Line 15:


# Open Konsole
# Open Konsole
# At the command prompt, type:
# At the command prompt, type: <pre># mysqladmin -u root password newpassword</pre> For example, if you wanted to change your password to computer, type: <pre># mysqladmin -u root password computer</pre>
# mysqladmin -u root password newpassword
# Remember, you password is in plain sight on the command prompt. Make sure no one sees you typing and clear the screen afterwards by typing at the prompt: <pre># clear</pre> You may also want to clear your scrollback. This can be done in the 'Tools' menu of Konsole.
For example, if you wanted to change your password to computer, type:
# Test your new password by logging into MySQL. Type at the prompt: <pre># mysql -u root -p</pre>
# mysqladmin -u root password computer
# Remember, you password is in plain sight on the command prompt. Make sure no one sees you typing and clear the screen afterwards by typing at the prompt:
# clear
You may also want to clear your scrollback. This can be done in the 'Tools' menu of Konsole.
# Test your new password by logging into MySQL. Type at the prompt:
# mysql -u root -p
# Type your password when asked.
# Type your password when asked.
# If you've logged in OK, exit by typing:
# If you've logged in OK, exit by typing: <pre>mysql> exit;</pre>(Don't forget the ;). MySQL will respond with 'Bye' if you have correctly exited and return you to the prompt.
mysql> exit;
(Don't forget the ;). MySQL will respond with 'Bye' if you have correctly exited and return you to the prompt.
# If your stuck and MySQL is returning <code>-></code> at any time, you have forgotten the ; at the end of the command. Type the command with a ;. This will display an error message. Type the command again with the ; and the command will work
# If your stuck and MySQL is returning <code>-></code> at any time, you have forgotten the ; at the end of the command. Type the command with a ;. This will display an error message. Type the command again with the ; and the command will work