Login in as an administrator to SQL CLI interface mysql -u root -p Now create a database where the user will belong to CREATE DATABASE TheDatabase; Now let's go ahead and create a user CREATE USER TheUser; Next will be to give permission to the user for … [Read more...] about How to create a MySQL (SQL) database, username, password, and privileges from the CLI?
MySQL
How to setup a LAMP stack using ubuntu server
Why even bother with Linux? Whenever working on a client to server architecture it is always good practice ( in my opinion) to test and implement virtual environments of the actual production of the software project being deployed. In this blog post, I will be … [Read more...] about How to setup a LAMP stack using ubuntu server
How to setup MySQL with java using ubuntu in netbeans?
Assumptions Virtual Ubuntu box is reachable (IE. Network) MySQL setup is running correctly Root password is available! Let's get started | Download jdbc connector Go ahead and get the jdbc connector here or just run the following command Setup … [Read more...] about How to setup MySQL with java using ubuntu in netbeans?
Simple MySQL statments that get used.
mysql> show tables; +----------------------+ | Tables_in_ricardohDB | +----------------------+ | Customer | | FavoriteThings | | Orders | | SalesPerson | | phoneBook | +----------------------+ 5 rows in set … [Read more...] about Simple MySQL statments that get used.
How to create a table and rows in MySQL?
Creating tables in MySQL is a piece of cake since we got are database rolling now, its time to get some tables going. In this example 3 tables will be created, SuperSalesPerson, FancyOrders, BestCustomers. This three tables will hold different types of data and … [Read more...] about How to create a table and rows in MySQL?
How to create a database and Delete a database in MySQL?
In order to create a database to hold all of the tables that are going to be used, the following command will create a database parts that can hold different tables with in it. CREATE DATABASE parts; Nice what if you do a typo? or what if you want to call the … [Read more...] about How to create a database and Delete a database in MySQL?
How to show databases in MySQL?
show databases will show you the available databases which are available to be used. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | ricardohDB | | test … [Read more...] about How to show databases in MySQL?
Getting to know phpMyAdmin with MySQL building a address Book.
Testing out my development environment with XAMPP, I created a HolaMundo.php file to try out my new MySQL database and some echo commands from PHP it seemed simple enough although the dollar signs are a little awkward to type. The file starts with a stage that just … [Read more...] about Getting to know phpMyAdmin with MySQL building a address Book.
