How to , and other stuff about linux, photo, php … A linux, photography blog. To remember some linux situation, and fix them quickly.

June 11, 2012

How to change MySql root password

Filed under: Linux — Tags: , , — admin @ 2:28 pm

1) Login to mysql server, type the following command at shell prompt:
$ mysql -u root -p
2) Use mysql database (type command at mysql> prompt):
mysql> use mysql;
3) Change password for user root, enter:
mysql> update user set password=PASSWORD("NEWPASSWORD") where User='root';
4) Finally, reload the privileges:
mysql> flush privileges;
mysql> quit

October 25, 2010

mysql pc speaker beep

Filed under: Linux — Tags: , , — admin @ 11:12 pm

Well today I was trying some commands  on mysql and suddenly because my command was wrong speaker blow up my ear.  I know  that  it wasn’t the  sound card speaker and it was the system speaker, so the question remain.

How to disable system speaker for mysql ?

Well after a small search I find out that I have to add –no-beep or -b on mysql command.

So the solution is or to add –no-beep or -b or to make a sql.bat and enter in this file mysql –no-beep

My solution was to modify windows path variable to add path to my mysql directory, and after that I run sql from start>run>sql , and I have a client witch don’t beep me any more.

Hope to help u.

Powered by WordPress