Tag Info

New answers tagged

0

Any way you do this, you're probably going to have a password saved somewhere. Even MySQL 5.6 login-path is easily decryptable by anyone with the motivation. That warning said, this would be an easy solution. In your environment script (eg ~/.profile or ~/.bashrc), set alias mysql='mysql -uUser -pPasswd -hHostname' (putting in your desired User, Passwd, ...


0

The Nawaz answer is correct. I have little to add. I suggest you do some attempts with the environment variable MYSQL_TEST_LOGIN_FILE to crate a new configuration file, just in case the default file is corrupt. Use also --no-defaults to skip .cnf files. If the password contains the char #, mysql login-path doesn't work. $ export ...


2

Strictly speaking the calculation of the recommended buffer pool size above is not correct. It assumes InnoDB works actively with all data. In practice, InnoDB could only touch a fraction of the database. Check how Innodb_buffer_pool_reads and Innodb_buffer_pool_read_requests changes over time. mysqladmin -r -i 1 ext | grep -e ...



Top 50 recent answers are included