Note: This is the part where I might do most of my entries — searching for stuff within the database. Not quite running reports — that’s later. Select (variable name) from (table name) — returns all records For example: Select Read more…
Category: Blog Development
CREATE DATABASE southwind; /*creates a new database and names it*/ SHOW DATABASES; /*displays all databases*/ USE southwind; /*tells mysql which database you want to work with*/ SELECT DATABASE; /*tells you which database has been selected*/ SHOW TABLES; /*displays any tables Read more…
Desired Outcome OK -Understanding root and its password -Understanding user account that has root privs within mysqladmin -Understanding privs within mysqladmin and mysql -Confirming that the sql server is created correctly re: ip address, etc -Confirming the UbuntuServer is configured Read more…
Desired Outcome Confirm installation and configuration of phpMyAdmin, to managed SQL Server databases on a local UbuntuServer. Note: I think I had partially gone down this path before on a CentOS Server – http://www.paulgarth.com/phpmyadmin-installing-on-centos7/ What is phpMyadmin? – https://docs.phpmyadmin.net/en/latest/intro.html phpMyAdmin Read more…