Skip to content

Instantly share code, notes, and snippets.

@3h5a9

3h5a9/mysqlshortcut.txt

Last active October 8, 2020 14:08
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save 3h5a9/79366ecb22f8e7b84609d4b571146d9d to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save 3h5a9/79366ecb22f8e7b84609d4b571146d9d to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. SMEHSAN revised this gist Oct 8, 2020. 1 changed file with 8 additions and 8 deletions.
    16 changes: 8 additions & 8 deletions mysqlshortcut.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -1,17 +1,17 @@
    mysql -u root -p //enter into mysql as root user

    SHOW DATABASES; //Show available databases`
    SHOW DATABASES; //Show available databases

    DROP DATABASE database_name; //Delete a mysql database`
    DROP DATABASE database_name; //Delete a mysql database

    `sudo /etc/init.d/mysql.server start` //start mysql server`
    sudo /etc/init.d/mysql.server start //start mysql server

    `sudo /etc/init.d/mysql.server stop` `//Stop mysql server`
    sudo /etc/init.d/mysql.server stop //Stop mysql server

    `sudo /etc/init.d/mysql.server status` `//Check status of mysql`
    sudo /etc/init.d/mysql.server status //Check status of mysql

    `sudo update-rc.d -f mysql.server defaults` //Enable myql on startup`
    sudo update-rc.d -f mysql.server defaults //Enable myql on startup

    `sudo update-rc.d -f mysql.server remove` `//Disable mysql on startup (Optional)`
    sudo update-rc.d -f mysql.server remove //Disable mysql on startup (Optional)

    `sudo /etc/init.d/mysql.server restart` `//Restart mysql server```
    sudo /etc/init.d/mysql.server restart //Restart mysql server
  2. SMEHSAN revised this gist Oct 8, 2020. 1 changed file with 8 additions and 8 deletions.
    16 changes: 8 additions & 8 deletions mysqlshortcut.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -1,17 +1,17 @@
    mysql -u root -p //enter into mysql as root user

    `SHOW DATABASES; //Show available databases`
    SHOW DATABASES; //Show available databases`

    `DROP DATABASE database_name; //Delete a mysql database`
    DROP DATABASE database_name; //Delete a mysql database`

    `sudo /etc/init.d/mysql.server start //start mysql server`
    `sudo /etc/init.d/mysql.server start` //start mysql server`

    `sudo /etc/init.d/mysql.server stop //Stop mysql server`
    `sudo /etc/init.d/mysql.server stop` `//Stop mysql server`

    `sudo /etc/init.d/mysql.server status //Check status of mysql`
    `sudo /etc/init.d/mysql.server status` `//Check status of mysql`

    `sudo update-rc.d -f mysql.server defaults //Enable myql on startup`
    `sudo update-rc.d -f mysql.server defaults` //Enable myql on startup`

    `sudo update-rc.d -f mysql.server remove //Disable mysql on startup (Optional)`
    `sudo update-rc.d -f mysql.server remove` `//Disable mysql on startup (Optional)`

    ```sudo /etc/init.d/mysql.server restart //Restart mysql server```
    `sudo /etc/init.d/mysql.server restart` `//Restart mysql server```
  3. SMEHSAN revised this gist Oct 8, 2020. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion mysqlshortcut.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -14,4 +14,4 @@ mysql -u root -p //enter into mysql as root user

    `sudo update-rc.d -f mysql.server remove //Disable mysql on startup (Optional)`

    `sudo /etc/init.d/mysql.server restart //Restart mysql server`
    ```sudo /etc/init.d/mysql.server restart //Restart mysql server```
  4. SMEHSAN revised this gist Oct 8, 2020. 1 changed file with 9 additions and 7 deletions.
    16 changes: 9 additions & 7 deletions mysqlshortcut.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -1,15 +1,17 @@
    mysql -u root -p //enter into mysql as root user

    SHOW DATABASES; //Show available databases
    `SHOW DATABASES; //Show available databases`

    DROP DATABASE database_name; //Delete a mysql database
    `DROP DATABASE database_name; //Delete a mysql database`

    sudo /etc/init.d/mysql.server start //start mysql server
    `sudo /etc/init.d/mysql.server start //start mysql server`

    sudo /etc/init.d/mysql.server stop //Stop mysql server
    `sudo /etc/init.d/mysql.server stop //Stop mysql server`

    sudo /etc/init.d/mysql.server status //Check status of mysql
    `sudo /etc/init.d/mysql.server status //Check status of mysql`

    sudo update-rc.d -f mysql.server defaults //Enable myql on startup
    `sudo update-rc.d -f mysql.server defaults //Enable myql on startup`

    sudo update-rc.d -f mysql.server remove //Disable mysql on startup (Optional)
    `sudo update-rc.d -f mysql.server remove //Disable mysql on startup (Optional)`

    `sudo /etc/init.d/mysql.server restart //Restart mysql server`
  5. SMEHSAN created this gist Oct 8, 2020.
    15 changes: 15 additions & 0 deletions mysqlshortcut.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,15 @@
    mysql -u root -p //enter into mysql as root user

    SHOW DATABASES; //Show available databases

    DROP DATABASE database_name; //Delete a mysql database

    sudo /etc/init.d/mysql.server start //start mysql server

    sudo /etc/init.d/mysql.server stop //Stop mysql server

    sudo /etc/init.d/mysql.server status //Check status of mysql

    sudo update-rc.d -f mysql.server defaults //Enable myql on startup

    sudo update-rc.d -f mysql.server remove //Disable mysql on startup (Optional)