Collection : Mysql Change User Password

Subscribe dengan Account Google untuk mendapatkan News Letter terbaru dari Halovina !
Collection : Mysql Change User Password
Drone Kamera Jarak Jauh Fotografi Udara

Drone Kamera Jarak Jauh Fotografi Udara

resolusi kamera 4K, sehingga gambar lebih tajam, dan gambar dapat di lihat dengan jelas. dapat berputar 360°, aplikasi wificam, drone dapat di pantau dari handphone, Terbang dengan ketinggian 50m, jarak kontrol maksimum 1000m. Waktu penerbangan 30 menit, waktu pengisian daya 60 menit.

Free Klik Disini !

How to change user password on mysql


Mysql change user password using the following method:

  1. Open the bash shell and connect to the server as root user:
    mysql -u root -h localhost -p

  2. Run ALERT mysql command:
    ALTER USER 'userName'@'localhost' IDENTIFIED BY 'New-Password-Here';

  3. Finally type SQL command to reload the grant tables in the mysql database:
    FLUSH PRIVILEGES;


Please note that use mysql.exe on MS-Windows host as follows (first change directory where mysql.exe is located [example: “C:\Program Files\mysql\mysql-5.0.77-win32\bin“]. Let us see examples and syntax in details.

mysql command to change a user password


Login as root from the shell:
$ mysql -u root -p
Switch to mysql database (type command at mysql> prompt, do not include string “mysql>”):
mysql> use mysql;
The syntax is as follows for mysql database server version 5.7.5 or older:







SET PASSWORD FOR 'user-name-here'@'hostname' = PASSWORD('new-password');








For mysql database server version 5.7.6 or newer use the following syntax:







ALTER USER 'user'@'hostname' IDENTIFIED BY 'newPass';








You can also use the following sql syntax:







UPDATE mysql.user SET Password=PASSWORD('new-password-here') WHERE USER='user-name-here' AND Host='host-name-here';








In this example, change a password for a user called tom:







SET PASSWORD FOR 'tom'@'localhost' = PASSWORD('foobar');








OR







UPDATE mysql.user SET Password=PASSWORD('foobar') WHERE USER='tom' AND Host='localhost';








Sample outputs:
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Feel free to replace the values for “tom” (user), “localhost” (hostname), and “foobar” (password) as per your requirements. Finally, type the following command to reload privileges:







FLUSH PRIVILEGES;








Sample outputs:
Query OK, 0 rows affected (0.00 sec)

To exit from mysql> prompt, enter:







quit;








Read other article :

reference : cyberciti.biz