Skip to content
Friday, May 27, 2022

DBA Notes

DBA Notes
  • AWS
  • Oracle
  • Postgres
  • Linux
  • Docker
  • MySQL
DBA Notes

Categories

  • AWS (2)
    • EC2 (1)
  • Docker (7)
  • General (2)
  • Linux (7)
  • MySQL (3)
  • notepad++ (2)
  • Oracle (19)
  • Postgres (53)
    • Index (9)
      • Bloom (1)
      • BRIN (1)
      • BTree (1)
      • GIN (1)
      • GIST (1)
      • Hash (1)
      • RUM (1)
      • SP-Gist (1)
    • pgpool (1)
  • SQL (8)
  • WSL (2)
Linux MySQL

MySQL login root without password in Linux

Bulent Soylu March 2, 2022 linuxmysql
vim ~/.my.cnf

[client]
user=root
password=<your password>

to add more users just add more user and password in ~/.my.cnf

[mysql]
user=user
password=pass
[mysqladmin]
user=user
password=pass

Related posts:

  1. Docker linux add sudoers, alias commit image
  2. How to Configure and Use PAM in Linux
  3. Adding postgres as SUDOERS in centos
  4. How to Configure Virtual IP Address (VIP) on CentOS

Post navigation

Previous Previous post: Install MySQL Docker
Next Next post: DBA Interview Questions
Log in

You may also like

  1. Docker linux add sudoers, alias commit image
  2. How to Configure and Use PAM in Linux
  3. Adding postgres as SUDOERS in centos
  4. How to Configure Virtual IP Address (VIP) on CentOS

linux (6)mysql (1)

Recent Posts

  • Export Import statistics with dbms_stats in Oracle
  • Oracle Version Numbers
  • Find password for database link (<= 11.2.0.2)!
  • How to check progress of a long running statistics gathering job
  • Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS

Archives

  • March 2022 (10)
  • February 2022 (2)
  • January 2022 (6)
  • December 2021 (3)
  • November 2021 (7)
  • October 2021 (51)
  • September 2021 (4)

[s2Member-Security-Badge v="2" /]

DBA Notes | Designed by: Theme Freesia | WordPress | © Copyright All right reserved