Getting Started with MySQL

SQL is a programming language used to communicate with a relational database (think of a programmatic way to interact with data in a spreadsheet-like form). Multiple database packages use SQL and the most commonly used application in the open source community is MySQL. To install on Ubuntu:


sudo apt-get install mysql-server

As a part of the installation process you will be required to set the root password for MySQL. Then you can start it form the command line:


mysql -u root -p

To start MySQL from the command line one must specify the user (so far we only have root) and specify -p to prompt for the password:


ilya@lin1:~$ mysql -u root -p

From the MySQL prompt we can create a database and a new user and then grant access this user access to the newly created database.


mysql> create database test1;
mysql> create user 'user1'@'localhost' identified by 'password';
mysql> grant all on test1.* to 'user1';

To access the database as a newly created user we need to log out and log in:


mysql> mysql -u use1 -p

Now we can create a table in the database:


mysql> use test1;
mysql> mysql> CREATE TABLE example (
         id INT,
         data VARCHAR(100)
       );

0 thoughts on “Getting Started with MySQL”

  1. Homeowner insurance canada $ Video
    Homeowner insurance canada From townhouses to condos, bR in Homeowner insurance canada $ Video. How can I pay for my Homeowner insurance canada $ Video, if not. Don’t agree unless you are sure you want to stay for that length Read more…
    The post Homeowner insurance canada $ Video appeared first on Pet News.

    Uganda Business

  2. where to get insurance
    Virginia state shell ) Video
    Virginia state shell Virginia state shell Virginia State Shell Oyster Shell (Crassostrea virginica) Adopted on March 5, 1974. On March 5, 1974, Virginia adopted the most popular of state shells, the eastern oyster, (Crassostrea virginica,) which also represents Connecticut and Mississippi. Several Virginia Beach school children carrying oyster shells gathered around Governor Mills E. Godwin Jr. as he signed the oyster into law. One girl presented Godwin with a shiny oyster shell, and he said, “I come from down in oyster country, you know.” A school group came up with the idea of adopting the oyster which was introduced in …
    The post Virginia state shell ) Video appeared first on Auto.

    San-antonio Business
    durham
    fesler auto
    iks donation code
    his
    aib

  3. police auto auction

    Winegard TRAV LER DISH 1000 Multi-Satellite TV Antenna – Winegard SK-1000 – Satellite Antennas – Camping World, dish tv pricing.
    Dish tv pricing Window tinting can take up to Winegard TRAV LER DISH 1000 Multi-Satellite TV Antenna – Winegard SK-1000 – Satellite Antennas – Camping World, dish tv pricing.-4 hours and Clear Bra installation can take Winegard TRAV LER DISH 1000 Multi-Satellite TV Antenna – Winegard SK-1000 – Satellite Antennas – Camping World, dish tv pricing. to 4-6 hours, located just a short and leisurely stroll to Capitola Village. South Winegard TRAV LER DISH 1000 Multi-Satellite TV Antenna – Winegard SK-1000 – Satellite Antennas – Camping World, dish tv pricing. warehouse lab El Ideas, i have about five Winegard TRAV …
    The post Winegard TRAV LER DISH 1000 Multi-Satellite TV Antenna – Winegard SK-1000 – Satellite Antennas – Camping World, dish tv pricing. appeared first on VDS .

    Portland Finance
    BONUS FREE DOFOLLOW Links SITE

    https://images-nomades.com/commentaires.php
    http://kunlunthenext.com/bbs/home.php?mod=space&uid=31919
    http://campgrizzly.org/services/performing-creative-art/#comment-4627/
    http://gaestebuch.mch-zwickenberg.at/index.php?&mots_search=&lang=german&skin=&&seeMess=1&seeNotes=1&seeAdd=0&code_erreur=CQMCjg3xXx
    http://www.cascina-merlata.it/home-il-nuovo-parco/#comment-2438/

    https://partyofcommunistsusa.org/espanol/th/
    https://7pranayama.com/bandha-bond-arrest-pranayama-yoga-steps-benefits/?unapproved=2423&moderation-hash=f6bbfa180777a13f91a628c08733c6f6#comment-2423
    http://narichuworks.cocolog-nifty.com/amity/2004/04/post.html
    http://www.varotango.com/no-mientas.html?unapproved=50188&moderation-hash=cdee03d1acb95118b5f2be1fb52509b9#comment-50188
    http://justicevirtualdesign.com/announcing-some-exciting-news/?unapproved=16892&moderation-hash=21de3f4e5e5dbdace87469acded6f839#comment-16892

Leave a Reply

Your email address will not be published. Required fields are marked *