![]() ![]() You can now configure Media Server to connect to the database (see Configure Media Server).In the ODBC Data Source Administrator dialog box, click OK to close the dialog box. In the MySQL Connector/ODBC Data Source Configuration dialog box, click OK to close the dialog box. If the connection failed, use the information in the message to resolve any issues.Ĭlick OK to close the Connection Test box. The Connection Test box opens containing a message describing whether the connection was successful. The name of the database that you created in Step 2. The password for the user account that connects to the database server. The user name to connect to the database server with. The port to use to communicate with the database server. The IP address or hostname of the server that the database server is installed on. Media Server can use this string to connect to the database server.Īn optional description for the data source. The MySQL Connector/ODBC Data Source Configuration dialog box opens.Ĭomplete the Connection Parameters fields: Data Source Name Select the MySQL ODBC Unicode driver from the list and click Finish. The Create New Data Source dialog box opens. The ODBC Data Source Administrator dialog box opens. In the Windows Control Panel, click System and Security. Is the user name that Media Server will connect as. Syntax CREATE DATABASE databasename CREATE DATABASE Example The following SQL statement creates a database called 'testDB': Example CREATE DATABASE testDB Tip: Make sure you have admin privilege before creating any database. GRANT EXECUTE ON databaseName.* TO userName The CREATE DATABASE statement is used to create a new SQL database. GRANT SELECT, INSERT, UPDATE, DELETE ON databaseName.* TO userName Run the GRANT commands: GRANT CREATE TEMPORARY TABLES ON databaseName.* TO userName If security is not a consideration, grant all privileges. Grant privileges to the user that Media Server will connect as. Running the script non-interactively from the terminal ensures that the script terminates if an error occurs. Is the name of the database you created in Step 2. In the Windows Command Prompt, run the following command: mysql -u userName -p -v -D databaseName -e "source path/my.sql" This script sets up the database schema that Media Server requires. Run the my.sql script provided in the Media Server installation directory. Database nameĪny that is compatible with the encoding.įor example: CREATE DATABASE myDatabase CHARACTER SET utf8 COLLATE utf8_unicode_ci Run a CREATE DATABASE command to create a new database. In the Windows Command Prompt, run the command: mysql -u userName -p 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. \MY_TEST_INSTANCE, given that that's the name you chose for the instance.This step enables you to use the command mysql to start the mysql command-line tool from the Windows Command Prompt. It will also run at every boot if you have chosen the default settings for the services.Īs soon as it's running in the background, you can connect to it with Management Studio by connecting to. In it, the database files will be placed, so it should be on a drive that has enough space.Ĭlick further through the wizard, and when it's finished, your MSSQL instance will be up and running. Also, choose wisely the Instance root directory. Call it something unique/descriptive like MY_TEST_INSTANCE or the like. There you will set the name of your MSSQL Server Instance. Just give attention to the step Instance Configuration. For your scenario (it sounds like you mainly want to test some stuff), the default options should suffice. ![]() after running the installer.Ĭlick through the steps. It also lacks some other features (Server Agents, AFAIR), but it's good for some experiments.ĭownload it from the Microsoft Website and go through the installer process by choosing New SQL Server stand-alone installation. You can start off with Microsoft SQL Server Express, which is a 10GB-limited, free version of MSSQL. By default, there should be no MSSQL Server installed on your machine, assuming that you use a desktop Windows (7,8,10.). That is, installing all the needed files and services and database files. You need to install a so-called Instance of MSSQL server on your computer. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |