![]() ![]() You can now configure Media Server to connect to the database (see Configure Media Server). In MySQL, there are two ways to find the names of all tables, either by using the show keyword or by query INFORMATIONSCHEMA.In the ODBC Data Source Administrator dialog box, click OK to close the dialog box. In this case, you may need to run separate databases for testing and production. Multiple databases on the same host can be useful in a variety of situations. This name is used to identify the instance when connecting to it. In the MySQL Connector/ODBC Data Source Configuration dialog box, click OK to close the dialog box. What Is Instance Name In Mysql An instance name in MySQL is a name that is given to a specific instance of a MySQL server. 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 Go to Start > Programs > Microsoft SQL Server > Configuration Tools. Select the MySQL ODBC Unicode driver from the list and click Finish. For MS SQL Server 2005-2017 - Launch the SQL Server Configuration Manager. 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. GRANT EXECUTE ON databaseName.* TO userName 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. Optional.This step enables you to use the command mysql to start the mysql command-line tool from the Windows Command Prompt. Database CommentĮnter a description of your database here for organizational use. If you select an existing user, this field is disabled. If you are creating a new user, re-enter the same password as above here. If you are creating a new user, enter a password for that user here. For security reasons, having a MySQL user for each database is recommended so that any compromised site or credentials cannot be used to access your other databases. Here you can create a new MySQL user or select an existing one from a drop-down menu if any exist. Creating a hostname for each domain is generally recommended to prevent downtime should you remove a domain from your account in the future, and find out that other sites used a hostname on it and no longer functions. Here you can create a new hostname or select an existing one from a drop-down menu if any exist. Once you have created the database, you cannot rename it. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |