...
- Download the latest MySQL version, and use the steps at the MySQL Installation Guide to install it to your server.
Verify that the database user has sufficient privileges to run custom scripts. The user will need System Administrator privileges at least.Anchor databaseuser databaseuser To create a new database user with system administrator privileges to integrate with
, the following script format can be used:Companyname Code Block language sql title Create sysadmin user create login aluser with password='Qwerty1'; go create user aluser for login aluser; go exec sp_addsrvrolemember 'aluser', 'sysadmin'; go
In MySQL, create a custom database named sw2_std, specifying UTF8 character set. You can use the following commands to do this:
Code Block language sql create # or alter database sw2_std DEFAULT CHARACTER SET utf8; mysql> use sw2_std; Database changed mysql> SHOW VARIABLES LIKE 'character_set%';
This will return something like the following:
Code Block +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0,00 sec)
Configure InnoDB. The following parameters are recommended for the
my.cnf
configuration file. Pay attention to the comments, as some of these values can vary depending on your environment. At a minimum, the max_allowed_packet must be set to 16M. For more information, see InnoDB Configuration:Code Block [mysqld] #================mandatory values=============== port = 3306 # This value can be changed. Ask your admin. bind-address = 0.0.0.0 # This value can be changed. Ask your admin. character-set-server = utf8 collation-server = utf8_general_ci explicit_defaults_for_timestamp = 1 innodb_locks_unsafe_for_binlog = 1 innodb_strict_mode = 0 sql-mode = NO_AUTO_VALUE_ON_ZERO innodb_file_format = Barracuda innodb_flush_log_at_trx_commit = 0 default-storage-engine = InnoDB innodb_file_per_table = 1 #================recomended minimum values============== max_connections = 384 max_allowed_packet = 96M query_cache_type = 1 slow_query_log = 1 slow_query_log_file = <SLOW_QUERY_LOG> log_error = <MYSQL_ERROR_LOG> #================optional values================ tmp_table_size = 64M key_buffer_size = 48M query_cache_size = 64M net_read_timeout = 1000 table_open_cache = 2048 connect_timeout = 20 innodb_lock_wait_timeout = 150 innodb_log_files_in_group = 3 innodb_flush_method = O_DIRECT net_write_timeout = 1000 user = enterprisewizard innodb_file_io_threads = 4 innodb_log_buffer_size = 16M innodb_mirrored_log_groups = 1 innodb_log_file_size=<INNODB_LOG_SIZE> tmpdir = <AGILOFT_TMPDIR> innodb_buffer_pool_size = 14000M innodb_additional_mem_pool_size = 100M sort_buffer_size = 5M query_cache_limit = 5M read_buffer_size = 1M join_buffer_size = 5M basedir = <MYSQL_DIR> innodb_data_home_dir = <MYSQL INNODB DIR> innodb_log_group_home_dir = <MYSQL_LOG_DIR>
In Linux, load the MySQL time zone table using the following command on the server where MySQL is installed:
Code Block mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql --host=127.0.0.1 --port=3306 -u root -p <password> mysql;
- Add the default-time-zone entry to the
my.cnf
file. This file is usually located under/etc/my.cnf
. - Set the time zone value to match the server time zone. For example, if the server uses the Pacific time zone, set:
default-time-zone=America/Los_Angeles,
- Restart the MySQL service.
Hide If | ||||||
---|---|---|---|---|---|---|
| ||||||
Related articles
|