MYSQL – Linux Notes

Passwordless MYSQL Login

/root/.my.cnf:
[client]
user=root
password=yourpassword

Reset MYSQL Password

service mysqld stop
mysqld_safe --skip-grant-tables &

mysql -u root
use mysql;

update user set authentication_string=password('YOURSUPERSECRETPASSWORD') where user='root';
flush privileges;

quit
service mysqld start

create user with password

GRANT ALL PRIVILEGES ON dbTest.* To 'user'@'hostname' IDENTIFIED BY 'password';

update user with password

mysql database server version 5.7.5 or older

SET PASSWORD FOR 'user-name-here'@'hostname' = PASSWORD('new-password');
FLUSH PRIVILEGES;

mysql database server version 5.7.6 or newer

ALTER USER 'user'@'hostname' IDENTIFIED BY 'newPass';
FLUSH PRIVILEGES;

common tuning values

/etc/my.cnf:
innodb-buffer-pool-size        = 32G
innodb-buffer-pool-instances   = 32
max-connections                = 1000

Reading table information for completion of table and column names

It's reading table and column names into a hash in the mysql client program, so you can use autocompletion of names.

If you don't use this feature in the client, then yes, you can speed up startup by using the "-A" option.