Atikh's DBA blog
  • Home
  • Oracle
  • MySQL
  • MongoDB
  • PostgreSQL
  • Snowflake
  • About Me
  • Contact Us
Showing posts with label mysql login login to mysql database. Show all posts
Showing posts with label mysql login login to mysql database. Show all posts

Login to MySQL Database on Linux

 Atikh Shaikh     login to mysql database on linux, mysql, mysql login login to mysql database     1 comment   

Below is method to login to mysql database on Linux server
$mysql -h <hostname> -u <username> -p <database name>
it will prompt for password,once you enter password it will connect to mysql instance
If you want enter at command prompt only then put the password just after -p without space
$mysql -h <hostname> -u <username> -pPassword <database name>
where
hostname– is server name or IP address where mysql database is running
username – is user already available in database with login permission
MySQL help commands
on system level
  mysql –help
In database level
   mysql>help DROP TABLE

Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Instagram
  •  Pin
  •  linkedin
  •  reddit
Older Posts Home

Author

Atikh Shaikh
View my complete profile

Categories

  • MongoDB (18)
  • Oracle 12c (30)
  • Oracle12cR2 New Feature (3)
  • PostgreSQL (21)
  • RMAN (10)
  • Snowflake (8)
  • mysql (23)
  • oracle (75)

Blog Archive

  • ►  2018 (38)
    • ►  November (25)
    • ►  December (13)
  • ►  2019 (33)
    • ►  January (15)
    • ►  February (6)
    • ►  March (2)
    • ►  April (5)
    • ►  May (5)
  • ►  2020 (5)
    • ►  April (1)
    • ►  May (2)
    • ►  July (2)
  • ►  2021 (8)
    • ►  June (3)
    • ►  July (3)
    • ►  August (1)
    • ►  December (1)
  • ►  2022 (33)
    • ►  May (3)
    • ►  June (10)
    • ►  July (3)
    • ►  August (4)
    • ►  September (8)
    • ►  October (3)
    • ►  November (2)
  • ►  2023 (14)
    • ►  February (1)
    • ►  April (5)
    • ►  May (2)
    • ►  June (1)
    • ►  September (1)
    • ►  October (1)
    • ►  December (3)
  • ►  2024 (5)
    • ►  January (2)
    • ►  March (3)
  • ►  2025 (7)
    • ►  March (1)
    • ►  April (3)
    • ►  May (2)
    • ►  August (1)
  • ▼  2026 (3)
    • ►  January (1)
    • ▼  May (2)
      • Oracle Patching Process and Commands
      • Oracle AI Database 26ai: Redefining Operational Co...

Popular Posts

  • ORA-29283: invalid file operation: unexpected "LFI" error (1509)[29437]
    I was trying to export the schema in my windows PC, it got stuck with below error    C:\Users\shaik\Videos\technodba exp>expdp userid...
  • Error Code: 1419. You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
    You must have got mail from application team that they are facing below error while performing operations in database Error: Error Code: ...
  • Oracle DBA Scripts
    Below are some Oracle scripts used in day to day activities note that below script will generate sql statements and then we need to run...
  • Login to MySQL Database on Linux
    Below is method to login to mysql database on Linux server $ mysql -h <hostname> -u <username> -p <database name> ...
  • Oracle AI Database 26ai: Redefining Operational Continuity
    Oracle’s latest release, AI Database 26ai , is built around one clear promise: making enterprise database operations faster, more resilient,...

Labels

oracle Oracle 12c mysql PostgreSQL MongoDB oracle 19c Oracle23c oracle19c Orale PDB-CDB oracle12c python AWS Oracle ASM Virtualbox pluggable database storage engine

Pages

  • Disclaimer
  • Privacy Policy

Follow TechnoDBA

Copyright © Atikh's DBA blog | Powered by Blogger