Shulou(Shulou.com)06/01 Report--

1.mysql automatic completion method

Method 1. Modify my.cnf

Vi / etc/my.cnf

[mysql]

Auto-rehash # add auto-rehash

Note: modify # no-auto-rehash, remove # and change it to the above one.

Restart the mysql service

Method 2. When the client connects to mysql

Add the parameter auto-rehash when mysql starts

Mysql-uxx-hxx-pxx-auto-rehash

Note: you can only complete the table and column names.

Personal tests can be used.

2.mysql restart method.

. / mysqladmin-uxxx-hxxx shutdown

. / mysqld_safe-- user=root &

The mysqld process is started with the machine user name root, which can also be another user name, but make sure that all tables created by db users have access to db.

The access rights of the process are generally the same as those of the machine user name.

Mysqlpath/etc/my.cnf is used by default when starting, which contains the relevant configuration.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.