User Tools

Site Tools


dba:tools:start

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
dba:tools:start [2025/11/20 16:46] mlivolsidba:tools:start [2025/11/30 17:14] (current) mlivolsi
Line 1: Line 1:
 ==== A tool to mimic SQL*PLus but for MySQL ==== ==== A tool to mimic SQL*PLus but for MySQL ====
  
 +  * The script below is called "msql" and the syntax: 
 +      * msql username/password@instance:schema
 +  * Location: /usr/local/bin
 +  * TNS File location: /etc/mysql/network/admin/tnsnames.mysql
 +
 +** Usage **
 +
 +<code>
 +msql <username>/<password>@entry:schema
 +</code>
 +
 +
 +** An example entry **
 <code> <code>
 db01,db = db01,db =
 ( (
     (connect_data =     (connect_data =
-      (host = db.m)+      (host = db1.mikelivolsi.com)
       (schema = some_schema)       (schema = some_schema)
       (port = 3306)       (port = 3306)
Line 12: Line 25:
 </code> </code>
  
 +** The code to make it all work **
 <code> <code>
 #!/bin/bash #!/bin/bash
dba/tools/start.1763657204.txt.gz · Last modified: by mlivolsi