mysql cheat sheet

User Creation:

CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'test623';
GRANT ALL ON testdb.* TO 'testuser'@'localhost';
FLUSH PRIVILEGES;


Sql Create Table:

 CREATE TABLE Persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
);

Comments

Post a Comment

Popular posts from this blog

Centos 7 Setup Webmin, Virtualmin, Usermin, CSF Firewall and Letsencrypt

Image
useradd    weballround        passwd    weballround          exit                echo "weballround ALL=(ALL)       ALL"  >>    /etc/sudoers            exit                clear                vi    /etc/ssh/sshd_config  (Change #PermitRootLogin yes to PermitRootLogin no) #port 22 Remove  #  and change  22  to your desired port number service sshd restart yum    install    git    -y        git    clone    git://github.com/webmin/webmin.git    /usr/local/webadmin        sudo    ln    -s    `which    perl`    /usr/local/bin/perl    cd /usr/local/webadmin/  /usr/local/bin/per ./local-setup.sh                 yum    install    python-argparse    -y        git    clone    git://github.com/webmin/usermin.git    /usr/local/useradmin        cd    /usr/local/useradmin                sudo    ./local-setup.sh                cd    /opt                mkdir    /usr/local/virtualmin                cd    /usr/local/virtualmin                yum    install    wget   
Read more

Setting Up Out-of-Office Messages in Outlook

Image
Setting Up Out-of-Office Messages in Outlook Learn how to set up email to respond to incoming email with your out-of-office message. In the right place? See also Setting Up Out-of-Office Messages on Outlook Web Access . Collapse all 1. Start your setup. In Outlook, click on File , Info then select Automatic Replies (Out of Office) . Click on Send Automatic Replies and check the Only send during this time range check box. Specify a start and end time for the reply to activate and deactivate using the Start time and End time fields. Enter a message in the Inside My Organization field. This message will be sent to internal UCSD email addresses. 2. Auto reply to external email addresses. Click on the Outside My Organization tab. Make sure Auto-reply to people outside my organization is checked. Enter the message that will be sent to external (non-UCSD) email addresses. Click on OK . 3. Deac
Read more

How to install Openbox

sudo apt install openbox obconf sudo apt install xcompmgr cairo-dock     # create folder and file cd ~/.config mkdir openbox cd openbox # Edit file using any file editing tool like nano, vim, gedit etc nano autostart # Add following entries and save xcompmgr & cairo-dock &   sudo apt-get install menu cp / var / lib / openbox / debian-menu.xml ~ / .config / openbox / debian-menu.xml cp / etc / xdg / openbox / menu.xml ~ / .config / openbox / menu.xml cp / etc / xdg / openbox / rc.xml ~ / .config / openbox / rc.xml openbox --reconfigure     or if X11   cp / etc / X11 / openbox / menu.xml ~ / .config / openbox / menu.xml cp / etc / X11 / openbox / rc.xml ~ / .config / openbox / rc.xml  Adding a panel/taskbar sudo apt-get install tint2     sudo apt-get install feh      
Read more