When the Mycheckpoint is installed, this secret is discovered when the user is given permission to do so:
Copy Code code as follows:
Mysql>
Mysql> GRANT all privileges in mycheckpoint.* to ' mycheckpoint_user ' @ ' localhost '
User management of the MySQL database user and log management database1.mysql user account management user account [email protected] Username: Account name host: Which client host requests this account can create connection threads, which can be IP,
MySQL user's permission to EXECUTE stored procedures bitsCN. comMySQL EXECUTE the stored procedure permission as EXECUTE
For example, you have created the following stored procedure in a database named configdb. the stored procedure is defined as
MySQLStudy-MySQL User and permission management MySQL server uses the MySQL permission table to control user access to the database. the MySQL permission table is stored in the mysql database and initialized by the mysql_install_db script. These
In MySQL, the user executes the stored procedure as EXECUTE. For example, we created the following stored procedure in the database named configdb. The stored procedure is defined as user_adminuseconfigdb; dropprocedureifexistssp_dev_test_user_add;
In MySQL, the user's permission to EXECUTE stored procedures is EXECUTE.
For example, you have created the following stored procedure in a database named configdb. The stored procedure is defined as user_admin.
Use configdb;
Drop procedure if exists
In MySQL, the user's permission to EXECUTE stored procedures is EXECUTE.For example, you have created the following stored procedure in a database named configdb. The stored procedure is defined as user_admin.Use configdb;Drop procedure if exists sp_
As the platform of data management, the security of the database is determined by the internal security and network security of the system first. For system administrators, the first thing to ensure the security of the system itself, when installing
Mud: mysql HELP command instructions, mud mysql
Do you need to remember many mysql commands when installing, managing, and using mysql. In addition, for beginners, there are not many commands that do not know how to apply them. For veterans, many
Mud: mysql HELP command instructions, mud mysql
This article was sponsored by Xiuyi linfeng and first launched in the dark world.
Do you need to remember many mysql commands when installing, managing, and using mysql. In addition, for beginners,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.