{"id":11556,"date":"2019-03-14T12:18:27","date_gmt":"2019-03-14T12:18:27","guid":{"rendered":"http:\/\/www.appservgrid.com\/paw92\/?p=11556"},"modified":"2019-03-14T12:18:27","modified_gmt":"2019-03-14T12:18:27","slug":"how-to-connect-to-mysql-without-root-password-on-terminal","status":"publish","type":"post","link":"https:\/\/www.appservgrid.com\/paw92\/index.php\/2019\/03\/14\/how-to-connect-to-mysql-without-root-password-on-terminal\/","title":{"rendered":"How to Connect to MySQL Without Root Password on Terminal"},"content":{"rendered":"

Normally while installing\u00a0MySQL\/MariaDB<\/strong>\u00a0database server on Linux, it\u2019s recommended to set a MySQL root user password to secure it, and this password is required to access the database server with root user privileges.<\/p>\n

Suggested Read:<\/b>\u00a0How to Install and Secure MariaDB 10 in CentOS 7<\/a><\/p>\n

In this guide, we will show you how to connect and run MySQL commands without entering a password (mysql passwordless root login) on the Linux terminal.<\/p>\n

How to Set MySQL Root Password<\/h3>\n

In case you have freshly installed the MySQL\/MariaDB server, then it doesn\u2019t require any password to connect to it as root user. To secure it, set the MySQL\/MariaDB password for root user with the following command.<\/p>\n

Note that this command is just one of the many\u00a0MySQL (Mysqladmin) Commands for Database Administration<\/a>in Linux.<\/p>\n

# mysqladmin -u root password YOURNEWPASSWORD<\/strong>\r\n<\/pre>\n
How to Connect or Run MySQL Without Root Password<\/h3>\n
To run MySQL commands without entering password on the terminal, you can store your user and password in the\u00a0~\/.my.cnf<\/code>\u00a0user specific configuration file in user\u2019s home directory as described below.<\/p>\n
Now create the config file\u00a0~\/.my.cnf<\/code>\u00a0and add configurations below in it (remember to replace\u00a0mysqluser<\/strong>\u00a0and\u00a0mysqlpasswd<\/strong>\u00a0with your own values).<\/p>\n
[mysql]\r\nuser=user\r\npassword=password\r\n<\/pre>\n
Save and close the file. Then set the suitable permissions on it, to make it only readable and writable by you.<\/p>\n
# chmod 0600 .my.cnf\r\n<\/pre>\n
Once you have set user and password in the Mysql configuration file, from now on when you run mysql commands such as mysql, mysqladmin etc, they will read the mysqluser and mysqlpasswd from the above file.<\/p>\n
# mysql \r\n# mysql -u root \r\n<\/pre>\n
\n
\"Run<\/a><\/p>\n
Run Mysql- Commands Without Root Password<\/p>\n<\/div>\n
You may also like to read these related articles about MySQL\/MariaDB:<\/p>\n
    \n
  1. \n
      \n
    1. 20 MySQL (Mysqladmin) Commands for Database Administration in Linux<\/a><\/li>\n
    2. How to Change Root Password of MySQL or MariaDB in Linux<\/a><\/li>\n
    3. How to Reset MySQL or MariaDB Root Password in Linux<\/a><\/li>\n
    4. 15 Useful MySQL\/MariaDB Performance Tuning and Optimization Tips<\/a><\/li>\n
    5. 4 Useful Commandline Tools to Monitor MySQL Performance in Linux<\/a><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
      In this guide, we showed how to run MySQL commands without entering root password on the terminal. If you have any queries or thoughts to share, do hit us up via the feedback form below.<\/p>\n
      Source<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
      Normally while installing\u00a0MySQL\/MariaDB\u00a0database server on Linux, it\u2019s recommended to set a MySQL root user password to secure it, and this password is required to access the database server with root user privileges. Suggested Read:\u00a0How to Install and Secure MariaDB 10 in CentOS 7 In this guide, we will show you how to connect and run … <\/p>\n
      Continue reading “How to Connect to MySQL Without Root Password on Terminal”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-11556","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/11556","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/comments?post=11556"}],"version-history":[{"count":1,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/11556\/revisions"}],"predecessor-version":[{"id":11557,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/11556\/revisions\/11557"}],"wp:attachment":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/media?parent=11556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/categories?post=11556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/tags?post=11556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}