Differences

This shows you the differences between two versions of the page.

--- mysql:change_passwords [2016/10/13 23:05] – peter
+++ mysql:change_passwords [2020/07/15 09:30] (current) – external edit 127.0.0.1
@@ Line 25: / Line 25: @@
-===== Login without a password =====
-If you wish to setup "root" or any user login without having to supply password on command-prompt, you may create .my.cnf file in your home directory. MySQL reads this file each time it opens the MySQL client. Create the ~/.my.cnf file. [Note: ~ represents your HOME directory path in
-Linux]
-<file mysql .my.cnf>
-[client]
-user=root
-password=root-password
-host=127.0.0.1
-[mysql]
-database = database-name
-</file>
-Be sure to modify the permission of the file to limit access to yourself, so that other users on the system cannot view this file.
-<code bash>
-chmod 600 ~/.my.cnf
-</code>