Current Topic: 2.3.1. MySQL DB Download and Install
You have a privilege to create a quiz (QnA) related to this subject and obtain creativity score...
MySQL DB Download and Install
To download MySQL DB Community Edition (Free) navigate to this link:
https://dev.mysql.com/downloads/
Select 64-bit version for your Operating System (Windows/Linux/etc.)
Download and unpack.
For Windows OS, we recommend unpack it to C:\tools\mysql - directory (Change from default download)
After the installation, if this is the Windows OS, navigate to the Control Panel - System - Advanced - Environment Variables
Add to the PATH variables in the SYSTEM section - c:\tools\mysql\bin
So, the system will always find and run MySQL executables.
// start the server daemon
>mysqld
or if MySql was installed as a service
>service mysqld start
// make a password for the root account
>mysqladmin -u root password '{new_password}'
//Run MySQL as root (You must provide the password):
// -u option must followed by a username and -p must end the line before pressing the ENTER
// the system will ask you to Enter Password
>mysql -u root -p
Was it clear so far?
Enter Password: {new_password}
// create a new schema (database) and grant privileges to a new user
mysql>create database {db name};
mySql>grant all privileges on {db name}.* to {user_name}@localhost identified by '{new_db_password}';
mySql>show databases;
mysql> show databases;
+------------------------+
| Database |
+------------------------+
| information_schema |
| {your DB_name} |
| mysql |
| performance_schema |
| test |
+------------------------+
Assignments Assignments:
1. Install the MySQL database
2. Make notes on any troubles you have
3. Email your notes (if no troubles - just say "No Troubles") to dean@ituniversity.us
>> 80. Technology >> Internet Technology Summit Program >> 2. Java and Databases >> 2.3. Oracle