MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 181 to 190 of 361 total results

https://dev.mysql.com/doc/refman/5.7/en/alter-procedure.html

By default, that privilege is granted automatically to the procedure creator. ALTER PROCEDURE proc_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL ...

6.2.10 Assigning Account Passwords

https://dev.mysql.com/doc/refman/5.7/en/assigning-passwords.html

For complete details on other possibilities, see Section 13.7.1.2, “CREATE USER Statement”, Section 13.7.1.1, “ALTER USER Statement”, Section 13.7.1.4, “GRANT Statement”, and Section 13.7.1.7, “SET PASSWORD Statement”. Required ...

6.1.5 How to Run MySQL as a Normal User

https://dev.mysql.com/doc/refman/5.7/en/changing-mysql-user.html

For example: [mysqld] user=user_name If your Unix machine itself is not secured, you should assign passwords to the MySQL root account in the grant tables. On Windows, you can run the server as a Windows service using a normal user account. On ...

4.2.2.1 Using Options on the Command Line

https://dev.mysql.com/doc/refman/5.7/en/command-line-options.html

Program options specified on the command line follow these rules: Options are given after the command name. An option argument begins with one dash or two dashes, depending on whether it is a short form or long form of the option name. For example, ...

5.1.11.1 Connection Interfaces

https://dev.mysql.com/doc/refman/5.7/en/connection-interfaces.html

By granting the privilege to administrators and not to normal users (who should not need it), an administrator who also has the PROCESS privilege can connect to the server and use SHOW PROCESSLIST to diagnose problems even if the maximum number of ... This section describes aspects of how the MySQL server manages client ...

13.1.12 CREATE EVENT Statement

https://dev.mysql.com/doc/refman/5.7/en/create-event.html

As granting such privileges entails a potential for abuse, extreme care must be taken in doing so. CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] ...

13.7.3.1 CREATE FUNCTION Statement for Loadable Functions

https://dev.mysql.com/doc/refman/5.7/en/create-function-loadable.html

If the server is started with the --skip-grant-tables option, functions registered in the table are not loaded and are unavailable. CREATE [AGGREGATE] FUNCTION function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This ...

13.1.16 CREATE PROCEDURE and CREATE FUNCTION Statements

https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html

By default, MySQL automatically grants the ALTER ROUTINE and EXECUTE privileges to the routine creator. By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name ...

13.7.1.2 CREATE USER Statement

https://dev.mysql.com/doc/refman/5.7/en/create-user.html

To assign privileges to this account, use one or more GRANT statements. CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ... [REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH resource_option [resource_option] ...] ...

13.1.21 CREATE VIEW Statement

https://dev.mysql.com/doc/refman/5.7/en/create-view.html

The standard says that the definer of the view, which is the same as the owner of the view's schema, gets applicable privileges on the view (for example, SELECT) and may grant them. If the view does not exist, CREATE OR REPLACE VIEW is the same as ...

Displaying 181 to 190 of 361 total results