Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 18155

All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.

1
vote
The very minimal permissions would be: GRANT USAGE ON *.* TO [user@host] ; GRANT SELECT ON mysql.help_topic TO [user@host] ; Do not believe this answer is sufficient. Please check the manual first, because the privilege system in MySQL is far from being obvious. …
answered Jan 17 '13 by RandomSeed
1
vote
Use a subquery to extract the desired search range, then use it like a regular table: SELECT search_range.* FROM ( SELECT * FROM table WHERE name LIKE '%john%' LIMIT 1000 ) AS search_range WHERE …
answered Apr 17 '13 by RandomSeed
2
votes
innodb_log_file_size determines the size of the redo log. In short, this is a temporary storage zone on disk where data changes are buffered before being inserted in the actual table data files. It al …
answered Jun 17 '13 by RandomSeed
-1
votes
The danger of keeping these anonymous accounts accounts has already been very well explained. The manual provides a comprehensive check list of steps to take in order to "Secure the initial MySQL … otherwise possess no privileges. If you want to remove any-user access to test databases, do so as follows: mysql> DELETE FROM mysql.db WHERE Db LIKE 'test%'; mysql> FLUSH PRIVILEGES …
answered Jun 22 '13 by RandomSeed
2
votes
The best (and IMO the only suitable) tool for backuping a MySql database is mysqldump The PhpMyAdmin options you are referring to are meant only to alter the generated statements in your dump (but will not touch your actual data). You might want to refer to this FAQ at PhpMyAdmin. …
answered Apr 16 '13 by RandomSeed
0
votes
Indeed, the part of the manual you quoted does just what it says: -- Connection #1 LOCK TABLE mytable READ; -- lock is acquired -- Connection #2 LOCK TABLE mytable WRITE; -- execution is suspended, …
answered May 19 '14 by RandomSeed
1
vote
actual target version. Also, follow the link "Upgrading from MySQL 4.1 to 5.0", found at the bottom of the Changelog page (sorry, not enough rep' to post more than two hyperlinks :( ) Tip : it is … possible to run multiple instances/versions of MySQL on the same system, in case you don't have a spare server at hand to play with. …
answered Jun 9 '12 by RandomSeed
31
votes
I would instead recommend the official method, which I reproduce here for convenience: To change the number or the size of InnoDB log files in MySQL 5.6.7 or earlier, use the following … innodb_fast_shutdown is not set to 2: Stop the MySQL server and make sure that it shuts down without errors, to ensure that there is no information for outstanding transactions in the redo log …
answered Jun 18 '13 by RandomSeed