Register Login





|

Top Links: >> 80. Technology >> AI-Consulting >> IIQ Training
Current Topic: IIQ - MySQL Install
You have a privilege to create a quiz (QnA) related to this subject and obtain creativity score...
IIQ - MySQL DB Download and Install

To download MySQL DB Community Edition (Free) navigate to this link:

https://dev.mysql.com/downloads/

Navigate to MSI Installer MySQL 32 bit
This will still install 64-bit version for your Operating System (Windows/Linux/etc.)

MySql should be 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
Enter Password: {new_password}

// create a new schema (database) and grant privileges to a new user
mysql>create database identityiq;
mySql>grant all privileges on *.* to 'identityiq'@'localhost' with grant option;
mySql>show databases;

mysql> show databases;
+------------------------+
Was it clear so far? Highlight the text in question Or

| Database |
+------------------------+
| information_schema |
| {your DB_name} |
| mysql |
| performance_schema |
| test |
+------------------------+

Assignments:

1. Download and Install MySQL.
2. Follow the instructions to run the Server Daemon and run MySQL as root
3. In the identityiq - unpacked distribution navigate to the database -directory and find the file "create_identityiq_tables-7.1.mysql"
4. Start MySQL in that directory and Enter these two lines to provide data in the identityiq database.
mysql>use identityiq;
mysql>source create_identityiq_tables-7.1.mysql;

Assignments
Assignments:

1. Download and Install MySQL.
2. Follow the instructions to run the Server Daemon and run MySQL as root
3. In the identityiq - unpacked distribution navigate to the database -directory and find the file "create_identityiq_tables-7.1.mysql"
4. Start MySQL in that directory and Enter these two lines to provide data in the identityiq database.
mysql>use identityiq;
mysql>source create_identityiq_tables-7.1.mysql;


We invite you to create your own questions and answers (QnA) to increase your rank and win the Top Creativity Prize!

Topic Graph | Check Your Progress | Propose QnA | Have a question or comments for open discussion?

Have a suggestion? - shoot an email
Looking for something special? - Talk to AI
Read: IT of the future: AI and Semantic Cloud Architecture | Fixing Education
Do you want to move from theory to practice and become a magician? Learn and work with us at Internet Technology University (ITU) - JavaSchool.com.

Technology that we offer and How this works: English | Spanish | Russian | French

Internet Technology University | JavaSchool.com | Copyrights © Since 1997 | All Rights Reserved
Patents: US10956676, US7032006, US7774751, US7966093, US8051026, US8863234
Including conversational semantic decision support systems (CSDS) and bringing us closer to The message from 2040
Privacy Policy