How To Use Mysql Shell In Windows

To utilize Media Server with a MySQL database, yous must download and install a MySQL server and ODBC driver, and configure Media Server to connect to the database through the driver.

Download and install a MySQL server and MySQL Connector/ODBC (which contains the Unicode driver). During installation, prepare a user account with superuser privileges. For instructions, refer to the MySQL documentation on www.mysql.com.

Notation:

Once installed, the MySQL server appears in the Services tab in Windows Task Managing director.

Configure the database server for use with Media Server:

Open the configuration or options file for the MySQL server (usually named my.ini).
So that Media Server can send large amounts of binary data (images) to the database, set the configuration parameter max_allowed_packet=1073741824 .
Save and shut the configuration file.

Add the MySQL bin directory path to the PATH environmental variable.

NOTE:

This footstep enables you to employ the command mysql to start the mysql command-line tool from the Windows Command Prompt. If the directory path is not added to the PATH variable, you must specify the mysql.exe file path in the Command Prompt to start psql.

Open up the mysql command line tool:

In the Windows Command Prompt, run the command:

mysql -u                userName                -p

Enter your password when prompted.

Run a CREATE DATABASE command to create a new database. Specify the following database settings.

Database name	Whatsoever proper noun.
Character set	Must be Unicode–either UTF8 or UCS2.
Collation	Any that is compatible with the encoding.

For example:

CREATE DATABASE myDatabase Grapheme Prepare utf8 COLLATE utf8_unicode_ci;

Run the my.sql script provided in the Media Server installation directory. This script sets up the database schema that Media Server requires.

Close the mysql control-line tool:
```
quit
```

In the Windows Command Prompt, run the post-obit command:

mysql -u                userName                -p -v -D                databaseName                -e "source                path/my.sql"

where,

`userName`	is the MySQL user name.
`databaseName`	is the proper name of the database you created in Stride two.
`path`	is the path to the my.sql file.

Annotation:

Running the script non-interactively from the terminal ensures that the script terminates if an fault occurs.

Enter your countersign when prompted.

Grant privileges to the user that Media Server will connect equally. Required privileges are:

Database	Create Temporary Tables
All tables	Select, Insert, Update, Delete
All functions and stored procedures	Execute

If security is not a consideration, grant all privileges.

Offset the mysql command-line tool:
```
mysql
```

Run the GRANT commands:

GRANT CREATE TEMPORARY TABLES ON                databaseName.* TO                userName; GRANT SELECT, INSERT, UPDATE, DELETE ON                databaseName.* TO                userName; GRANT EXECUTE ON                databaseName.* TO                userName;

where,

`databaseName`	is the proper name of the database y'all created in Stride 2.
`userName`	is the user name that Media Server will connect equally.

Shut the mysql command-line tool:
```
quit
```

Open the Data Sources (ODBC) plan:

In the Windows Control Console, click Arrangement and Security.

The System and Security window opens.
Click Authoritative Tools.

The Administrative Tools window opens.
Double-click Data Sources (ODBC).

The ODBC Information Source Administrator dialog box opens.

In the User DSN tab, click Add... .

The Create New Data Source dialog box opens.

Select the MySQL ODBC Unicode commuter from the listing and click Cease.

The MySQL Connector/ODBC Data Source Configuration dialog box opens.

Complete the Connection Parameters fields:

Data Source Name	The information source name (DSN). Cull any string. Media Server tin can use this string to connect to the database server.
Description	An optional clarification for the information source.
TCP/IP Server	The IP address or hostname of the server that the database server is installed on.
Port	The port to use to communicate with the database server.
User	The user name to connect to the database server with.
Password	The password for the user account that connects to the database server.
Database	The proper noun of the database that y'all created in Stride 2.

Click Test to test the connection.

The Connection Test box opens containing a message describing whether the connexion was successful. If the connection failed, use the information in the bulletin to resolve any issues.

Click OK to shut the Connectedness Test box.

In the MySQL Connector/ODBC Data Source Configuration dialog box, click OK to shut the dialog box.

In the ODBC Information Source Administrator dialog box, click OK to close the dialog box.

You tin now configure Media Server to connect to the database (run across Configure Media Server).

Source: https://www.microfocus.com/documentation/idol/IDOL_12_0/MediaServer/Guides/html/English/Content/Getting_Started/Configure/_TRN_Set_up_MySQL.htm

Posted by: musialanated1978.blogspot.com