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. : Password « User Permission « SQL / MySQL
SQL / MySQL
Insert Delete Update
SQL / MySQL
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.
GRANT ALL ON duckwear.duck_sales TO joss@localhost
WITH GRANT OPTION;
Related examples in the same category
Use Password encode
Change password with mysqladmin
Provide the option -p and then you will be asked for the root password
Set the root password
Set a password for every user
mysqladmin: the MySQL root account, so you need to specify name and password options for that user
Provide the password
Using the SET PASSWORD Statement
Change your password to pw2 for the user account under which you're currently logged on to the system
Setting a password for a user account other than the one you used to log on to the system
Setting the root password
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.
Introduce a new user called BOOKSQL with the password BOOKSQLPW.
Set up a new sample database administrator account with a username of sampadm and a password of secret
Suppose that my MySQL username and password are sampadm and secret. If the MySQL server is running on the same host
Create a user named second with the password pa552 and grant all privileges when logging in from any host.
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.
Connect to the server using the default hostname and username values with no password:
Connect to the server on the local host with a username of myname, asking mysql to prompt you for a password:
Connect to the server at a specific IP address, with a username of myname and password of mypass:
Connect to the server on the local host, using the default username and password and compressing client/server traffic
shell> mysqladmin -u root password 'rootpass'
Change password for root with update statement
If you want to assign passwords to the anonymous accounts
Create user and assign password
Change password with password function
Grant select privilege to a user for a domain with password
The PASSWORD() function encrypts a specified string as a 41-byte hash value: PASSWORD(
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.