Mysql 5.7use database will tell you what to do with the-A parameter.

clipboard.png

problem description

mysql 5.7use database prompts you to add the-A parameter to the mysql 5.7 just installed in the centos7 under the virtual machine
, and that"s it

the environmental background of the problems and what methods you have tried

not even if mysql is reinstalled

when you can only connect, mysql-uroot-p-A
add-A parameter but want to solve this problem

related codes

/ / Please paste the code text below (do not replace the code with pictures)

what result do you expect? What is the error message actually seen?

can solve this problem and can be normal without-A


do you have a lot of datasheet views and so on? Metadata will be cached without the-A parameter, but it will be slow to load when there is too much metadata. Caching these metadata can complete the code automatically, that is, when you press the TAB key to complete the code. With the addition of the-A parameter, there is no longer a completion function. If you don't care, or the loading time is tolerable, just ignore the prompt.


first of all, this is not an error message, there is no need to struggle, or explain the reason, think of other ways?
secondly, if you want to avoid this information, MySQL explicitly tells you that the solution is to add-A, but you have to find another way;
finally, you can deceive yourself by adding the no-auto-rehash parameter under [client] of my.cnf, so you don't have to add-An every time.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bdacc5-31224.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1bdacc5-31224.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?