Change password : Password « User Permission « SQL / MySQL






  1. SQL / MySQL
  2. User Permission
  3. Password

Change password

  

SET PASSWORD FOR 'JOHN'= PASSWORD('JOHN1');








Related examples in the same category

1.Use Password encode
2.Change password with mysqladmin
3.Provide the option -p and then you will be asked for the root password
4.Set the root password
5.Set a password for every user
6.SET PASSWORD
7.mysqladmin: the MySQL root account, so you need to specify name and password options for that user
8.Provide the password
9.Using the SET PASSWORD Statement
10.Change your password to pw2 for the user account under which you're currently logged on to the system
11.Setting a password for a user account other than the one you used to log on to the system
12.Setting the root password
13.If the password has already been set for the root user, you must add the -p switch to the command and provide the existing password when prompted.
14.Introduce a new user called BOOKSQL with the password BOOKSQLPW.
15.Set up a new sample database administrator account with a username of sampadm and a password of secret
16.Suppose that my MySQL username and password are sampadm and secret. If the MySQL server is running on the same host
17.Create a user named second with the password pa552 and grant all privileges when logging in from any host.
18.Create a user named joss with the password f1refly, logging in from the localhost only, with all privileges plus GRANT OPTION on the duck_sales table only.
19.Create a user named marti on localhost with a password of tick3t, who has ALL privileges on the duck_sales table, and then revoke the DELETE, DROP, and ALTER privileges.
20.Connect to the server using the default hostname and username values with no password:
21.Connect to the server on the local host with a username of myname, asking mysql to prompt you for a password:
22.Connect to the server at a specific IP address, with a username of myname and password of mypass:
23.Connect to the server on the local host, using the default username and password and compressing client/server traffic
24.shell> mysqladmin -u root password 'rootpass'
25.Change password for root with update statement
26.If you want to assign passwords to the anonymous accounts
27.A password
28.Create user and assign password
29.Change password with password function
30.Grant select privilege to a user for a domain with password
31.The PASSWORD() function encrypts a specified string as a 41-byte hash value: PASSWORD()
32.SET PASSWORD=PASSWORD('g00r002b');