![]() ![]() 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. Under the data source name, set the following parameters. This file is usually stored in the /etc directory.Īdd the data source name in square brackets. ![]() ![]() Open the odbc.ini file with a text editor.If you have the relevant Yum repository, you can run the command in the terminal: sudo yum install mysql-connector-odbc If you have the relevant Yum repository, you can run the command in the terminal: sudo yum install unixODBC Install unixODBC driver manager version 2.2.14 or later. Is the user name that Media Server will connect as. Is the name of the database you created in Step 2. 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 to the MySQL server 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 3. In the terminal, run the 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. If the directory path is not added to the PATH variable, you must specify the mysql.exe file path in the terminal to start mysql. This step enables you to use the command mysql to start the mysql command-line tool from the terminal. So that Media Server can send large amounts of binary data (images) to the database, set the configuration parameter max_allowed_packet=1073741824.Īdd the MySQL bin directory path to the PATH environmental variable by running the command: export PATH=$PATH: binDirectoryPath.Open the configuration or options file for the MySQL server (usually named my.ini).Ĭonfigure the database server for use with Media Server:.(Ensure that the package includes the mysql command-line tool.) For instructions, refer to the MySQL documentation on To set up a MySQL Media Server database on Linux The procedure describes how to set up a MySQL database on a CentOS 6 distribution. To use Media Server with a MySQL database, you must install a MySQL server and ODBC driver, and configure Media Server to connect to the database through the driver. Open topic with navigation Set Up a MySQL Database on Linux ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |