PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html
Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist These messages often occur when the MySQL base or data directories are installed in different locations than the default locations (C:\Program Files\MySQL\MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-length.html
Values such as user name and host names in MySQL account names are strings rather than identifiers. The following table describes the maximum length for each type of identifier. For constraint definitions that include no constraint name, the server ...
https://dev.mysql.com/doc/refman/5.7/en/my-print-defaults.html
To see what options are present in those groups in the standard option files, invoke my_print_defaults like this: $> my_print_defaults mysqlcheck client --user=myusername --password=password --host=localhost The output consists of options, one per ... my_print_defaults displays the options that are present in option groups of option ...
https://dev.mysql.com/doc/refman/5.7/en/perl-installation.html
These tests attempt to connect to the local MySQL server using the default user name and password. (The default user name is your login name on Unix, and ODBC on Windows. The default password is “no password.”) If you cannot connect to the ...
https://dev.mysql.com/doc/refman/5.7/en/setting-environment-variables.html
For example, on Windows, you can set the USER variable to specify your MySQL account name. To do so, use this syntax: SET USER=your_name The syntax on Unix depends on your shell. If your shell is tcsh, add the following line to your .tcshrc file: ...
https://dev.mysql.com/doc/refman/5.7/en/windows-install-archive.html
Users who are installing from the noinstall package can use the instructions in this section to manually install MySQL.
https://dev.mysql.com/doc/refman/5.7/en/faqs-stored-procs.html
If replication or binary logging in general (for the purpose of point-in-time recovery) is active, then MySQL DBAs have two security options open to them: Any user wishing to create stored functions must be granted the SUPER privilege. Are stored ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-views-table.html
DEFINER The account of the user who created the view, in 'user_name'@'host_name' format. This column has most of what you see in the Create Table column that SHOW CREATE VIEW produces. Suppose that the original statement was: CREATE VIEW v AS SELECT ...You must have the SHOW VIEW privilege to access this ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-brokers.html
Create an account at Freenet6 by visiting this URL and signing up: http://gogonet.gogo6.com After creating the account, go to this URL, sign in, and create a user ID and password for the IPv6 broker: ...If so, any accounts you create that name the ...For example: userid=gogouser passwd=gogopass Start gogoc: $> /etc/init.d/gogoc start To start gogoc each time your system boots, execute this command: $> rc-update add gogoc default Use ping6 to try to ping a host: $> ping6 ipv6.google.com To see your IPv6 address: $> ifconfig tun ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. The creator of a routine is the account used to execute the CREATE statement for it. This privilege is granted ...The ALTER ROUTINE privilege is needed to alter or drop stored ...